public int FindCustomer(string userName, DateTime DOB) { using (var context = new connected_usersContext()) { Customers cust = context.Customers.Where(x => x.Name == userName && x.Dob == DOB).SingleOrDefault(); if (cust != null) { Reltionship rela = context.Reltionship.Where(x => x.ChildernId == cust.CustomerId || x.WifeId == cust.CustomerId).SingleOrDefault(); if (rela == null) { return(cust.CustomerId); } } return(-1); } }
public bool UpdateCustomers(List <CustomerDetails> cust, string loggedInUserRoleId, string userId) { using (var context = new connected_usersContext()) { foreach (CustomerDetails c in cust) { //If dependant user needs to be deleted if (c.DependantToBeDeleted ?? false) { int? id = (int?)c.CustomerID; Reltionship cusDe = context.Reltionship.Where(x => x.ChildernId == id || x.WifeId == id).SingleOrDefault(); if (cusDe != null) { context.Reltionship.Remove(cusDe); context.SaveChanges(); } continue; } //else if (c.CustomerID == -1) //Add new user //{ // var customer = context.Customers.Add(new Customers() // { // Name = c.CutomerName, // Dob = c.DOB, // ArabicEducationId = c.arabicEducationID, // EducationId = c.educationId, // OccupationId = c.OccupationId, // MaritalStatusId = c.MaritalStatusId ?? 0, // GenderId = c.GenderId ?? 0, // MobileNumber = c.MobileNumber, // OccupdationDetails = c.OccupationDetails ?? string.Empty, // EducationDetail = c.EducationDetails ?? string.Empty, // CreatedBy = Convert.ToInt32(userId), // CreatedTime = DateTime.Now, // UpdatedBy = null, // UpdatedTime = null, // }); // context.SaveChanges(); // context.CustomerAddress.Add(new CustomerAddress() // { // CustomerId = customer.Entity.CustomerId, // Address1=c.Address1, // Address2=c.Address2, // Area=c.Area, // StateId=c.StateId, // CityId=c.CityId, // PinId=c.PinId, // }); // context.SaveChanges(); // if (c.DependantToBeAddedAsChild ?? false) // { // context.Reltionship.Add(new Reltionship() // { // UserId = c.DependantParentID ?? 0, // ChildernId = customer.Entity.CustomerId, // }); // } // else // { // context.Reltionship.Add(new Reltionship() // { // UserId = c.DependantParentID??0, // WifeId = customer.Entity.CustomerId, // }); // } // context.SaveChanges(); //} else { Customers custom = context.Customers.Where(x => x.CustomerId == c.CustomerID).Include(x => x.CustomerAddress).SingleOrDefault(); custom.ArabicEducationId = c.arabicEducationID ?? 0; custom.EducationId = c.educationId ?? 0; custom.OccupationId = c.OccupationId ?? 0; custom.MaritalStatusId = c.MaritalStatusId ?? 0; custom.GenderId = c.GenderId ?? 0; if (!string.IsNullOrEmpty(c.MobileNumber)) { custom.MobileNumber = c.MobileNumber; } if (!string.IsNullOrEmpty(c.OccupationDetails)) { custom.OccupdationDetails = c.OccupationDetails; } if (!string.IsNullOrEmpty(c.EducationDetails)) { custom.EducationDetail = c.EducationDetails; } custom.UpdatedBy = Convert.ToInt32(userId); custom.UpdatedTime = DateTime.Now; if (custom.CustomerAddress != null) { if (!string.IsNullOrEmpty(c.Address1)) { custom.CustomerAddress.Address1 = c.Address1; } if (!string.IsNullOrEmpty(c.Address2)) { custom.CustomerAddress.Address2 = c.Address2; } if (!string.IsNullOrEmpty(c.Area)) { custom.CustomerAddress.Area = c.Area; } custom.CustomerAddress.CityId = c.CityId; custom.CustomerAddress.StateId = c.StateId; custom.CustomerAddress.PinId = c.PinId; } context.SaveChanges(); if (c.DependantParentID > 0) //Add existing customer as dependent { Reltionship re = context.Reltionship.Where(x => x.ChildernId == c.CustomerID || x.WifeId == c.CustomerID || x.UserId == c.CustomerID).SingleOrDefault(); if (re == null) { if (c.DependantToBeAddedAsChild ?? false) //add dependent as child { context.Reltionship.Add(new Reltionship() { UserId = c.DependantParentID ?? 0, ChildernId = c.CustomerID, }); } else //add dependent as wife { context.Reltionship.Add(new Reltionship() { UserId = c.DependantParentID ?? 0, WifeId = c.CustomerID, }); } } } context.SaveChanges(); } } } return(true); }