public ActionResult Create(CustomersShipAddress customersshipaddress) { if (ModelState.IsValid) { db.CustomersShipAddresses.Add(customersshipaddress); db.SaveChanges(); return RedirectToAction("Index"); } return View(customersshipaddress); }
public ActionResult Edit(CustomersShipAddress customersshipaddress) { if (ModelState.IsValid) { db.Entry(customersshipaddress).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(customersshipaddress); }
public PartialViewResult CreateEditShip(string customerid, int id = 0) { int nCustomerId = Convert.ToInt32(customerid); string szCustomerInfo = string.Empty; //IQueryable<CustomersSalesContact> qryAddress = null; CustomersShipAddress customernote = null; Customers customer = null; CustomerDefaults customerDefault = null; if (id == 0) { customernote = new CustomersShipAddress(); customernote.CustomerId = nCustomerId; } else { customernote = db.CustomersShipAddresses.Find(id); } //Get Customer info if (customernote != null) { customer = db.Customers.Find(customernote.CustomerId); if (customer != null) { szCustomerInfo = string.Format("{0}", customer.CustomerNo); } } ViewBag.CustomerInfo = szCustomerInfo; //Get the customer default id ViewBag.CustomerDefaultId = 0; customerDefault = db.CustomerDefaults.Where(ctdf => ctdf.CustomerId == nCustomerId).FirstOrDefault<CustomerDefaults>(); if (customerDefault != null) { ViewBag.CustomerDefaultId = customerDefault.Id; } return PartialView(customernote); }
// // GET: /Customers/Edit public ActionResult Edit(string modomultiple, int? page, int id = 0) { int nHas = 0; int nPos = -1; string szError = string.Empty; string szDecriptedData = string.Empty; string szDecriptedCode = string.Empty; //int? page = null; int pageNote = 0; int pageSubsidiary = 0; int pageSales = 0; int pageShipp = 0; int pageIndex = 0; int pageSize = 10; string szCustomerInfo = string.Empty; string szCustomerId = string.Empty; string szMsg = string.Empty; List<KeyValuePair<string, string>> listSelector = new List<KeyValuePair<string, string>>(); IQueryable<CustomersContactAddress> qryCusAdd = null; IQueryable<CustomersSubsidiaryAddress> qryCusSub = null; IQueryable<CustomersBillingDept> qryCusBil = null; IQueryable<CustomersSalesContact> qryCusSal = null; IQueryable<CustomersHistory> qryCusHty = null; IQueryable<CustomersCreditCardShipping> qryCusCre = null; IQueryable<CustomersSpecialNotes> qryCusNote = null; IQueryable<CustomersShipAddress> qryCusShip = null; IQueryable<Deptos> qryDepto = null; IQueryable<Bussines> qryBussines = null; IQueryable<Origin> qryOrigin = null; IQueryable<Terms> qryTerms = null; IQueryable<CustomerDefaults> qryCusDefault = null; CustomersContactAddress custMainContact = null; CustomersBillingDept custBilling = null; CustomersSalesContact custSalesContact = null; CustomersHistory custHistory = null; CustomersCreditCardShipping CustCredit = null; CustomersSubsidiaryAddress custSubsidiary = null; CustomersShipAddress CusShip = null; CustomersSpecialNotes CustNotes = null; CustomerDefaults customerdefaults = null; List<CustomersSpecialNotes> notesList = new List<CustomersSpecialNotes>(); List<CustomersSubsidiaryAddress> subsidiaryList = new List<CustomersSubsidiaryAddress>(); List<CustomersSalesContact> salesList = new List<CustomersSalesContact>(); List<CustomersShipAddress> shipList = new List<CustomersShipAddress>(); //Get the customer's data Customers customers = db.Customers.Find(id); if (customers != null) { //Use the customer defaults customerdefaults = db.CustomerDefaults.Where(cudf => cudf.CustomerId == id).FirstOrDefault<CustomerDefaults>(); if (customerdefaults == null) { customerdefaults = new CustomerDefaults(); customerdefaults.CustomerId = id; db.CustomerDefaults.Add(customerdefaults); db.SaveChanges(); } szCustomerInfo = customers.CustomerNo; qryCusAdd = db.CustomersContactAddresses.Where(cutadd => cutadd.CustomerId == customers.Id); if (qryCusAdd.Count() > 0) { custMainContact = qryCusAdd.FirstOrDefault<CustomersContactAddress>(); szCustomerInfo = string.Format("{0} {1}", szCustomerInfo, custMainContact.CompanyName); szCustomerId = customers.Id.ToString(); } else { custMainContact = new CustomersContactAddress(); custMainContact.CustomerId = customers.Id; db.CustomersContactAddresses.Add(custMainContact); szCustomerId = customers.Id.ToString(); } qryCusBil = db.CustomersBillingDepts.Where(cutadd => cutadd.CustomerId == customers.Id); if (qryCusBil.Count() > 0) { custBilling = qryCusBil.FirstOrDefault<CustomersBillingDept>(); } else { custBilling = new CustomersBillingDept(); custBilling.CustomerId = customers.Id; db.CustomersBillingDepts.Add(custBilling); } qryCusHty = db.CustomersHistories.Where(cutadd => cutadd.CustomerId == customers.Id); if (qryCusHty.Count() > 0) { custHistory = qryCusHty.FirstOrDefault<CustomersHistory>(); } else { custHistory = new CustomersHistory(); custHistory.CustomerId = customers.Id; db.CustomersHistories.Add(custHistory); } qryCusCre = db.CustomersCreditCardShippings.Where(cutadd => cutadd.CustomerId == customers.Id); if (qryCusCre.Count() > 0) { CustCredit = qryCusCre.FirstOrDefault<CustomersCreditCardShipping>(); if (customerdefaults.NoteId == null) { customerdefaults.NoteId = CustCredit.Id; customerdefaults.NoteName = string.Format("{0}", CustCredit.CreditNumber); } } else { CustCredit = new CustomersCreditCardShipping(); CustCredit.CustomerId = customers.Id; db.CustomersCreditCardShippings.Add(CustCredit); if (customerdefaults.NoteId == null) { customerdefaults.NoteId = CustCredit.Id; customerdefaults.NoteName = string.Format("{0}", CustCredit.Name); } } qryCusShip = db.CustomersShipAddresses.Where(cutadd => cutadd.CustomerId == customers.Id).OrderBy(cutadd => cutadd.FirstName).ThenBy(cutadd => cutadd.LastName); if (qryCusShip.Count() > 0) { //CusShip = qryCusShip.FirstOrDefault<CustomersShipAddress>(); foreach (var item in qryCusShip) { shipList.Add(item); if (customerdefaults.ShiptoAddressId == null) { customerdefaults.ShiptoAddressId = item.Id; customerdefaults.ShiptoName = item.Address1; } } } else { CusShip = new CustomersShipAddress(); CusShip.CustomerId = customers.Id; db.CustomersShipAddresses.Add(CusShip); db.SaveChanges(); shipList.Add(CusShip); if (customerdefaults.ShiptoAddressId == null) { customerdefaults.ShiptoAddressId = CusShip.Id; customerdefaults.ShiptoName = CusShip.Address1; } } qryCusSal = db.CustomersSalesContacts.Where(cutadd => cutadd.CustomerId == customers.Id).OrderBy(cutadd => cutadd.FirstName).ThenBy(cutadd => cutadd.LastName); if (qryCusSal.Count() > 0) { //custSalesContact = qryCusSal.FirstOrDefault<CustomersSalesContact>(); foreach (var item in qryCusSal) { salesList.Add(item); if (customerdefaults.SalesContactId == null) { customerdefaults.SalesContactId = item.Id; customerdefaults.SalesName = string.Format("{0} {1}", item.FirstName, item.LastName); custSalesContact = db.CustomersSalesContacts.Find(item.Id); } } } else { custSalesContact = new CustomersSalesContact(); custSalesContact.CustomerId = customers.Id; db.CustomersSalesContacts.Add(custSalesContact); db.SaveChanges(); salesList.Add(custSalesContact); if (customerdefaults.SalesContactId == null) { customerdefaults.SalesContactId = custSalesContact.Id; customerdefaults.SalesName = string.Format("{0} {1}", custSalesContact.FirstName, custSalesContact.LastName); } } qryCusSub = db.CustomersSubsidiaryAddresses.Where(cutadd => cutadd.CustomerId == customers.Id).OrderBy(cutadd => cutadd.CompanyName); if (qryCusSub.Count() > 0) { //custSubsidiary = qryCusSub.FirstOrDefault<CustomersSubsidiaryAddress>(); foreach (var item in qryCusSub) { subsidiaryList.Add(item); if (customerdefaults.SubsidiaryId == null) { customerdefaults.SubsidiaryId = item.Id; customerdefaults.SubsidiaryName = string.Format("{0}", item.CompanyName); } if (custSubsidiary == null) { custSubsidiary = item; customerdefaults.SubsidiaryId = item.Id; customerdefaults.SubsidiaryName = string.Format("{0}", item.CompanyName); } } } else { custSubsidiary = new CustomersSubsidiaryAddress(); custSubsidiary.CustomerId = customers.Id; db.CustomersSubsidiaryAddresses.Add(custSubsidiary); db.SaveChanges(); subsidiaryList.Add(custSubsidiary); if (customerdefaults.SubsidiaryId == null) { customerdefaults.SubsidiaryId = custSubsidiary.Id; customerdefaults.SubsidiaryName = string.Format("{0}", custSubsidiary.CompanyName); } } qryCusNote = db.CustomersSpecialNotes.Where(cutadd => cutadd.CustomerId == customers.Id).OrderByDescending(cutadd => cutadd.Id); if (qryCusNote.Count() > 0) { //CustNotes = qryCusNote.FirstOrDefault<CustomersSpecialNotes>(); foreach (var item in qryCusNote) { notesList.Add(item); //if (customerdefaults.NoteId == null) //{ // customerdefaults.NoteId = item.Id; // customerdefaults.NoteName = string.Format("{0}", item.SpecialNote); //} if (CustNotes == null) { CustNotes = item; } } } else { CustNotes = new CustomersSpecialNotes(); CustNotes.CustomerId = customers.Id; db.CustomersSpecialNotes.Add(CustNotes); notesList.Add(CustNotes); if (customerdefaults.NoteId == null) { customerdefaults.NoteId = CustNotes.Id; customerdefaults.NoteName = string.Format("{0}", CustNotes.SpecialNote); } } } db.SaveChanges(); ViewBag.CustomerInfo = szCustomerInfo; ViewBag.CustomerId = szCustomerId; //Get the dropdown data qryDepto = db.Deptos.OrderBy(dpt => dpt.Name); if (qryDepto.Count() > 0) { foreach (var item in qryDepto) { listSelector.Add(new KeyValuePair<string, string>(item.DeptoNo, item.Name)); } } SelectList deptoslist = new SelectList(listSelector, "Key", "Value"); ViewBag.DeptosList = deptoslist; listSelector = new List<KeyValuePair<string, string>>(); qryBussines = db.Bussines.OrderBy(bss => bss.BussinesType); if (qryBussines.Count() > 0) { foreach (var item in qryBussines) { listSelector.Add(new KeyValuePair<string, string>(item.BussinesType, item.BussinesType)); } } SelectList bussineslist = new SelectList(listSelector, "Key", "Value"); ViewBag.BussinesList = bussineslist; listSelector = new List<KeyValuePair<string, string>>(); qryOrigin = db.Origins.OrderBy(org => org.Name); if (qryOrigin.Count() > 0) { foreach (var item in qryOrigin) { listSelector.Add(new KeyValuePair<string, string>(item.Name, item.Name)); } } SelectList Originlist = new SelectList(listSelector, "Key", "Value"); ViewBag.OriginList = Originlist; listSelector = new List<KeyValuePair<string, string>>(); qryTerms = db.Terms.OrderBy(trm => trm.Term); if (qryTerms.Count() > 0) { foreach (var item in qryTerms) { listSelector.Add(new KeyValuePair<string, string>(item.Term, item.Term)); } } SelectList Termslist = new SelectList(listSelector, "Key", "Value"); ViewBag.TermsList = Termslist; listSelector = new List<KeyValuePair<string, string>>(); qryCusSal = db.CustomersSalesContacts.Where(csp => csp.CustomerId == customers.Id).OrderBy(csp => csp.FirstName).ThenBy(csp => csp.LastName); if (qryCusSal.Count() > 0) { foreach (var item in qryCusSal) { szMsg = string.Format("{0} {1}", item.FirstName, item.LastName); listSelector.Add(new KeyValuePair<string, string>(szMsg, szMsg)); } } SelectList SalesPersonslist = new SelectList(listSelector, "Key", "Value"); ViewBag.SalesPersonsList = SalesPersonslist; listSelector = new List<KeyValuePair<string, string>>(); qryCusSal = db.CustomersSalesContacts.Where(csp => csp.CustomerId == customers.Id).OrderBy(csp => csp.FirstName).ThenBy(csp => csp.LastName); if (qryCusSal.Count() > 0) { foreach (var item in qryCusSal) { szMsg = string.Format("{0} {1}", item.FirstName, item.LastName); listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), szMsg)); } } SelectList cusdefaultlist = new SelectList(listSelector, "Key", "Value"); ViewBag.SalesContactList = cusdefaultlist; listSelector = new List<KeyValuePair<string, string>>(); qryCusSub = db.CustomersSubsidiaryAddresses.Where(cusb => cusb.CustomerId == customers.Id).OrderBy(cusb => cusb.CompanyName); if (qryCusSub.Count() > 0) { foreach (var item in qryCusSub) { listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), item.CompanyName)); } } SelectList cussublist = new SelectList(listSelector, "Key", "Value"); ViewBag.SubsidiaryList = cussublist; listSelector = new List<KeyValuePair<string, string>>(); qryCusShip = db.CustomersShipAddresses.Where(cusb => cusb.CustomerId == customers.Id).OrderBy(cusb => cusb.FirstName).ThenBy(cusb => cusb.LastName); if (qryCusShip.Count() > 0) { foreach (var item in qryCusShip) { szMsg = string.Format("{0} {1}", item.FirstName, item.LastName); listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), szMsg)); } } SelectList cusshiplist = new SelectList(listSelector, "Key", "Value"); ViewBag.ShipList = cusshiplist; listSelector = new List<KeyValuePair<string, string>>(); qryCusCre = db.CustomersCreditCardShippings.Where(cucr => cucr.CustomerId == customers.Id).OrderBy(cucr => cucr.CreditNumber); if (qryCusCre.Count() > 0) { foreach (var item in qryCusCre) { szError = string.Empty; szDecriptedData = TimelyDepotMVC.Controllers.PaymentController.DecodeInfo02(item.CreditNumber, ref szError); if (!string.IsNullOrEmpty(szError)) { nPos = szError.IndexOf("data to decode"); if (nPos != -1) { szDecriptedData = string.Empty; } else { szDecriptedData = string.Format("******"); } } else { //Mask the card number nHas = szDecriptedData.Length; if (nHas > 4) { szMsg = szDecriptedData.Substring(nHas - 4, 4); szDecriptedData = string.Format("******{0}", szMsg); } else { szDecriptedData = string.Format("******"); } } //listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), item.CreditNumber)); listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), szDecriptedData)); } } SelectList cuscreditlist = new SelectList(listSelector, "Key", "Value"); ViewBag.CreditCardList = cuscreditlist; //Get the missing (null) objects if (custSalesContact == null) { custSalesContact = db.CustomersSalesContacts.Find(customerdefaults.SalesContactId); if (custSalesContact == null) { custSalesContact = new CustomersSalesContact(); } } if (custSubsidiary == null) { custSubsidiary = db.CustomersSubsidiaryAddresses.Find(customerdefaults.SubsidiaryId); if (custSubsidiary == null) { custSubsidiary = new CustomersSubsidiaryAddress(); } } if (CusShip == null) { CusShip = db.CustomersShipAddresses.Find(customerdefaults.ShiptoAddressId); if (CusShip == null) { CusShip = new CustomersShipAddress(); } } //Get theActive/Inactive list listSelector = new List<KeyValuePair<string, string>>(); listSelector.Add(new KeyValuePair<string, string>("Y", "Active")); listSelector.Add(new KeyValuePair<string, string>("N", "Inactive")); SelectList activeinactivelist = new SelectList(listSelector, "Key", "Value"); ViewBag.ActiveInactivelist = activeinactivelist; CustomerView cusview = new CustomerView(); cusview.customer = customers; cusview.customeraddress = custMainContact; cusview.customerbilling = custBilling; cusview.customerhistory = custHistory; cusview.customercredit = CustCredit; cusview.customerdefaults = customerdefaults; cusview.customersalescontact = custSalesContact; cusview.custmersubsidiary = custSubsidiary; cusview.customershipaddress = CusShip; cusview.customernote = CustNotes; if (TempData["AddCustomer"] != null) { ViewBag.AddCustomerHlp = TempData["AddCustomer"].ToString(); } //Set the page if (page == null) { pageIndex = 1; } else { pageIndex = Convert.ToInt32(page); } if (string.IsNullOrEmpty(modomultiple)) { pageNote = pageIndex; pageSubsidiary = pageIndex; pageSales = pageIndex; pageShipp = pageIndex; } else { switch (modomultiple) { case "SpecialNote": pageNote = pageIndex; break; case "Subsidiary": pageSubsidiary = pageIndex; break; case "Sales": pageSales = pageIndex; PageSize = 1; break; case "Shipp": pageShipp = pageIndex; break; default: break; } } //Verify page numbre if (pageNote == 0) { pageNote = 1; } var noteListHlp = notesList.ToPagedList(1, 1); ViewBag.OnePageOfNotesData = noteListHlp; cusview.customernotesList = noteListHlp; var subsidiaryListHlp = subsidiaryList.ToPagedList(1, 1); ViewBag.OnePageOfsubsidiarysData = subsidiaryListHlp; cusview.customersubsidiaryList = subsidiaryListHlp; //var salesListHlp = salesList.ToPagedList(pageSales, pageSize); var salesListHlp = salesList.ToPagedList(1, 1); ViewBag.OnePageOfsalesData = salesListHlp; cusview.customersalesList = salesListHlp; var shippListHlp = shipList.ToPagedList(1, 1); ViewBag.OnePageOfshipsData = shippListHlp; cusview.customershipList = shippListHlp; //Set the error, if any if (TempData["Error"] != null) { ViewBag.Error = TempData["Error"].ToString(); } //Set the active tab if (TempData["ActiveTab"] != null) { ViewBag.ActiveTab = TempData["ActiveTab"].ToString(); } return View(cusview); }
public ActionResult UpdateCustomerShip(CustomersShipAddress customenote, string customerdefault) { int nCustomerDefault = Convert.ToInt32(customerdefault); CustomerDefaults custdefault = null; if (customenote != null) { if (ModelState.IsValid) { if (customenote.Id == 0) { if (string.IsNullOrEmpty(customenote.Tel)) { customenote.Tel = "0"; } if (string.IsNullOrEmpty(customenote.Fax)) { customenote.Fax = "0"; } customenote.Tel = customenote.Tel.Replace("-", string.Empty); customenote.Fax = customenote.Fax.Replace("-", string.Empty); db.CustomersShipAddresses.Add(customenote); db.SaveChanges(); //Set the default customer value custdefault = db.CustomerDefaults.Find(nCustomerDefault); if (custdefault != null) { custdefault.ShiptoAddressId = customenote.Id; custdefault.ShiptoName = string.Format("{0} {1}", customenote.FirstName, customenote.LastName); db.Entry(custdefault).State = EntityState.Modified; } db.SaveChanges(); } else { //Set the default customer value custdefault = db.CustomerDefaults.Find(nCustomerDefault); if (custdefault != null) { custdefault.ShiptoAddressId = customenote.Id; custdefault.ShiptoName = string.Format("{0} {1}", customenote.FirstName, customenote.LastName); db.Entry(custdefault).State = EntityState.Modified; } if (string.IsNullOrEmpty(customenote.Tel)) { customenote.Tel = "0"; } if (string.IsNullOrEmpty(customenote.Fax)) { customenote.Fax = "0"; } customenote.Tel = customenote.Tel.Replace("-", string.Empty); customenote.Fax = customenote.Fax.Replace("-", string.Empty); db.Entry(customenote).State = EntityState.Modified; db.SaveChanges(); } TempData["ActiveTab"] = "2"; //return RedirectToAction("Index"); return RedirectToAction("Edit", new { id = Convert.ToInt32(customenote.CustomerId) }); } } return RedirectToAction("Index"); }