//GET
public ActionResult MainSite(int id = 0)
{
Customer customer = db.Customers.Find(id);
CustomerSite site = new CustomerSite();
ViewBag.customerName = customer.customerName;
site.visitingStreet = customer.visitingStreet;
site.visitingCity = customer.visitingCity;
site.visitingPostal = customer.visitingPostal;
site.visitingCountry = customer.visitingCountry;
site.postalStreet = customer.postalStreet;
site.postalCity = customer.postalCity;
site.postalPostal = customer.postalPostal;
site.postalCountry = customer.postalCountry;
site.contactAddressStreet = customer.contactAddressStreet;
site.contactAddressCountry = customer.contactAddressCountry;
site.contactAddressPostal = customer.contactAddressPostal;
site.contactAddressCity = customer.contactAddressCity;
site.contactEmail = customer.contactEmail;
site.contactName = customer.contactName;
site.contactPhone = customer.contactPhone;
site.contactTitle = customer.contactTitle;
ViewBag.customerSiteStatus = new SelectList(db.CustomerStatus, "customerStatusNo", "customerStatusText");
ViewBag.wayOfDelivery = new SelectList(db.WayOfDeliveries, "wodNo", "wodText");
return View("Create", site);
}
public ActionResult Create(CustomerSite customersite)
{
var customer = db.Customers.First(x => x.customerNo == customersite.customerNo);
customer.customerNo = customersite.customerNo;
if (customersite.visitingStreet == null)
{
customersite.visitingStreet = customersite.postalStreet;
}
if (customersite.visitingPostal == null)
{
customersite.visitingPostal = customersite.postalPostal;
}
if (customersite.visitingCity == null)
{
customersite.visitingCity = customersite.postalCity;
}
if (customersite.visitingCountry == null)
{
customersite.visitingCountry = customersite.postalCountry;
}
customersite.paymentDisruption = 0;
customersite.customerSiteStatus = 1;
customersite.dateOfTheLastSale = null;
customersite.sales = 0;
if (ModelState.IsValid)
{
db.CustomerSites.Add(customersite);
db.SaveChanges();
return RedirectToAction("Details", new { id = customersite.customerSiteNo });
}
ViewBag.customerNo = customer.customerNo;
ViewBag.customerName = customer.customerName;
ViewBag.customerSiteStatus = new SelectList(db.CustomerStatus, "customerStatusNo", "customerStatusText",
customersite.customerSiteStatus);
ViewBag.paymentDisruption = new SelectList(db.PaymentDisruptions, "paymentDisruptionNo",
"paymentDisruptionText", customersite.paymentDisruption);
ViewBag.wayOfDelivery = new SelectList(db.WayOfDeliveries, "wodNo", "wodText", customersite.wayOfDelivery);
return View(customersite);
}
public ActionResult Edit(CustomerSite customersite)
{
if (ModelState.IsValid)
{
db.Entry(customersite).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Details", new {id = customersite.customerSiteNo });
}
List<SelectListItem> dropDownItems;
//get all countries and put them into list of select list items
dropDownItems = GetAllCountries();
// sort list into alphabetical order
var items = from i in dropDownItems orderby i.Text == customersite.visitingCountry, i.Text ascending select i;
//transfer country data into view using viewbag
ViewBag.countries = items;
ViewBag.customer = new SelectList(db.Customers, "customerNo", "alphabeticID", customersite.customerNo);
ViewBag.customerSiteStatus = new SelectList(db.CustomerStatus, "customerStatusNo", "customerStatusText",
customersite.customerSiteStatus);
ViewBag.paymentDisruption = new SelectList(db.PaymentDisruptions, "paymentDisruptionNo",
"paymentDisruptionText", customersite.paymentDisruption);
ViewBag.wayOfDelivery = new SelectList(db.WayOfDeliveries, "wodNo", "wodText", customersite.wayOfDelivery);
return View(customersite);
}
public ActionResult Create(Customer customer)
{
// Remove customerNo from modelstate so it allows customerNo to be added last.
// Problem was that the modelstate was still expecting the customerNo to be added at the create new customer page
ModelState.Remove("customerNo");
if (customer.visitingStreet == null)
{
customer.visitingStreet = customer.postalStreet;
}
if (customer.visitingPostal == null)
{
customer.visitingPostal = customer.postalPostal;
}
if (customer.visitingCity == null)
{
customer.visitingCity = customer.postalCity;
}
if (customer.visitingCountry == null)
{
customer.visitingCountry = customer.postalCountry;
}
if (ModelState.IsValid)
{
// generate new customer id
var lastId = db.Customers.Max(item => item.customerNo);
var newId = lastId + 1;
customer.customerNo = newId;
CustomerSite site = new CustomerSite();
site = TempData["siteNumber"] as CustomerSite;
if (site != null)
{
site.customerNo = customer.customerNo;
db.Customers.Add(customer);
db.SaveChanges();
db.Entry(site).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
db.Customers.Add(customer);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.customerGroupCode = new SelectList(db.CustomerGroups, "customerGroupCode", "customerGroupName",
customer.customerGroupCode);
ViewBag.customerStatus = new SelectList(db.CustomerStatus, "customerStatusNo", "customerStatusText",
customer.customerStatus);
ViewBag.termsOfDelivery = new SelectList(db.TermsOfDeliveries, "todNo", "todText", customer.termsOfDelivery);
ViewBag.termsOfPayment = new SelectList(db.TermsOfPayments, "topNo", "topText", customer.termsOfPayment);
//get all countries and put them into list of select list items
var dropDownItems2 = GetAllCountries();
// sort list into alphabetical order
var items2 = from i in dropDownItems2 orderby i.Text select i;
//transfer country data into view using viewbag
ViewBag.countries = items2;
return View(customer);
}