public AdminVO LoginAdmin(string userName, string password) { DataTable dt = com.DefaultSearch("Admin", "LoginName", userName, "AdminPassword", HashCode(password)); AdminVO ad = new AdminVO(); ad.OperatingEmployeeID = dt.Rows[0][3].ToString(); ad.LoginName = userName; ad.AdminPassword = password; ad.AccountType = Convert.ToInt32(dt.Rows[0][2].ToString()); ad.AdminID = Convert.ToInt32(dt.Rows[0][4].ToString()); return(ad); }
private void button1_Click(object sender, EventArgs e) { AdminVO ad = new AdminVO(tNIC.Text, tLoginName.Text, Convert.ToInt32(Type.SelectedValue.ToString()), Convert.ToInt32(ID.Text)); if (mb.UpdateAdmin(ad)) { MessageBox.Show("Update Successful"); } else { MessageBox.Show("Update Failed"); } cb.FillDataGrid(AdminView, "Admin"); AdminView.Columns["AdminPassword"].Visible = false; }
private void NewEntry_Click(object sender, EventArgs e) { AdminVO ad = new AdminVO(tNIC.Text, tLoginName.Text, Convert.ToInt32(Type.SelectedValue.ToString()), mb.HashCode("Admin")); if (mb.RegisterAdmin(ad)) { MessageBox.Show("Update Successful"); } else { MessageBox.Show("Update Failed"); } cb.FillDataGrid(AdminView, "Admin"); AdminView.Columns["AdminPassword"].Visible = false; Refresh(); }
public bool UpdateAdmin(AdminVO du) { try { DataTable dt = new DataTable(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Rows.Add(new object[] { du.OperatingEmployeeID, du.LoginName, du.AccountType, du.AdminID }); return(mem.UpdateAdmin(dt)); } catch (Exception ee) { MessageBox.Show(ee.ToString()); return(false); } }
public bool RegisterAdmin(AdminVO d) { try { DataTable dt = new DataTable(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Rows.Add(new Object[] { d.OperatingEmployeeID, d.LoginName, d.AccountType, d.AdminPassword }); return(mem.InsertAdmin(dt)); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
private void Login_Click(object sender, EventArgs e) { try { //MySqlConnection con = new MySqlConnection(@DBStr.connectionString);//"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Kasun\source\WebSites\WebSite4\App_Data\Database.mdf;Integrated Security=True"); //MySqlDataAdapter sql = new MySqlDataAdapter("select count(*) from Admin where LoginName='" + UserName.Text + "' AND AdminPassword='******'", con); //DataTable dt = new DataTable(); //DataTable type = new DataTable(); //sql.Fill(dt); bool x = mem.CheckAdminPassword(UserName.Text, AdminPassword.Text); if (x)//dt.Rows[0][0].ToString() == "1" { AdminVO ad = mem.LoginAdmin(UserName.Text, AdminPassword.Text); //MySqlDataAdapter check = new MySqlDataAdapter("select AccountType,OperatingEmployeeID from Admin where LoginName='" + UserName.Text + "' AND AdminPassword='******'", con); //check.Fill(type); Log.LoginName = UserName.Text; Log.OperatingEmployee = ad.OperatingEmployeeID.ToString(); //type.Rows[0][1].ToString(); Log.Type = ad.AccountType.ToString(); //type.Rows[0][0].ToString(); int type = ad.AccountType; if (type == 1) { this.Hide(); Payment p = new Payment(); p.Show(); } else if (type == 2) { this.Hide(); Contribution c = new Contribution(); c.Show(); } else if (type == 3) { this.Hide(); MemberAccount m = new MemberAccount(); m.Show(); } else if (type == 4) { this.Hide(); MainAdmin m = new MainAdmin(); m.Show(); } else { MessageBox.Show("You Do not have system privilleges"); } } else { MessageBox.Show("Check your username or password"); } } catch (Exception ee) { MessageBox.Show(ee.ToString()); } }