public bool Update_Account(string Staff_Password, string Staff_Role, string Staff_Id)
{
if (Staff_Role == "Quản Lý")
{
Quyen = "1";
}
else
{
Quyen = "2";
}
Account_Staff account = data.Account_Staff.FirstOrDefault(p => p.Staff_Id == Staff_Id);
if (account != null)
{
try
{
account.Staff_Password = Staff_Password;
account.Staff_Role = Quyen;
data.SaveChanges();
} catch (Exception ex)
{
return(false);
}
}
return(true);
}
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 Login(string username, string password)
{
Account_Staff account = data.Account_Staff.FirstOrDefault(p => p.Staff_Id == username);
if (account != null)
{
if (account.Staff_Password == password)
{
return(true);
}
}
return(false);
}
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);
}
public string getName(string Staff_Id)
{
Account_Staff account = data.Account_Staff.FirstOrDefault(p => p.Staff_Id == Staff_Id);
return(account.Inf_Staff.Staff_Name);
}
public string getRole(string Staff_Id)
{
Account_Staff account = data.Account_Staff.FirstOrDefault(p => p.Staff_Id == Staff_Id);
return(account.Staff_Role);
}
