new_user.md

title	author	date	output
new_user	Micheal	Tuesday, May 12, 2015	html_document

Create New End-User

###//system references using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; ###//references for connecting to MySql database using MySql.Data.MySqlClient;

namespace HIS_Manager { public partial class frmNew_User : Form { public frmNew_User() { InitializeComponent(); }

//declaration of variables to be used within the program

    string connectionString;
    MySqlConnection con;
    MySqlCommand cmd;

//connection string for the C# application to MySql database

    private void New_User_Load(object sender, EventArgs e)
    {
        connectionString = "Server=127.0.0.1;Database=his_record;Uid=root;Pwd=password;";
        con = new MySqlConnection(connectionString);
        con.Open();

    }

//inserting data from the textbox controls into the MySql database (saving users' login details)

    private void btnSave_Click(object sender, EventArgs e)
    {
        cmd = con.CreateCommand();
        cmd.CommandText = "INSERT INTO Logins(firstName, lastName, Username, Password, Module_Access)VALUES(@firstname, @lastname, @username, @password, @module_access)";
        cmd.Parameters.AddWithValue("@firstname", txtFName.Text);
        cmd.Parameters.AddWithValue("@lastname", txtLName.Text);
        cmd.Parameters.AddWithValue("@username", txtUsername.Text);
        cmd.Parameters.AddWithValue("@password", txtPassword.Text);
        cmd.Parameters.AddWithValue("@module_access", txtProfile.Text);
        
        cmd.ExecuteNonQuery();

        MessageBox.Show("New User Created");           
        this.Close();                        
    }

//close this module

    private void btnCancel_Click(object sender, EventArgs e)
    {
        this.Close();            
    }
   
}

}