コード例 #1
0
        public ActionResult Create([Bind(Include = "ID,Name,Address,City,Pincode,ContactNumber,EmailId")] Customer_Master customer_Master)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    customer_Master.Name    = customer_Master.Name.Trim();
                    customer_Master.EmailId = customer_Master.EmailId.Trim();
                    customer_Master.Address = customer_Master.Address.Trim();
                    customer_Master.City    = customer_Master.City.Trim();
                    // to trim end spaces
                    db.Customer_Master.Add(customer_Master);
                    db.SaveChanges();
                    return(RedirectToAction("Index"));
                }

                return(View(customer_Master));
            }
            catch (Exception e)
            {
                Console.WriteLine(e.InnerException);
                return(View("Error"));
                // throw;
            }
        }
コード例 #2
0
        public ActionResult DeleteConfirmed(int id)
        {
            try
            {
                Customer_Master customer_Master = db.Customer_Master.Find(id);
                db.Customer_Master.Remove(customer_Master);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            catch (System.Data.Entity.Infrastructure.DbUpdateException ue)
            {
                Console.WriteLine(ue.InnerException);

                //  return View("~/Views/Shared/Error.cshtml");
                return(View("ActiveRecordException"));
                // throw;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.InnerException);
                // ViewBag.Message = "Foreign key violation";
                return(View("Error"));
                // throw;
            }
        }
コード例 #3
0
        // GET: Orders/Details/5
        public ActionResult Invoice(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            try
            {
                var resultSet = from o in db.Order_line_item
                                join p in db.Product_Master
                                on o.ProductID equals p.Id
                                where o.OrderId == id
                                select new InvoiceOrder {
                    Product_name = p.Product_name, Rate = p.Rate, GST_rate = p.GST_rate, Quantity = o.Quantity, Price = o.Price, GST = o.GST, Total_price = o.Total_price
                };
                ////use Ienumerable

                Order orderrow = db.Orders.Single(x => x.ID == id);
                if (orderrow == null)
                {
                    return(HttpNotFound());
                }
                ViewBag.OrderDate    = orderrow.Order_date;
                ViewBag.DeliveryDate = orderrow.Scheduled_del_date;
                ViewBag.billDate     = DateTime.Now;
                ViewBag.TotalGST     = orderrow.Total_GST;
                ViewBag.OrderTotal   = orderrow.Total_order_price;

                Customer_Master customer_MasterRow = db.Customer_Master.Single(z => z.ID == orderrow.CustomerId);
                if (customer_MasterRow == null)
                {
                    return(HttpNotFound());
                }
                ViewBag.CustomerName    = customer_MasterRow.Name;
                ViewBag.CustomerAddress = customer_MasterRow.City + "," + customer_MasterRow.Address + "," + customer_MasterRow.Pincode;


                if (resultSet == null)
                {
                    return(HttpNotFound());
                }



                return(View(resultSet.ToList()));
            }
            catch (Exception e)
            {
                Console.WriteLine(e.InnerException);
                return(View("Error"));
                // throw;
            }
        }
コード例 #4
0
 // GET: Customer_Master/Edit/5
 public ActionResult Edit(int?id)
 {
     try {
         if (id == null)
         {
             return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
         }
         Customer_Master customer_Master = db.Customer_Master.Find(id);
         if (customer_Master == null)
         {
             return(HttpNotFound());
         }
         return(View(customer_Master));
     } catch (Exception e)
     {
         Console.WriteLine(e.InnerException);
         return(View("Error"));
     }
 }
コード例 #5
0
 public ActionResult Edit([Bind(Include = "ID,Name,Address,City,Pincode,ContactNumber,EmailId")] Customer_Master customer_Master)
 {
     try
     {
         if (ModelState.IsValid)
         {
             db.Entry(customer_Master).State = EntityState.Modified;
             db.SaveChanges();
             return(RedirectToAction("Index"));
         }
         return(View(customer_Master));
         //}
     }
     catch (Exception e)
     {
         Console.WriteLine(e.InnerException);
         return(View("Error"));
         // throw;
     }
 }