public JsonResult Save(MstCustomer content) { var repos = new Repository.MstCustomer(); var result = repos.Save(content); return(Json(result, JsonRequestBehavior.AllowGet)); }
public static bool Update(CustomerViewModel model) { bool result = true; try { using (var db = new FleetManagementContext()) { if (model.Id == 0) { MstCustomer ctm = new MstCustomer(); ctm.CustomerId = model.CustomerId; ctm.CustomerName = model.CustomerName; ctm.OrganizationName = model.OrganizationName; ctm.CustomerAddress = model.CustomerAddress; ctm.OrganizationAddress = model.OrganizationAddress; ctm.IdNumber = model.IdNumber; ctm.CustomerPhone = model.CustomerPhone; ctm.OrganizationPhone = model.OrganizationPhone; ctm.OrganizationEmail = model.OrganizationEmail; ctm.IsActive = model.IsActive; db.MstCustomers.Add(ctm); db.SaveChanges(); } else { MstCustomer ctm = db.MstCustomers.Where(o => o.Id == model.Id).FirstOrDefault(); if (ctm != null) { ctm.CustomerId = model.CustomerId; ctm.CustomerName = model.CustomerName; ctm.OrganizationName = model.OrganizationName; ctm.CustomerAddress = model.CustomerAddress; ctm.OrganizationAddress = model.OrganizationAddress; ctm.IdNumber = model.IdNumber; ctm.CustomerPhone = model.CustomerPhone; ctm.OrganizationPhone = model.OrganizationPhone; ctm.OrganizationEmail = model.OrganizationEmail; ctm.IsActive = model.IsActive; db.SaveChanges(); } } } } catch (Exception Ex) { Message = Ex.Message; result = false; } return(result); }
public HttpResponseMessage UnLockMstCustomer(MstCustomer customer) { try { var MstCustomerData = from d in db.MstCustomers where d.Id == Convert.ToInt32(customer.Id) select d; if (MstCustomerData.Any()) { var currentUser = from d in db.MstUsers where d.AspNetId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var UnLockCustomerData = MstCustomerData.FirstOrDefault(); UnLockCustomerData.IsLocked = false; UnLockCustomerData.UpdatedBy = currentUser.FirstOrDefault().Id; UnLockCustomerData.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } else { return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public static bool Delete(int id) { bool result = true; try { using (var db = new FleetManagementContext()) { MstCustomer ctm = db.MstCustomers.Where(o => o.Id == id).FirstOrDefault(); if (ctm != null) { db.MstCustomers.Remove(ctm); db.SaveChanges(); } } } catch (Exception Ex) { Message = Ex.Message; result = false; } return(result); }
public HttpResponseMessage LockMstCustomer(MstCustomer customer) { try { var MstCustomerData = from d in db.MstCustomers where d.Id == Convert.ToInt32(customer.Id) select d; if (MstCustomerData.Any()) { var currentUser = from d in db.MstUsers where d.AspNetId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var UpdateCustomerData = MstCustomerData.FirstOrDefault(); UpdateCustomerData.CustomerCode = customer.CustomerCode; UpdateCustomerData.LastName = customer.LastName; UpdateCustomerData.FirstName = customer.FirstName; UpdateCustomerData.MiddleName = customer.MiddleName; UpdateCustomerData.CivilStatus = customer.CivilStatus; UpdateCustomerData.Gender = customer.Gender; UpdateCustomerData.BirthDate = Convert.ToDateTime(customer.BirthDate); UpdateCustomerData.Citizen = customer.Citizen; UpdateCustomerData.TIN = customer.TIN; UpdateCustomerData.IdType = customer.IdType; UpdateCustomerData.IdNumber = customer.IdNumber; UpdateCustomerData.Address = customer.Address; UpdateCustomerData.City = customer.City; UpdateCustomerData.Province = customer.Province; UpdateCustomerData.Country = customer.Country; UpdateCustomerData.ZipCode = customer.ZipCode; UpdateCustomerData.EmailAddress = customer.EmailAddress; UpdateCustomerData.TelephoneNumber = customer.TelephoneNumber; UpdateCustomerData.MobileNumber = customer.MobileNumber; UpdateCustomerData.Employer = customer.Employer; UpdateCustomerData.EmployerIndustry = customer.EmployerIndustry; UpdateCustomerData.NoOfYearsEmployed = customer.NoOfYearsEmployed; UpdateCustomerData.Position = customer.Position; UpdateCustomerData.EmploymentStatus = customer.EmploymentStatus; UpdateCustomerData.EmployerAddress = customer.EmployerAddress; UpdateCustomerData.EmployerCity = customer.EmployerCity; UpdateCustomerData.EmployerProvince = customer.EmployerProvince; UpdateCustomerData.EmployerCountry = customer.EmployerCountry; UpdateCustomerData.EmployerZipCode = customer.EmployerZipCode; UpdateCustomerData.EmployerTelephoneNumber = customer.EmployerTelephoneNumber; UpdateCustomerData.EmployerMobileNumber = customer.EmployerMobileNumber; UpdateCustomerData.Picture = customer.Picture; UpdateCustomerData.Attachment1 = customer.Attachment1; UpdateCustomerData.Attachment2 = customer.Attachment2; UpdateCustomerData.Attachment3 = customer.Attachment3; UpdateCustomerData.Attachment4 = customer.Attachment4; UpdateCustomerData.Attachment5 = customer.Attachment5; UpdateCustomerData.SpouseLastName = customer.SpouseLastName; UpdateCustomerData.SpouseFirstName = customer.SpouseFirstName; UpdateCustomerData.SpouseMiddleName = customer.SpouseMiddleName; UpdateCustomerData.SpouseBirthDate = Convert.ToDateTime(customer.SpouseBirthDate); UpdateCustomerData.SpouseCitizen = customer.SpouseCitizen; UpdateCustomerData.SpouseEmployer = customer.SpouseEmployer; UpdateCustomerData.SpouseTIN = customer.SpouseTIN; UpdateCustomerData.Remarks = customer.Remarks; UpdateCustomerData.Status = customer.Status; UpdateCustomerData.IsLocked = true; UpdateCustomerData.UpdatedBy = currentUser.FirstOrDefault().Id; UpdateCustomerData.UpdatedDateTime = DateTime.Now; UpdateCustomerData.BusinessName = customer.BusinessName; UpdateCustomerData.BusinessAddress = customer.BusinessAddress; UpdateCustomerData.BusinessType = customer.BusinessType; UpdateCustomerData.BusinessPosition = customer.BusinessPosition; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } else { return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 PostMstCustomer(MstCustomer customer) { try { var currentUser = from d in db.MstUsers where d.AspNetId == User.Identity.GetUserId() select d; if (currentUser.Any()) { string customerCode = "0001"; var customers = from d in db.MstCustomers.OrderByDescending(d => d.Id) select d; if (customers.Any()) { Int32 nextCustomerCode = Convert.ToInt32(customers.FirstOrDefault().CustomerCode) + 1; customerCode = padNumWithZero(nextCustomerCode, 4); } Data.MstCustomer newMstCustomer = new Data.MstCustomer() { CustomerCode = customerCode, LastName = customer.LastName, FirstName = customer.FirstName, MiddleName = customer.MiddleName, CivilStatus = customer.CivilStatus, Gender = customer.Gender, BirthDate = Convert.ToDateTime(customer.BirthDate), Citizen = customer.Citizen, TIN = customer.TIN, IdType = customer.IdType, IdNumber = customer.IdNumber, Address = customer.Address, City = customer.City, Province = customer.Province, Country = customer.Country, ZipCode = customer.ZipCode, EmailAddress = customer.EmailAddress, TelephoneNumber = customer.TelephoneNumber, MobileNumber = customer.MobileNumber, Employer = customer.Employer, EmployerIndustry = customer.EmployerIndustry, NoOfYearsEmployed = customer.NoOfYearsEmployed, Position = customer.Position, EmploymentStatus = customer.EmploymentStatus, EmployerAddress = customer.EmployerAddress, EmployerCity = customer.EmployerCity, EmployerProvince = customer.EmployerProvince, EmployerCountry = customer.EmployerCountry, EmployerZipCode = customer.EmployerZipCode, EmployerTelephoneNumber = customer.EmployerTelephoneNumber, EmployerMobileNumber = customer.EmployerMobileNumber, SpouseLastName = customer.SpouseLastName, SpouseFirstName = customer.SpouseFirstName, SpouseMiddleName = customer.SpouseMiddleName, SpouseBirthDate = Convert.ToDateTime(customer.SpouseBirthDate), SpouseCitizen = customer.SpouseCitizen, SpouseEmployer = customer.SpouseEmployer, SpouseTIN = customer.SpouseTIN, Remarks = customer.Remarks, Status = customer.Status, Picture = customer.Picture, Attachment1 = customer.Attachment1, Attachment2 = customer.Attachment2, Attachment3 = customer.Attachment3, Attachment4 = customer.Attachment4, Attachment5 = customer.Attachment5, IsLocked = customer.IsLocked, CreatedBy = currentUser.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedBy = currentUser.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now, BusinessName = customer.BusinessName, BusinessAddress = customer.BusinessAddress, BusinessType = customer.BusinessType, BusinessPosition = customer.BusinessPosition }; db.MstCustomers.InsertOnSubmit(newMstCustomer); db.SubmitChanges(); return(newMstCustomer.Id); } else { return(0); } } catch (Exception e) { Debug.WriteLine(e); return(0); } }