public int DeleteUserById(int Id) { masterEntities1 tstDb = new masterEntities1(); Employee usrdtl = new Employee(); usrdtl.empId = Id; tstDb.Entry(usrdtl).State = System.Data.Entity.EntityState.Deleted; int Retval = tstDb.SaveChanges(); return(Retval); }
public int AddUser(int ID, string FName, string LName, string Email, string Designation) { masterEntities1 tstDb = new masterEntities1(); Employee usrdtl = new Employee(); usrdtl.empId = ID; usrdtl.FName = FName; usrdtl.LName = LName; usrdtl.Email = Email; usrdtl.Designation = Designation; tstDb.Employees.Add(usrdtl); int Retval = tstDb.SaveChanges(); return(Retval); }
public int UpdateUser(int Id, string FName, string LName, string Email, string Designation) { masterEntities1 tstDb = new masterEntities1(); Employee usrdtl = new Employee(); usrdtl.empId = Id; usrdtl.FName = FName; usrdtl.LName = LName; usrdtl.Email = Email; usrdtl.Designation = Designation; tstDb.Entry(usrdtl).State = System.Data.Entity.EntityState.Modified; int Retval = tstDb.SaveChanges(); return(Retval); }
public Employee GetAllUserById(int id) { masterEntities1 tstDb = new masterEntities1(); var lstUsr = from k in tstDb.Employees where k.empId == id select k; Employee usr = new Employee(); foreach (var item in lstUsr) { usr.empId = item.empId; usr.FName = item.FName; usr.LName = item.LName; usr.Email = item.Email; usr.Designation = item.Designation; } return(usr); }
public List <Employee> GetAllUser() { List <Employee> userlst = new List <Employee>(); masterEntities1 tstDb = new masterEntities1(); var lstUsr = from k in tstDb.Employees select k; foreach (var item in lstUsr) { Employee usr = new Employee(); usr.empId = item.empId; usr.FName = item.FName; usr.LName = item.LName; usr.Email = item.Email; usr.Designation = item.Designation; userlst.Add(usr); } return(userlst); }