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