public List <ClientInfo> GetAllClients() { List <ClientInfo> clientList = new List <ClientInfo>(); ClientEntities clnDb = new ClientEntities(); var lstClient = from k in clnDb.ClientInfoes select k; foreach (var item in lstClient) { ClientInfo cln = new ClientInfo(); cln.pkclientId = item.pkclientId; cln.FirstName = item.FirstName; cln.LastName = item.LastName; cln.Email = item.Email; cln.Gender = item.Gender; cln.Nationality = item.Nationality; cln.Address = item.Address; cln.DateOfBirth = item.DateOfBirth; cln.MobileNumber = item.MobileNumber; cln.MaritalStatus = item.MaritalStatus; cln.Gender = item.Gender; clientList.Add(cln); } return(clientList); }
public int DeleteClientById(int Id) { ClientEntities clnDb = new ClientEntities(); ClientInfo clnDtl = new ClientInfo(); clnDtl.pkclientId = Id; clnDb.Entry(clnDtl).State = EntityState.Deleted; int Retval = clnDb.SaveChanges(); return(Retval); }
public int UpdateClient(int Id, string FirstName, string LastName, string Email, string Nationality, string Address, string MobileNumber) { ClientEntities clnDb = new ClientEntities(); ClientInfo clnDl = new ClientInfo(); clnDl.pkclientId = Id; clnDl.FirstName = FirstName; clnDl.Email = Email; clnDl.Nationality = Nationality; clnDl.Address = Address; clnDl.LastName = LastName; clnDl.MobileNumber = MobileNumber; clnDb.Entry(clnDl).State = EntityState.Modified; int Retval = clnDb.SaveChanges(); return(Retval); }
public int AddClient(string FirstName, string LastName, string Email, string Nationality, string Address, string MobileNumber) { ClientEntities clnDb = new ClientEntities(); ClientInfo cln = new ClientInfo(); cln.FirstName = FirstName; cln.LastName = LastName; cln.Email = Email; cln.Nationality = Nationality; cln.Address = Address; cln.MobileNumber = MobileNumber; clnDb.ClientInfoes.Add(cln); int Retval = clnDb.SaveChanges(); return(Retval); }
public ClientInfo GetAllClientById(int id) { ClientEntities clnDb = new ClientEntities(); var lstCln = from k in clnDb.ClientInfoes where k.pkclientId == id select k; ClientInfo cln = new ClientInfo(); foreach (var item in lstCln) { cln.FirstName = item.FirstName; cln.LastName = item.LastName; cln.Email = item.Email; cln.Gender = item.Gender; cln.Nationality = item.Nationality; cln.Address = item.Address; cln.DateOfBirth = item.DateOfBirth; cln.MobileNumber = item.MobileNumber; cln.MaritalStatus = item.MaritalStatus; cln.Gender = item.Gender; } return(cln); }