public ActionResult Create(VendorsContactAddress vendorscontactaddress) { if (ModelState.IsValid) { db.VendorsContactAddresses.Add(vendorscontactaddress); db.SaveChanges(); return RedirectToAction("Index"); } return View(vendorscontactaddress); }
public ActionResult Edit(string modomultiple, int? page, int id = 0) { int pageNote = 0; int pageSubsidiary = 0; int pageSales = 0; int pageShipp = 0; int pageIndex = 0; int pageSize = 10; string szMsg = ""; string szVendorInfo = ""; string szVendorId = ""; List<KeyValuePair<string, string>> listSelector = new List<KeyValuePair<string, string>>(); IQueryable<VendorsContactAddress> qryVenAdd = null; IQueryable<VendorsBillingDept> qryVenBill = null; IQueryable<VendorsSalesContact> qryVenSale = null; IQueryable<VendorsHistory> qryVenHis = null; IQueryable<VendorsSpecialNotes> qryCusNote = null; IQueryable<VendorTypes> qryBussines = null; IQueryable<Origin> qryOrigin = null; IQueryable<Terms> qryTerms = null; IQueryable<Bussines> qryBussines01 = null; VendorsContactAddress venAddress = null; VendorsBillingDept venBillin = null; VendorsSalesContact venSale = null; VendorsHistory venHistory = null; VendorsSpecialNotes CustNotes = null; VendorDefaults vendordefaults = null; List<VendorsSpecialNotes> notesList = new List<VendorsSpecialNotes>(); List<VendorsSalesContact> salesList = new List<VendorsSalesContact>(); //Get the vendor's data Vendors vendor = db.Vendors.Find(id); if (vendor != null) { //Use the vendors defaults vendordefaults = db.VendorDefaults.Where(cudf => cudf.VendorId == id).FirstOrDefault<VendorDefaults>(); if (vendordefaults == null) { vendordefaults = new VendorDefaults(); vendordefaults.VendorId = id; db.VendorDefaults.Add(vendordefaults); db.SaveChanges(); } szVendorInfo = vendor.VendorNo; qryVenAdd = db.VendorsContactAddresses.Where(cutadd => cutadd.VendorId == vendor.Id); if (qryVenAdd.Count() > 0) { venAddress = qryVenAdd.FirstOrDefault<VendorsContactAddress>(); szVendorInfo = string.Format("{0} {1}", szVendorInfo, venAddress.CompanyName); szVendorId = vendor.Id.ToString(); } else { venAddress = new VendorsContactAddress(); venAddress.VendorId = vendor.Id; db.VendorsContactAddresses.Add(venAddress); szVendorId = vendor.Id.ToString(); } qryVenBill = db.VendorsBillingDepts.Where(cutadd => cutadd.VendorId == vendor.Id); if (qryVenBill.Count() > 0) { venBillin = qryVenBill.FirstOrDefault<VendorsBillingDept>(); } else { venBillin = new VendorsBillingDept(); venBillin.VendorId = vendor.Id; db.VendorsBillingDepts.Add(venBillin); } qryVenHis = db.VendorsHistories.Where(cutadd => cutadd.VendorId == vendor.Id); if (qryVenHis.Count() > 0) { venHistory = qryVenHis.FirstOrDefault<VendorsHistory>(); } else { venHistory = new VendorsHistory(); venHistory.VendorId = vendor.Id; db.VendorsHistories.Add(venHistory); } qryVenSale = db.VendorsSalesContacts.Where(cutadd => cutadd.VendorId == vendor.Id).OrderBy(cutadd => cutadd.FirstName).ThenBy(cutadd => cutadd.LastName); if (qryVenSale.Count() > 0) { //custSalesContact = qryCusSal.FirstOrDefault<CustomersSalesContact>(); foreach (var item in qryVenSale) { salesList.Add(item); if (venSale == null) { venSale = item; if (vendordefaults.SalesContactId == null) { vendordefaults.SalesContactId = item.Id; vendordefaults.SalesName = string.Format("{0} {1}", item.FirstName, item.LastName); //custSalesContact = db.CustomersSalesContacts.Find(item.Id); } } } } else { venSale = new VendorsSalesContact(); venSale.VendorId = vendor.Id; venSale.Address = string.Empty; venSale.City = string.Empty; venSale.Country = string.Empty; venSale.Email = string.Empty; venSale.Fax = "0"; venSale.FirstName = string.Empty; venSale.LastName = string.Empty; venSale.Note = string.Empty; venSale.State = string.Empty; venSale.Tel = "0"; venSale.Title = string.Empty; venSale.Zip = string.Empty; db.VendorsSalesContacts.Add(venSale); db.SaveChanges(); salesList.Add(venSale); if (vendordefaults.SalesContactId == null) { vendordefaults.SalesContactId = venSale.Id; vendordefaults.SalesName = string.Format("{0} {1}", venSale.FirstName, venSale.LastName); //custSalesContact = db.CustomersSalesContacts.Find(item.Id); } } qryCusNote = db.VendorsSpecialNotes.Where(cutadd => cutadd.VendorId == vendor.Id).OrderByDescending(cutadd => cutadd.Id); if (qryCusNote.Count() > 0) { //CustNotes = qryCusNote.FirstOrDefault<CustomersSpecialNotes>(); foreach (var item in qryCusNote) { notesList.Add(item); if (CustNotes == null) { CustNotes = item; } } } else { CustNotes = new VendorsSpecialNotes(); CustNotes.VendorId = vendor.Id; db.VendorsSpecialNotes.Add(CustNotes); notesList.Add(CustNotes); } } db.SaveChanges(); ViewBag.VendorInfo = szVendorId; ViewBag.VendorId = szVendorId; //Get the dropdown data listSelector = new List<KeyValuePair<string, string>>(); //qryBussines = db.VendorTypes.OrderBy(bss => bss.VendorType); //if (qryBussines.Count() > 0) //{ // foreach (var item in qryBussines) // { // listSelector.Add(new KeyValuePair<string, string>(item.VendorType, item.VendorType)); // } //} qryBussines01 = db.Bussines.OrderBy(bss => bss.BussinesType); if (qryBussines01.Count() > 0) { foreach (var item in qryBussines01) { listSelector.Add(new KeyValuePair<string, string>(item.BussinesType, item.BussinesType)); } } SelectList bussineslist = new SelectList(listSelector, "Key", "Value"); ViewBag.VendorTypeList = 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>>(); qryVenSale = db.VendorsSalesContacts.Where(vdad => vdad.VendorId == vendor.Id).OrderBy(vdad => vdad.FirstName).ThenBy(vdad => vdad.LastName); if (qryVenSale.Count() > 0) { foreach (var item in qryVenSale) { szMsg = string.Format("{0} {1}", item.FirstName, item.LastName); listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), szMsg)); } } SelectList SalesContactList = new SelectList(listSelector, "Key", "Value"); ViewBag.SalesContactList = SalesContactList; //Fix null values if (venSale == null) { venSale = new VendorsSalesContact(); venSale.VendorId = vendor.Id; venSale.Tel = string.Empty; venSale.Fax = string.Empty; db.VendorsSalesContacts.Add(venSale); db.SaveChanges(); } else { if (string.IsNullOrEmpty(venSale.Tel)) { venSale.Tel = string.Empty; } if (string.IsNullOrEmpty(venSale.Fax)) { venSale.Fax = string.Empty; } } VendorView vendorview = new VendorView(); vendorview.vendor = vendor; vendorview.vendoraddress = venAddress; vendorview.vendorbilling = venBillin; vendorview.vendorhistory = venHistory; vendorview.vendorsalescontact = venSale; vendorview.vendornote = CustNotes; vendorview.vendordefaults = vendordefaults; //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; 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 "Sales": pageSales = pageIndex; break; default: break; } } //Verify page numbre if (pageNote == 0) { pageNote = 1; } if (pageSales == 0) { pageSales = 1; } var salesListHlp = salesList.ToPagedList(pageSales, pageSize); ViewBag.OnePageOfsalesData = salesListHlp; vendorview.vendorsalesList = salesListHlp; var notesListHlp = notesList.ToPagedList(pageSales, pageSize); ViewBag.OnePageOfnoteData = notesListHlp; vendorview.vendornotesList = notesListHlp; return View(vendorview); }
public ActionResult UpdateVendorandAddress(VendorView vendorview) { Vendors vendor = null; VendorsContactAddress customeraddress = null; //Update Customer General Information if (Convert.ToInt32(vendorview.vendor.Id) != 0) { vendor = db.Vendors.Find(vendorview.vendor.Id); if (vendor != null) { vendor.BussinesType = vendorview.vendor.BussinesType; vendor.CreditLimit = vendorview.vendor.CreditLimit; vendor.VendorNo = vendorview.vendor.VendorNo; vendor.Origin = vendorview.vendor.Origin; vendor.PaymentTerms = vendorview.vendor.PaymentTerms; vendor.Status = vendorview.vendor.Status; db.Entry(vendor).State = EntityState.Modified; //db.SaveChanges(); } } if (vendorview.vendoraddress != null) { if (vendorview.vendoraddress.Id == 0) { customeraddress = new VendorsContactAddress(); } else { customeraddress = db.VendorsContactAddresses.Find(vendorview.vendoraddress.Id); } if (customeraddress != null) { customeraddress.Address = vendorview.vendoraddress.Address; customeraddress.Address3 = vendorview.vendoraddress.Address3; customeraddress.City = vendorview.vendoraddress.City; customeraddress.CompanyName = vendorview.vendoraddress.CompanyName; customeraddress.Country = vendorview.vendoraddress.Country; customeraddress.VendorId = vendorview.vendoraddress.VendorId; customeraddress.Email = vendorview.vendoraddress.Email; customeraddress.FirstName = vendorview.vendoraddress.FirstName; customeraddress.LastName = vendorview.vendoraddress.LastName; customeraddress.Note = vendorview.vendoraddress.Note; customeraddress.State = vendorview.vendoraddress.State; if (!string.IsNullOrEmpty(vendorview.vendoraddress.Tel)) { customeraddress.Tel = vendorview.vendoraddress.Tel.Replace("-", ""); } if (!string.IsNullOrEmpty(vendorview.vendoraddress.Tel1)) { customeraddress.Tel1 = vendorview.vendoraddress.Tel1.Replace("-", ""); } if (!string.IsNullOrEmpty(vendorview.vendoraddress.Tel2)) { customeraddress.Tel2 = vendorview.vendoraddress.Tel2.Replace("-", ""); } if (!string.IsNullOrEmpty(vendorview.vendoraddress.Fax)) { customeraddress.Fax = vendorview.vendoraddress.Fax.Replace("-", ""); } customeraddress.Title = vendorview.vendoraddress.Title; customeraddress.Website = vendorview.vendoraddress.Website; customeraddress.Zip = vendorview.vendoraddress.Zip; db.Entry(customeraddress).State = EntityState.Modified; } } db.SaveChanges(); return RedirectToAction("Edit", new { id = Convert.ToInt32(vendorview.vendor.Id) }); //return RedirectToAction("Index"); }
public ActionResult UpdateVendorAddress(VendorView vendorview) { VendorsContactAddress customeraddress = null; if (vendorview.vendoraddress != null) { if (vendorview.vendoraddress.Id == 0) { customeraddress = new VendorsContactAddress(); } else { customeraddress = db.VendorsContactAddresses.Find(vendorview.vendoraddress.Id); } if (customeraddress != null) { customeraddress.Address = vendorview.vendoraddress.Address; customeraddress.City = vendorview.vendoraddress.City; customeraddress.CompanyName = vendorview.vendoraddress.CompanyName; customeraddress.Country = vendorview.vendoraddress.Country; customeraddress.VendorId = vendorview.vendoraddress.VendorId; customeraddress.Email = vendorview.vendoraddress.Email; customeraddress.Fax = vendorview.vendoraddress.Fax; customeraddress.FirstName = vendorview.vendoraddress.FirstName; customeraddress.LastName = vendorview.vendoraddress.LastName; customeraddress.Note = vendorview.vendoraddress.Note; customeraddress.State = vendorview.vendoraddress.State; customeraddress.Tel = vendorview.vendoraddress.Tel; customeraddress.Title = vendorview.vendoraddress.Title; customeraddress.Website = vendorview.vendoraddress.Website; customeraddress.Zip = vendorview.vendoraddress.Zip; db.Entry(customeraddress).State = EntityState.Modified; db.SaveChanges(); } } return RedirectToAction("Index"); }
public ActionResult Edit(VendorsContactAddress vendorscontactaddress) { if (ModelState.IsValid) { db.Entry(vendorscontactaddress).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(vendorscontactaddress); }
public PartialViewResult CreateVendor(string szItemId, string szVendorNo, int Id = 0) { string szLeadTime = ""; DateTime dDate = DateTime.Now; VendorsContactAddress vendorcontactaddres = null; VendorItem vendoritem = null; List<KeyValuePair<string, string>> listSelector = new List<KeyValuePair<string, string>>(); if (Id == 0 && string.IsNullOrEmpty(szVendorNo)) { //vendoritem = new VendorItem(); //vendoritem.ItemId = szItemId; //db.VendorItems.Add(vendoritem); //db.SaveChanges(); } else { if (string.IsNullOrEmpty(szVendorNo)) { vendoritem = db.VendorItems.Find(Id); if (vendoritem != null) { var qryVendor = db.VendorsContactAddresses.Join(db.Vendors, vdca => vdca.VendorId, vd => vd.Id, (vdca, vd) => new { vdca, vd }).Where(Nvdca => Nvdca.vd.VendorNo == vendoritem.VendorNo).OrderBy(Nvdca => Nvdca.vdca.CompanyName); if (qryVendor.Count() > 0) { foreach (var item in qryVendor) { vendorcontactaddres = item.vdca; if (vendorcontactaddres != null) { break; } } } } } else { vendoritem = db.VendorItems.Where(vdit => vdit.Id == Id && vdit.VendorNo == szVendorNo).FirstOrDefault<VendorItem>(); if (vendoritem != null) { var qryVendor = db.VendorsContactAddresses.Join(db.Vendors, vdca => vdca.VendorId, vd => vd.Id, (vdca, vd) => new { vdca, vd }).Where(Nvdca => Nvdca.vd.VendorNo == vendoritem.VendorNo).OrderBy(Nvdca => Nvdca.vdca.CompanyName); if (qryVendor.Count() > 0) { foreach (var item in qryVendor) { vendorcontactaddres = item.vdca; if (vendorcontactaddres != null) { break; } } } } } } //Fix null values if (vendorcontactaddres == null) { vendorcontactaddres = new VendorsContactAddress(); } if (vendorcontactaddres.CompanyName == null) { vendorcontactaddres.CompanyName = string.Empty; } if (vendorcontactaddres.FirstName == null) { vendorcontactaddres.FirstName = string.Empty; } if (vendorcontactaddres.LastName == null) { vendorcontactaddres.LastName = string.Empty; } if (vendorcontactaddres.Tel == null) { vendorcontactaddres.Tel = "0"; } if (vendorcontactaddres.Tel1 == null) { vendorcontactaddres.Tel1 = "0"; } if (vendorcontactaddres.Tel2 == null) { vendorcontactaddres.Tel2 = "0"; } if (vendorcontactaddres.Address == null) { vendorcontactaddres.Address = string.Empty; } if (vendorcontactaddres.Note == null) { vendorcontactaddres.Note = string.Empty; } if (vendorcontactaddres.Address3 == null) { vendorcontactaddres.Address3 = string.Empty; } if (vendorcontactaddres.City == null) { vendorcontactaddres.City = string.Empty; } if (vendorcontactaddres.State == null) { vendorcontactaddres.State = string.Empty; } if (vendorcontactaddres.Zip == null) { vendorcontactaddres.Zip = string.Empty; } if (vendorcontactaddres.Country == null) { vendorcontactaddres.Country = string.Empty; } if (vendorcontactaddres.Email == null) { vendorcontactaddres.Email = string.Empty; } if (vendorcontactaddres.Website == null) { vendorcontactaddres.Website = string.Empty; } if (vendorcontactaddres.Title == null) { vendorcontactaddres.Title = string.Empty; } if (vendorcontactaddres.Fax == null) { vendorcontactaddres.Fax = "0"; } ViewBag.VendorContactAddressHlp = vendorcontactaddres; //dDate = Convert.ToDateTime(vendoritem.LeadTime); //szLeadTime = string.Format("{0}:{1}", dDate.Minute.ToString("D2"), dDate.Second.ToString("D2")); //ViewBag.LeadTime = szLeadTime; //Delete unused VendorItem records //if (vendoritem != null) //{ // DeleteUnusedVendorItem(vendoritem.Id, vendoritem.ItemId); //} //Get the vendors dropdown data ViewBag.VendorItemListHas = 0; int nYear = 0; int nMonth = 0; int nDay = 0; string szMsg = ""; ITEM item01 = null; item01 = db.ITEMs.Where(itm => itm.ItemID == szItemId).FirstOrDefault<ITEM>(); IQueryable<VendorItem> qryvendoritem = null; vendoritem = null; List<VendorItem> vendoritemList = new List<VendorItem>(); listSelector = new List<KeyValuePair<string, string>>(); //qryvendoritem = db.VendorItems.Where(cutadd => cutadd.ItemId == item.ItemID).OrderBy(cutadd => cutadd.VendorNo); qryvendoritem = db.VendorItems.Where(cutadd => cutadd.ItemId == item01.ItemID && cutadd.VendorNo != null).OrderBy(cutadd => cutadd.VendorNo); if (qryvendoritem.Count() > 0) { //custSalesContact = qryCusSal.FirstOrDefault<CustomersSalesContact>(); foreach (var vendoritemHlp in qryvendoritem) { vendoritemList.Add(vendoritemHlp); var qryVendor = db.VendorsContactAddresses.Join(db.Vendors, vdca => vdca.VendorId, vd => vd.Id, (vdca, vd) => new { vdca, vd }).Where(Nvdca => Nvdca.vd.VendorNo == vendoritemHlp.VendorNo).OrderBy(Nvdca => Nvdca.vdca.CompanyName); if (qryVendor.Count() > 0) { foreach (var itemVendor in qryVendor) { szMsg = string.Format("{0} - {1} -({2})", itemVendor.vdca.CompanyName, itemVendor.vd.VendorNo, vendoritemHlp.Id.ToString()); listSelector.Add(new KeyValuePair<string, string>(itemVendor.vd.VendorNo, szMsg)); //listSelector.Add(new KeyValuePair<string, string>(vendoritemHlp.Id.ToString(), vendoritemHlp.VendorNo)); if (vendoritem == null) { vendoritem = vendoritemHlp; ViewBag.VendorItemID = vendoritem.Id; } } } } } else { //Get the first vendoritem for this item vendoritem = db.VendorItems.Where(vdit => vdit.ItemId == item01.ItemID).FirstOrDefault<VendorItem>(); if (vendoritem != null) { vendoritemList.Add(vendoritem); ViewBag.VendorItemID = vendoritem.Id; } else { //nYear = dDate.Year; //nMonth = dDate.Month; //nDay = dDate.Day; //dDate = new DateTime(nYear, nMonth, nDay, 0, 0, 0); //vendoritem = new VendorItem(); //vendoritem.ItemId = item01.ItemID; ////vendoritem.LeadTime = dDate; //db.VendorItems.Add(vendoritem); //db.SaveChanges(); //vendoritemList.Add(vendoritem); //ViewBag.VendorItemID = vendoritem.Id; } } SelectList vendorItemlist = new SelectList(listSelector, "Key", "Value"); ViewBag.VendorItemList = vendorItemlist; ViewBag.VendorItemListHas = listSelector.Count; //Get the VendorNo select list listSelector = new List<KeyValuePair<string, string>>(); var qryVendorHlp = db.VendorsContactAddresses.Join(db.Vendors, vdca => vdca.VendorId, vd => vd.Id, (vdca, vd) => new { vdca, vd }).OrderBy(Nvdca => Nvdca.vdca.CompanyName); if (qryVendorHlp.Count() > 0) { foreach (var itemAllVendors in qryVendorHlp) { szMsg = string.Format("{0} - {1}", itemAllVendors.vdca.CompanyName, itemAllVendors.vd.VendorNo); listSelector.Add(new KeyValuePair<string, string>(itemAllVendors.vd.VendorNo, szMsg)); } } SelectList vendornolist = new SelectList(listSelector, "Key", "Value"); ViewBag.VendorNoList = vendornolist; if (vendoritem == null) { ViewBag.bVendorItemData = false; } else { ViewBag.bVendorItemData = true; } return PartialView(vendoritem); }