public JsonResult UpdateVendor(EResVendorViewModel viewModel)
        {
            bool   bReturn = false;
            string message = "failed";

            EResVendor myVendor = _db.EResVendors.Find(viewModel.VendorID);

            if (myVendor != null)
            {
                myVendor.VendorName = viewModel.VendorName;

                try
                {
                    _db.SaveChanges();

                    bReturn = true;
                    message = "success";
                }
                catch (InvalidOperationException ex)
                {
                    message = ex.Message;
                }
            }

            return(Json(new
            {
                Success = bReturn,
                Message = message,
                SelectList = _db.EResVendorsDropdown()
            }, JsonRequestBehavior.AllowGet));
        }
        public JsonResult DeleteVendor(int id)
        {
            bool   bReturn = false;
            string message = "failed";

            EResVendor myVendor = _db.EResVendors.Find(id);

            if (myVendor != null)
            {
                EResVendor deletedVendor = _db.EResVendors.Remove(myVendor);
                if (deletedVendor != null)
                {
                    try
                    {
                        if (_db.SaveChanges() > 0)
                        {
                            bReturn = true;
                            message = "success";
                        }
                    }
                    catch (Exception ex)
                    {
                        message = ex.Message;
                    }
                }
            }

            return(Json(new
            {
                Success = bReturn,
                Message = message,
                SelectList = _db.EResVendorsDropdown()
            }, JsonRequestBehavior.AllowGet));
        }
        public JsonResult CreateVendor(EResVendorViewModel viewModel)
        {
            bool   bReturn = false;
            string message = "failed";

            EResVendor newVendor = new EResVendor()
            {
                VendorName = viewModel.VendorName
            };

            if (_db.EResVendors.Add(newVendor) != null)
            {
                if (_db.SaveChanges() > 0)
                {
                    bReturn = true;
                    message = "success";
                }
            }

            return(Json(new
            {
                Success = bReturn,
                Message = message,
                SelectList = _db.EResVendorsDropdown()
            }, JsonRequestBehavior.AllowGet));
        }