public void Insert(string fname, string lname, string gender, DateTime dob, short age, string address, string phone1, string phone2, string email, string position, int salary, DateTime workdate) { var insert = new Hospital_Entity_Framework.Worker() { FirstName = fname, LastName = lname, Gender = gender, DOB = dob, Age = age, Address = address, Phone1 = phone1, Phone2 = phone2, Email = email, Position = position, Salary = salary, StartWorkDate = workdate, Hire = true }; _db.Workers.Add(insert); _db.SaveChanges(); }
public Hospital_Entity_Framework.Account Selection(Hospital_Entity_Framework.Worker worker) { var selection = from v in _db.Accounts where v.WorkerId == worker.Id select new { v.Id, v.WorkerId, v.UserName, v.Password }; foreach (var item in selection) { var account = new Hospital_Entity_Framework.Account() { Id = item.Id, WorkerId = item.WorkerId, UserName = item.UserName, Password = item.Password }; return(account); } return(null); }