public ActionResult Create(VendorItem vendoritem)
{
if (ModelState.IsValid)
{
db.VendorItems.Add(vendoritem);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(vendoritem);
}
//
// GET: /Inventory/OpenPurchaseOrderbyItemTab
public ActionResult CreateVendorTab(string id)
{
int nYear = 0;
int nMonth = 0;
int nDay = 0;
string szMsg = "";
DateTime dDate = DateTime.Now;
List<KeyValuePair<string, string>> listSelector = new List<KeyValuePair<string, string>>();
//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;
ITEM item = null;
item = db.ITEMs.Find(id);
IQueryable<VendorItem> qryvendoritem = null;
VendorItem 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 == item.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 == item.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 = item.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;
return View(item);
}
public ActionResult CreateEditVendor01(VendorItem vendoritem, string itemid)
{
if (ModelState.IsValid)
{
vendoritem.UpdateDate = Convert.ToDateTime(DateTime.Now);
db.Entry(vendoritem).State = EntityState.Modified;
db.SaveChanges();
}
return RedirectToAction("Edit", new { id = itemid });
}
public ActionResult CreateEditVendor(VendorItem vendoritem, string leadtimeHlp, string VendorNoselectedid, string itemselectedid)
{
int nId = 0;
int nYear = 0;
int nMonth = 0;
int nDay = 0;
int nMinutes = 0;
int nSeconds = 0;
string szMsg = "";
string szId = "";
string[] szLeadTime = null;
DateTime dDate = DateTime.Now;
VendorsContactAddress vendoraddres = null;
if (ModelState.IsValid)
{
if (vendoritem.Id == 0)
{
db.VendorItems.Add(vendoritem);
vendoritem.ItemId = itemselectedid;
vendoritem.VendorNo = VendorNoselectedid;
vendoritem.UpdateDate = DateTime.Now;
vendoritem.LeadTimeHrs = 0;
vendoritem.LeadTimeMin = 0;
vendoritem.LeadTimeSec = 0;
}
else
{
szId = Request.Form["venaddId"];
if (!string.IsNullOrEmpty(szId))
{
nId = Convert.ToInt32(szId);
vendoraddres = db.VendorsContactAddresses.Find(nId);
if (vendoraddres != null)
{
vendoraddres.CompanyName = Request.Form["CompanyName"];
vendoraddres.FirstName = Request.Form["FirstName"];
vendoraddres.LastName = Request.Form["LastName"];
vendoraddres.Tel1 = Request.Form["Tel1"].Replace("-", "");
vendoraddres.Tel2 = Request.Form["Tel2"].Replace("-", "");
vendoraddres.Tel = Request.Form["Tel3"].Replace("-", "");
vendoraddres.Fax = Request.Form["Fax"].Replace("-", "");
vendoraddres.Address = Request.Form["Addres1"];
vendoraddres.Note = Request.Form["Addres2"];
vendoraddres.Address3 = Request.Form["Addres3"];
vendoraddres.City = Request.Form["City"];
vendoraddres.State = Request.Form["State"];
vendoraddres.Zip = Request.Form["Zip"];
vendoraddres.Country = Request.Form["Country"];
vendoraddres.Email = Request.Form["Email"];
vendoraddres.Website = Request.Form["Website"];
db.Entry(vendoraddres).State = EntityState.Modified;
}
}
}
db.SaveChanges();
//return RedirectToAction("CreateVendorTab", new { id = vendoritem.ItemId });
TempData["EditVendor"] = "EditVendor";
return RedirectToAction("Edit", new { id = vendoritem.ItemId });
//return RedirectToAction("Index");
}
return RedirectToAction("Index");
}
public ActionResult Edit(VendorItem vendoritem)
{
if (ModelState.IsValid)
{
db.Entry(vendoritem).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(vendoritem);
}