private void emp_restriction_current_user_Load(object sender, EventArgs e) { Emp_Restriction er, er2 = new Emp_Restriction(); er2.empid = Global.CURRENT_USER.empid; er = er2.SELECT_BY_ID(); //LOOP THROUGH ALL RESTRICTIONS THEN ADD A CHECKBOX FOR EACH RESTRICTION GenereateCheckBoxes(er); }
private void tztpassword_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode.ToString().Equals("Return")) { Employee emp, emp1 = new Employee(); emp1.empid = txtid.Text; String hash; using (MD5 md5Hash = MD5.Create()) { hash = Global.GetMd5Hash(md5Hash, txtpassword.Text); } emp1.password = hash; emp = emp1.SELECT_BY_IDPASS(); //MessageBox.Show(hash); if (emp != null) { Global.CURRENT_USER.empid = emp.empid; Global.CURRENT_USER = emp; Global.CURRENT_USER.pic = emp.GET_IMAGE_BY_ID(); Global.CURRENT_USER.basic_pay = emp.GET_BASIC_PAY(); Global.CURRENT_USER.emp_status = emp.GET_EMPLOYMENT_STATUS(); Global.CURRENT_USER.position = emp.GET_CURRENT_POSITION(); Global.CURRENT_USER.branch = emp.GET_BRANCH_ASSIGNMENT(); //CREATE A RESTRICTION OBJECT Emp_Restriction r = new Emp_Restriction(); //SET CURRENT USER RESTRICTION r.empid = Global.CURRENT_USER.empid; Global.CURRENT_USER.restriction = r.SELECT_BY_ID(); Global.CURRENT_USER.LIST_BENEFITS(); //GET CURRENT USER LATEST SCHEDULE Emp_Sched es = new Emp_Sched(); es.empid = Global.CURRENT_USER.empid; Global.CURRENT_USER.schedule = es.SELECT_BY_EMPID(); Global.CURRENT_USER.ISLOGGEDIN = true; frmMain f = new frmMain(); f.Show(); this.Hide(); } else { MessageBox.Show("Nothing found"); } } }
protected void chk_checkchanged(object sender, EventArgs e) { Emp_Restriction er = new Emp_Restriction(); er.empid = emp.empid; // identify which button was clicked and perform necessary actions CheckBox chk = sender as CheckBox; if (er.Toggle(emp.empid, chk.Name, chk.Checked)) { chk.Checked = chk.Checked; } else { MessageBox.Show("There was a problem updating restriction. : \n" + db.err.Message); chk.Checked = chk.Checked; } }
private void cboEmp_SelectedIndexChanged(object sender, EventArgs e) { pnlrestrictions.Controls.Clear(); if (cboEmp.Text != "") { String[] c = cboEmp.Text.ToString().Split('-'); String id = c[1]; Employee emp1, emp2 = new Employee(); emp2.empid = id; emp1 = emp2.SELECT_BY_ID(); emp = emp1; //emp1.SELECT_BY_ID(); emp1.GET_IMAGE_BY_ID(); String pos = (emp1.GET_CURRENT_POSITION() != "") ? emp1.position.ToString() : "NO_POSITION_INDICATED"; lblemp.Text = emp1.lname.ToUpper() + ", " + emp1.fname.ToUpper() + " " + emp1.mname.ToUpper() + " - " + pos; if (emp1.pic != null) { MemoryStream ms = new MemoryStream(emp1.pic); pb.Image = Image.FromStream(ms); pb.SizeMode = PictureBoxSizeMode.Zoom; } else { pb.Image = Properties.Resources.noimagefound; pb.SizeMode = PictureBoxSizeMode.Zoom; } //GET THE RESTRICTIONS Emp_Restriction er, er2 = new Emp_Restriction(); er2.empid = emp.empid; er = er2.SELECT_BY_ID(); //LOOP THROUGH ALL RESTRICTIONS THEN ADD A CHECKBOX FOR EACH RESTRICTION GenereateCheckBoxes(er); } }
}//end save public Emp_Restriction SELECT_BY_ID() { DataTable dt = new DataTable(); MySqlCommand cmd = new MySqlCommand(); db.SET_COMMAND_PARAMS(cmd, "EMP_RESTRICTION_BYEMPID"); cmd.Parameters.AddWithValue("_empid", empid); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(dt); if (dt != null) { if (dt.Rows.Count > 0) { Emp_Restriction er = new Emp_Restriction(); DataRow r = dt.Rows[0]; er.empid = r["empid"].ToString(); er.CAN_ADD_EMP_SCHED = (Boolean)r["CAN_ADD_EMP_SCHED"]; er.CAN_ADD_EMPLOYEE = (Boolean)r["CAN_ADD_EMPLOYEE"]; er.CAN_ADD_LEAVE = (Boolean)r["CAN_ADD_LEAVE"]; er.CAN_ADD_LOAN = (Boolean)r["CAN_ADD_LOAN"]; er.CAN_ADD_PASS_SLIP = (Boolean)r["CAN_ADD_PASS_SLIP"]; er.CAN_ADD_PROPERTIES = (Boolean)r["CAN_ADD_PROPERTIES"]; er.CAN_ADD_SCHEDULE_TEMPLATE = (Boolean)r["CAN_ADD_SCHEDULE_TEMPLATE"]; er.CAN_ADD_SERVICE_REQUEST = (Boolean)r["CAN_ADD_SERVICE_REQUEST"]; er.CAN_ADD_SUPPLIES = (Boolean)r["CAN_ADD_SUPPLIES"]; er.CAN_ADD_SUPPLY_REQUEST = (Boolean)r["CAN_ADD_SUPPLY_REQUEST"]; er.CAN_APPLY_LOAN = (Boolean)r["CAN_APPLY_LOAN"]; er.CAN_CHANGE_PASSWORD = (Boolean)r["CAN_CHANGE_PASSWORD"]; er.CAN_LOG_IN = (Boolean)r["CAN_LOG_IN"]; er.CAN_RECOMMEND = (Boolean)r["CAN_RECOMMEND"]; er.CAN_UPDATE_EMP_SCHED = (Boolean)r["CAN_UPDATE_EMP_SCHED"]; er.CAN_UPDATE_EMPLOYEE = (Boolean)r["CAN_UPDATE_EMPLOYEE"]; er.CAN_UPDATE_LEAVE = (Boolean)r["CAN_UPDATE_LEAVE"]; er.CAN_UPDATE_PASS_SLIP = (Boolean)r["CAN_UPDATE_PASS_SLIP"]; er.CAN_UPDATE_RESTRICTION = (Boolean)r["CAN_UPDATE_RESTRICTION"]; er.CAN_VIEW_ATTENDANCE = (Boolean)r["CAN_VIEW_ATTENDANCE"]; er.CAN_VIEW_LOAN = (Boolean)r["CAN_VIEW_LOAN"]; er.CAN_VIEW_PROPERTIES = (Boolean)r["CAN_VIEW_PROPERTIES"]; er.CAN_VIEW_SERVICE_REQUEST = (Boolean)r["CAN_VIEW_SERVICE_REQUEST"]; er.CAN_VIEW_SUPPLIES = (Boolean)r["CAN_VIEW_SUPPLIES"]; er.CAN_VIEW_SUPPLY_REQUEST = (Boolean)r["CAN_VIEW_SUPPLY_REQUEST"]; er.CAN_VIEW_RESTRICTION = (Boolean)r["CAN_VIEW_RESTRICTION"]; er.CAN_VIEW_EMPLOYEE = (Boolean)r["CAN_VIEW_EMPLOYEE"]; er.CAN_VIEW_LEAVE = (Boolean)r["CAN_VIEW_LEAVE"]; er.CAN_VIEW_PASS_SLIP = (Boolean)r["CAN_VIEW_PASS_SLIP"]; er.CAN_VIEW_MEMBERS = (Boolean)r["CAN_VIEW_MEMBERS"]; er.CAN_VIEW_EMP_SCHEDULE = (Boolean)r["CAN_VIEW_EMP_SCHEDULE"]; er.CAN_VIEW_PROFILE = (Boolean)r["CAN_VIEW_PROFILE"]; er.CAN_ADMINISTER_EMPLOYEE = (Boolean)r["CAN_ADMINISTER_EMPLOYEE"]; er.CAN_ADMINISTER_LOAN = (Boolean)r["CAN_ADMINISTER_LOAN"]; er.CAN_ADMINISTER_LEAVE = (Boolean)r["CAN_ADMINISTER_LEAVE"]; er.CAN_ADMINISTER_PASS_SLIP = (Boolean)r["CAN_ADMINISTER_PASS_SLIP"]; er.CAN_ADMINISTER_RESTRICTION = (Boolean)r["CAN_ADMINISTER_RESTRICTION"]; er.CAN_ADMINISTER_SCHEDULE = (Boolean)r["CAN_ADMINISTER_SCHEDULE"]; er.CAN_ADMINISTER_MEMBER = (Boolean)r["CAN_ADMINISTER_MEMBER"]; er.CAN_ADMINISTER_SUPPLY_REQUEST = (Boolean)r["CAN_ADMINISTER_SUPPLY_REQUEST"]; er.CAN_ADMINISTER_SERVICE_REQUEST = (Boolean)r["CAN_ADMINISTER_SERVICE_REQUEST"]; er.CAN_ADMINISTER_ATTENDANCE = (Boolean)r["CAN_ADMINISTER_ATTENDANCE"]; er.CAN_ADMINISTER_CUTOFF = (Boolean)r["CAN_ADMINISTER_CUTOFF"]; return(er); } else { return(null); } } else { return(null); } }
public Emp_Restriction SELECT_BY_ID() { DataTable dt = new DataTable(); MySqlCommand cmd = new MySqlCommand(); db.SET_COMMAND_PARAMS(cmd, "EMP_RESTRICTION_BYEMPID"); cmd.Parameters.AddWithValue("_empid", empid); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(dt); if (dt != null) { if (dt.Rows.Count > 0) { Emp_Restriction er = new Emp_Restriction(); DataRow r = dt.Rows[0]; er.empid = r["empid"].ToString(); er.CAN_ADD_EMP_SCHED = (Boolean)r["CAN_ADD_EMP_SCHED"]; er.CAN_ADD_EMPLOYEE = (Boolean)r["CAN_ADD_EMPLOYEE"]; er.CAN_ADD_LEAVE = (Boolean)r["CAN_ADD_LEAVE"]; er.CAN_ADD_LOAN = (Boolean)r["CAN_ADD_LOAN"]; er.CAN_ADD_PASS_SLIP = (Boolean)r["CAN_ADD_PASS_SLIP"]; er.CAN_ADD_PROPERTIES = (Boolean)r["CAN_ADD_PROPERTIES"]; er.CAN_ADD_SCHEDULE_TEMPLATE = (Boolean)r["CAN_ADD_SCHEDULE_TEMPLATE"]; er.CAN_ADD_SERVICE_REQUEST = (Boolean)r["CAN_ADD_SERVICE_REQUEST"]; er.CAN_ADD_SUPPLIES = (Boolean)r["CAN_ADD_SUPPLIES"]; er.CAN_ADD_SUPPLY_REQUEST = (Boolean)r["CAN_ADD_SUPPLY_REQUEST"]; er.CAN_APPLY_LOAN = (Boolean)r["CAN_APPLY_LOAN"]; er.CAN_CHANGE_PASSWORD = (Boolean)r["CAN_CHANGE_PASSWORD"]; er.CAN_LOG_IN = (Boolean)r["CAN_LOG_IN"]; er.CAN_RECOMMEND = (Boolean)r["CAN_RECOMMEND"]; er.CAN_UPDATE_EMP_SCHED = (Boolean)r["CAN_UPDATE_EMP_SCHED"]; er.CAN_UPDATE_EMPLOYEE = (Boolean)r["CAN_UPDATE_EMPLOYEE"]; er.CAN_UPDATE_LEAVE = (Boolean)r["CAN_UPDATE_LEAVE"]; er.CAN_UPDATE_PASS_SLIP = (Boolean)r["CAN_UPDATE_PASS_SLIP"]; er.CAN_UPDATE_RESTRICTION = (Boolean)r["CAN_UPDATE_RESTRICTION"]; er.CAN_VIEW_ATTENDANCE = (Boolean)r["CAN_VIEW_ATTENDANCE"]; er.CAN_VIEW_LOAN = (Boolean)r["CAN_VIEW_LOAN"]; er.CAN_VIEW_PROPERTIES = (Boolean)r["CAN_VIEW_PROPERTIES"]; er.CAN_VIEW_SERVICE_REQUEST = (Boolean)r["CAN_VIEW_SERVICE_REQUEST"]; er.CAN_VIEW_SUPPLIES = (Boolean)r["CAN_VIEW_SUPPLIES"]; er.CAN_VIEW_SUPPLY_REQUEST = (Boolean)r["CAN_VIEW_SUPPLY_REQUEST"]; er.CAN_VIEW_RESTRICTION = (Boolean)r["CAN_VIEW_RESTRICTION"]; er.CAN_VIEW_EMPLOYEE = (Boolean)r["CAN_VIEW_EMPLOYEE"]; er.CAN_VIEW_LEAVE = (Boolean)r["CAN_VIEW_LEAVE"]; er.CAN_VIEW_PASS_SLIP = (Boolean)r["CAN_VIEW_PASS_SLIP"]; er.CAN_VIEW_MEMBERS = (Boolean)r["CAN_VIEW_MEMBERS"]; er.CAN_VIEW_EMP_SCHEDULE = (Boolean)r["CAN_VIEW_EMP_SCHEDULE"]; er.CAN_VIEW_PROFILE = (Boolean)r["CAN_VIEW_PROFILE"]; er.CAN_ADMINISTER_EMPLOYEE = (Boolean)r["CAN_ADMINISTER_EMPLOYEE"]; er.CAN_ADMINISTER_LOAN = (Boolean)r["CAN_ADMINISTER_LOAN"]; er.CAN_ADMINISTER_LEAVE = (Boolean)r["CAN_ADMINISTER_LEAVE"]; er.CAN_ADMINISTER_PASS_SLIP = (Boolean)r["CAN_ADMINISTER_PASS_SLIP"]; er.CAN_ADMINISTER_RESTRICTION = (Boolean)r["CAN_ADMINISTER_RESTRICTION"]; er.CAN_ADMINISTER_SCHEDULE = (Boolean)r["CAN_ADMINISTER_SCHEDULE"]; er.CAN_ADMINISTER_MEMBER = (Boolean)r["CAN_ADMINISTER_MEMBER"]; er.CAN_ADMINISTER_SUPPLY_REQUEST = (Boolean)r["CAN_ADMINISTER_SUPPLY_REQUEST"]; er.CAN_ADMINISTER_SERVICE_REQUEST = (Boolean)r["CAN_ADMINISTER_SERVICE_REQUEST"]; er.CAN_ADMINISTER_ATTENDANCE = (Boolean)r["CAN_ADMINISTER_ATTENDANCE"]; er.CAN_ADMINISTER_CUTOFF = (Boolean)r["CAN_ADMINISTER_CUTOFF"]; return er; } else { return null; } } else { return null; } }