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