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);