public void UpdateEmployee(int i, string name, string password, string bloodGroup, string gender)
{
Employee_Info employeeInfo = PharmacyContext.Employee_Infos.Single(x => x.Id == i); //select *from medicine_info where medicine_id=i LIMIT 1
employeeInfo.Employee_Name = name;
employeeInfo.Password = password;
employeeInfo.Blood_Group = bloodGroup;
employeeInfo.Gender = gender;
PharmacyContext.SubmitChanges();
}
public void DeleteEmployee(int i)
{
var m = from a in PharmacyContext.Employee_Infos
where a.Id == i
select a;
Employee_Info obj = PharmacyContext.Employee_Infos.Single(x => x.Id == i);
PharmacyContext.Employee_Infos.DeleteOnSubmit(obj);
PharmacyContext.SubmitChanges();
}
public void AddEmployee(string name, string password, string bloodGroup, string gender)
{
Employee_Info employeeInfo = new Employee_Info();
employeeInfo.Employee_Name = name;
employeeInfo.Password = password;
employeeInfo.Blood_Group = bloodGroup;
employeeInfo.Gender = gender;
PharmacyContext.Employee_Infos.InsertOnSubmit(employeeInfo);
PharmacyContext.SubmitChanges();
}
partial void DeleteEmployee_Info(Employee_Info instance);
partial void UpdateEmployee_Info(Employee_Info instance);
partial void InsertEmployee_Info(Employee_Info instance);