public long CreateCard(CustomerIsssueCard model) { Core_Customers obj = new Core_Customers { ProductId = model.ProductId, AgentId = model.AgentId, CustomerCode = model.CustomerCode, FirstName = model.FirstName, MiddleName = model.MiddleName, LastName = model.LastName, Gender = model.Gender, DateOfBirth = model.DateOfBirth, Address1 = model.Address1, Address2 = model.Address2, HouseNo = model.HouseNo, City = model.City, ZipCode = model.ZipCode, CountryID = model.CountryID, HomePhone = model.HomePhone, WorkPhone = model.WorkPhone, MobileNo = model.MobileNo, FaxNo = model.FaxNo, Email = model.Email, Profession = model.Profession, CustomerTypeId = model.CustomerTypeId, CustomerStatus = model.CustomerStatus, //Created = model.Created, //CreatedBy = model.CreatedBy, }; entities.AddToCore_Customers(obj); entities.SaveChanges(); return(entities.Core_Customers.Max(x => x.CustomerID)); }
public void UpdateCard(CustomerIsssueCard model) { Core_Customers comm = entities.Core_Customers.Where(u => u.CustomerID == model.CustomerID).FirstOrDefault(); comm.ProductId = model.ProductId; comm.AgentId = model.AgentId; comm.CustomerCode = model.CustomerCode; comm.FirstName = model.FirstName; comm.MiddleName = model.MiddleName; comm.LastName = model.LastName; comm.Gender = model.Gender; comm.DateOfBirth = model.DateOfBirth; comm.Address1 = model.Address1; comm.Address2 = model.Address2; comm.HouseNo = model.HouseNo; comm.City = model.City; comm.ZipCode = model.ZipCode; comm.CountryID = model.CountryID; comm.HomePhone = model.HomePhone; comm.WorkPhone = model.WorkPhone; comm.MobileNo = model.MobileNo; comm.FaxNo = model.FaxNo; comm.Email = model.Email; comm.Profession = model.Profession; comm.CustomerTypeId = model.CustomerTypeId; comm.CustomerStatus = model.CustomerStatus; comm.Created = DateTime.Now; comm.CreatedBy = model.CreatedBy; comm.Updated = DateTime.Now; comm.UpdatedBy = model.UpdatedBy; entities.ApplyCurrentValues(comm.EntityKey.EntitySetName, comm); entities.SaveChanges(); ///// }
public bool CheckDuplicateUsername(string CustomerCode) { Core_Customers Customers = entities.Core_Customers.Where(ii => ii.CustomerCode == CustomerCode).FirstOrDefault(); if (Customers != null) { return(false); } else { return(true); } }