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