Ejemplo n.º 1
0
        //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);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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);
        }
Ejemplo n.º 4
0
        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);
        }