public bool Delete_NV(string Staff_Id) { try { Account_Staff account = data.Account_Staff.FirstOrDefault(p => p.Staff_Id == Staff_Id); if (account != null) { data.Account_Staff.Remove(account); data.SaveChanges(); } Salary_Staff salary = data.Salary_Staff.FirstOrDefault(p => p.Staff_Id == Staff_Id); if (salary != null) { data.Salary_Staff.Remove(salary); data.SaveChanges(); } Inf_Staff Inf_Staff = data.Inf_Staff.FirstOrDefault(p => p.Staff_Id == Staff_Id); if (Inf_Staff != null) { data.Inf_Staff.Remove(Inf_Staff); data.SaveChanges(); } } catch (Exception ex) { return(false); } return(true); }
public bool Update_Salary(string Staff_Default_Salary, string Staff_Salary_Per_Hour, string Staff_OT, string Staff_Reward, string Staff_Id) { Salary_Staff salary = data.Salary_Staff.FirstOrDefault(p => p.Staff_Id == Staff_Id); if (salary != null) { try { salary.Staff_Default_Salary = Staff_Default_Salary; salary.Staff_OT = Staff_OT; salary.Staff_Reward = Staff_Reward; salary.Staff_Salary_Per_Hour = Staff_Salary_Per_Hour; data.SaveChanges(); } catch (Exception ex) { return(false); } } return(true); }
public bool Add_NV(string Staff_Name, string Staff_Sex, DateTime Staff_Birth, string Staff_Address, string Staff_Phone, string Staff_Department) { if (Staff_Sex == "Nam") { Sex = "1"; } else if (Staff_Sex == "Nữ") { Sex = "2"; } else if (Staff_Sex == "Khác") { Sex = "3"; } if (Staff_Department == "Quản Lý") { PhongBan = "1"; } else if (Staff_Department == "Kỹ Thuật") { PhongBan = "2"; } else if (Staff_Department == "Kế Toán") { PhongBan = "3"; } try { Inf_Staff Staff = new Inf_Staff { Staff_Id = "NV" + day + "" + Min + "" + sec + "", Staff_Name = Staff_Name, Staff_Sex = Sex, Staff_Birth = Staff_Birth, Staff_Phone = Staff_Phone, Staff_Address = Staff_Address, Staff_Deparment = PhongBan, Staff_TimeAdd = time.Date }; data.Inf_Staff.Add(Staff); data.SaveChanges(); Account_Staff account = new Account_Staff { Staff_Id = "NV" + day + "" + Min + "" + sec + "", Staff_Account = "NV" + day + "" + Min + "" + sec + "", Staff_Password = "******", Staff_Role = PhongBan, }; data.Account_Staff.Add(account); data.SaveChanges(); Salary_Staff salary = new Salary_Staff { Staff_Id = "NV" + day + "" + Min + "" + sec + "", Staff_Default_Salary = "0", Staff_OT = "0", Staff_Reward = "0", Staff_Salary_Per_Hour = "0" }; data.Salary_Staff.Add(salary); data.SaveChanges(); time = DateTime.Now; day = DateTime.Now.ToString("dd"); Min = DateTime.Now.ToString("mm"); sec = DateTime.Now.ToString("ss"); } catch (Exception ex) { return(false); } return(true); }