예제 #1
0
        public ActionResult DeleteConfirmed(int id)
        {
            UserMas userMas = db.UserMas.Find(id);

            db.UserMas.Remove(userMas);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
예제 #2
0
 public ActionResult Edit([Bind(Include = "Id,Name,Phone,Email,UserType,ContactPerson,EmployeeId")] UserMas userMas)
 {
     if (ModelState.IsValid)
     {
         db.Entry(userMas).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.EmployeeId = new SelectList(db.Employees, "Id", "Name", userMas.EmployeeId);
     return(View(userMas));
 }
예제 #3
0
        // GET: VendorRetailer/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            UserMas userMas = db.UserMas.Find(id);

            if (userMas == null)
            {
                return(HttpNotFound());
            }
            return(View(userMas));
        }
예제 #4
0
        // GET: VendorRetailer/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            UserMas userMas = db.UserMas.Find(id);

            if (userMas == null)
            {
                return(HttpNotFound());
            }
            ViewBag.EmployeeId = new SelectList(db.Employees, "Id", "Name", userMas.EmployeeId);
            return(View(userMas));
        }
예제 #5
0
        //// POST: VendorRetailer/Create
        //// To protect from overposting attacks, please enable the specific properties you want to bind to, for
        //// more details see https://go.microsoft.com/fwlink/?LinkId=317598.
        //[HttpPost]
        //[ValidateAntiForgeryToken]
        //public ActionResult Create([Bind(Include = "Id,Name,Phone,Email,UserType,ContactPerson,EmployeeId")] UserMas userMas)
        //{
        //    if (ModelState.IsValid)
        //    {
        //        db.UserMas.Add(userMas);
        //        db.SaveChanges();
        //        return RedirectToAction("Index");
        //    }

        //    ViewBag.EmployeeId = new SelectList(db.Employees, "Id", "Name", userMas.EmployeeId);
        //    return View(userMas);
        //}



        public JsonResult SaveVendorRetailerOrder(IEnumerable <VMVendorRetailerDet> OrderDetails, VMVendorRetailerMas OrderMas)
        {
            var result = new
            {
                flag    = false,
                message = "Error occured. !",
                Id      = 0
            };

            try
            {
                using (var dbContextTransaction = db.Database.BeginTransaction())
                {
                    try
                    {
                        var OrderM = new UserMas()
                        {
                            Id             = 0,
                            Name           = OrderMas.Name,
                            Phone          = OrderMas.Phone,
                            Email          = OrderMas.Email,
                            UserType       = 0,
                            ContactPerson  = OrderMas.ContactPerson,
                            EmployeeId     = OrderMas.EmployeeId,
                            InitialBalance = OrderMas.InitialBalance
                                             //Type = OrderMas.ProdDepartmentId,
                        };

                        db.UserMas.Add(OrderM);
                        db.SaveChanges();

                        Dictionary <int, int> dictionary =
                            new Dictionary <int, int>();



                        if (OrderDetails != null)
                        {
                            foreach (var item in OrderDetails)
                            {
                                //var OrderLocation = new Location()
                                //{
                                //    Id = 0,
                                //    Name = item.Location,
                                //    Cost = item.CarryingCost

                                //};

                                //db.Location.Add(OrderLocation);
                                //db.SaveChanges();

                                //var OrderRetailerItems = new VendorRetailerItems()
                                //{
                                //    Id = 0,
                                //    UserMasId = OrderM.Id,
                                //    ItemId = item.ItemId,
                                //    ItemCost = item.UnitPrice


                                //};

                                //db.VendorRetailerItems.Add(OrderRetailerItems);
                                //db.SaveChanges();


                                var OrderD = new UserDet()
                                {
                                    Id           = 0,
                                    UserMasId    = OrderM.Id,
                                    ItemId       = item.ItemId,
                                    LocationId   = item.LocationId,
                                    UnitPrice    = item.UnitPrice,
                                    CarryingCost = item.CarryingCost
                                };

                                db.UserDet.Add(OrderD);
                                db.SaveChanges();

                                dictionary.Add(item.TempOrderDetId, OrderD.Id);
                            }
                        }


                        dbContextTransaction.Commit();

                        result = new
                        {
                            flag    = true,
                            message = "Saving successful!!",
                            Id      = OrderM.Id
                        };

                        Success("Record saved successfully.", true);
                    }
                    catch (Exception ex)
                    {
                        dbContextTransaction.Rollback();

                        result = new
                        {
                            flag    = false,
                            message = ex.Message,
                            Id      = 0
                        };
                    }
                }
            }
            catch (Exception ex)
            {
                result = new
                {
                    flag    = false,
                    message = ex.Message,
                    Id      = 0
                };
            }


            return(Json(result, JsonRequestBehavior.AllowGet));
        }