/// <summary>
///
/// </summary>
/// <param name="itemVM"></param>
/// <returns></returns>
public void FillCategoryList(ref Product itemMasterVM)
{
itemMasterVM.CategoryList = new List <SelectListItem>();
itemMasterVM.CategoryList.Add(new SelectListItem()
{
Text = Convert.ToString("Select Category"),
Value = Convert.ToString("-1")
});
DataSet ds = ProductMasterBll.GetAllDropDownData("AllCategory");
ds.Tables[0].TableName = "Category";
if (ds != null)
{
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
itemMasterVM.CategoryList.Add(new SelectListItem()
{
Text = Convert.ToString(item["CategoryName"]),
Value = Convert.ToString(item["CategoryId"])
});
}
}
}
}
public JsonResult LoadData()
{
try
{
// get allProduct
ProductMasterBll bll = new ProductMasterBll();
DataSet ds = bll.GetAllItems();
//---------
DataTable dtGrid = new DataTable();
//Users objUser = new Users();
dtGrid = ds.Tables[0];
List <Product> Gridd = new List <Product>();
foreach (DataRow dr in dtGrid.Rows)
{
Product Pro = new Product();
Pro.ProductId = Convert.ToInt32(dr["ProductId"]);
Pro.ProductName = dr["ProductName"].ToString();
Pro.CategoryName = dr["CategoryName"].ToString();
Pro.Image = dr["Image"].ToString();
Pro.Description = dr["Description"].ToString();
Gridd.Add(Pro);
}
return(Json(Gridd, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public JsonResult Create(Product itemMasterVM)
{
try
{
if (ModelState.IsValid)
{
ProductMasterBll bll = new ProductMasterBll();
bll.ProductId = itemMasterVM.ProductId;
bll.ProductName = itemMasterVM.ProductName;
bll.Image = itemMasterVM.Image;
bll.CategoryId = itemMasterVM.CategoryId;
bll.Description = itemMasterVM.Description;
int dtResponse = 0;
if (bll.ProductId > 0)
{
dtResponse = bll.UpdateProduct();
if (dtResponse > 0)
{
RedirectToAction("ProductList", "Product");
return(Json(new
{
ResponseStatus = "OK",
ResponseMessage = "Product Updated Successfully!",
// ResponseData = new { produ = Convert.ToString(dtResponse.Rows[0]["ProductId"]) }
}));
}
}
else
{
dtResponse = bll.SaveItem();
if (dtResponse > 0)
{
RedirectToAction("ProductList", "Product");
return(Json(new
{
ResponseStatus = "OK",
ResponseMessage = "Product Saved Successfully!",
// ResponseData = new { produ = Convert.ToString(dtResponse.Rows[0]["ProductId"]) }
}));
}
}
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(Json(new
{
ResponseStatus = "OK",
ResponseMessage = "Internal Server Error"
}));
}
public JsonResult Delete(int id)
{
Product itemMasterVM = new Product();
if (id > 0)
{
ProductMasterBll bl = new ProductMasterBll();
int dtresponse;
dtresponse = bl.DeleteItem(id);
if (dtresponse > 0)
{
RedirectToAction("ProductList", "Product");
}
}
return(Json(new
{
ResponseStatus = "OK",
ResponseMessage = "Product Deleted Successfully!",
// ResponseData = new { produ = Convert.ToString(dtResponse.Rows[0]["ProductId"]) }
}, JsonRequestBehavior.AllowGet));
}
// GET: CreateProduct
public ActionResult Create()
{
Product itemMasterVM = new Product();
if (HttpContext.Session["UserName"] == null || string.IsNullOrEmpty(Convert.ToString(HttpContext.Session["Email"])))
{
return(RedirectToAction("Index", "User"));
}
else
{
ViewBag.UserName = Convert.ToString(HttpContext.Session["UserName"]);
ViewBag.Email = Convert.ToString(HttpContext.Session["Email"]);
if (!string.IsNullOrEmpty(Convert.ToString(Request.QueryString["eid"])))
{
ViewData["Message"] = "Update";
ProductMasterBll bl = new ProductMasterBll();
DataSet ds = new DataSet();
ds = bl.GetItemByID(Convert.ToInt16(Request.QueryString["eid"]));
itemMasterVM.ProductId = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductId"]);
itemMasterVM.ProductName = Convert.ToString(ds.Tables[0].Rows[0]["ProductName"]);
itemMasterVM.CategoryId = Convert.ToInt32(ds.Tables[0].Rows[0]["CategoryId"]);
itemMasterVM.Image = Convert.ToString(ds.Tables[0].Rows[0]["Image"]);
itemMasterVM.Description = Convert.ToString(ds.Tables[0].Rows[0]["Description"]);
}
else
{
ViewData["Message"] = "Create";
}
itemMasterVM.CategoryList = new List <SelectListItem>();
FillCategoryList(ref itemMasterVM);
return(View(itemMasterVM));
}
}
