public ActionResult Edit(TblProduct tblProduct)
{
try
{
ViewBag.ProductCategoryId = new SelectList(db.TblProductCategories.Where(e => e.IsDelete == false).Select(e => new { e.ProductCategoryId, e.CategoryName }), "ProductCategoryId", "CategoryName", tblProduct.ProductCategoryId);
ViewBag.SupplierId = new SelectList(db.TblSuppliers.Where(e => e.IsDelete == false && e.IsActive == true).Select(e => new { e.SupplierId, e.SupplierName }), "SupplierId", "SupplierName", tblProduct.SupplierId);
tblProduct.ModifiedBy = Convert.ToInt32(BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString()));
tblProduct.ModifiedDate = DateTime.Now;
tblProduct.ProductName = tblProduct.productTitle;
if (tblProduct.srNumber == 0)
{
tblProduct.srNumber = 1000;
}
if (ModelState.IsValid)
{
db.Entry(tblProduct).State = EntityState.Modified;
db.SaveChanges();
var AlreadyselectedAttributes = db.TblProductAttributes.Where(e => e.ProductID == tblProduct.ProductID).ToList();
db.TblProductAttributes.RemoveRange(AlreadyselectedAttributes);
db.SaveChanges();
List <TblProductAttribute> LsttblProductAttributes = new List <TblProductAttribute>();
TblProductAttribute tblProductAttribute;
if (tblProduct.Attributes != null && tblProduct.Attributes != "")
{
var arr = tblProduct.Attributes.Split('$');
for (var i = 0; i < arr.Length - 1; i++)
{
var att = arr[i].Split('!');
if (att[1] != "")
{
var dd = att[1].Split(',').ToArray();
for (var k = 0; k < dd.Length - 1; k++)
{
tblProductAttribute = new TblProductAttribute();
tblProductAttribute.AttributeId = Convert.ToInt16(att[0]);
tblProductAttribute.MeasurementUnits = dd[k];
tblProductAttribute.ProductID = tblProduct.ProductID;
tblProductAttribute.CreatedDate = DateTime.Now;
LsttblProductAttributes.Add(tblProductAttribute);
}
}
}
}
db.TblProductAttributes.AddRange(LsttblProductAttributes);
db.SaveChanges();
TempData["msg"] = "2";
return(RedirectToAction("Index", new { id = tblProduct.StoreId }));
}
}
catch (Exception e)
{
TempData["msg"] = "0";
}
return(View(tblProduct));
}
public int AddProductAttributes(int productId, string attribute, int AttributeId)
{
try
{
TblProductAttribute tblProductAttribute = new TblProductAttribute();
tblProductAttribute.AttributeId = AttributeId;
tblProductAttribute.MeasurementUnits = attribute;
tblProductAttribute.ProductID = productId;
tblProductAttribute.CreatedDate = DateTime.Now;
db.TblProductAttributes.Add(tblProductAttribute);
db.SaveChanges();
return(1);
}
catch (Exception e)
{
}
return(0);
}
public ActionResult NewProduct(TblProduct tblProduct, IEnumerable <HttpPostedFileBase> file)
{
try
{
ViewBag.Attributes = db.TblAttributes.Where(e => e.IsDelete == false);
ViewBag.StoreId = new SelectList(db.TblStoreInformations.Where(e => e.IsDelete == false), "StoreId", "StoreName", tblProduct.StoreId);
ViewBag.ProductCategoryId = new SelectList(db.TblProductCategories.Where(e => e.IsDelete == false), "ProductCategoryId", "CategoryName", tblProduct.ProductCategoryId);
ViewBag.SupplierId = new SelectList(db.TblSuppliers.Where(e => e.IsDelete == false && e.IsActive == true).Select(e => new { e.SupplierId, e.SupplierName }), "SupplierId", "SupplierName", tblProduct.SupplierId);
//tblProduct = productModel.Product;
tblProduct.IsDelete = false;
tblProduct.IsActive = true;
tblProduct.CreatedBy = Convert.ToInt32(BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString()));
tblProduct.ModifiedBy = Convert.ToInt32(BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString()));
tblProduct.CreatedDate = DateTime.Now;
tblProduct.ModifiedDate = DateTime.Now;
tblProduct.PriceDispay = true;
tblProduct.ProductName = tblProduct.productTitle;
if (tblProduct.srNumber == 0)
{
tblProduct.srNumber = 1000;
}
List <TblProductImage> productImageList = new List <TblProductImage>();
if (file != null)
{
var i = 1;
TblProductImage productImage;
foreach (var p in file)
{
if (p != null)
{
productImage = new TblProductImage();
productImage.ProductImageURL = BaseUtil.UploadFile(p, "/Content/ProductImages");
productImageList.Add(productImage);
i++;
}
}
}
else
{
tblProduct.DisplayImg = "/images/item-01.jpgg";
}
if (ModelState.IsValid)
{
db.TblProducts.Add(tblProduct);
db.SaveChanges();
foreach (var productImage in productImageList)
{
productImage.ProductID = tblProduct.ProductID;
}
db.TblProductImages.AddRange(productImageList);
db.SaveChanges();
List <TblProductAttribute> LsttblProductAttributes = new List <TblProductAttribute>();
TblProductAttribute tblProductAttribute;
if (tblProduct.Attributes != null && tblProduct.Attributes != "")
{
var arr = tblProduct.Attributes.Split('$');
for (var i = 0; i < arr.Length - 1; i++)
{
var att = arr[i].Split('!');
var dd = att[1].Split(';');
for (var k = 0; k < dd.Length - 1; k++)
{
tblProductAttribute = new TblProductAttribute();
tblProductAttribute.AttributeId = Convert.ToInt16(att[0]);
tblProductAttribute.MeasurementUnits = dd[k];
tblProductAttribute.ProductID = tblProduct.ProductID;
tblProductAttribute.CreatedDate = DateTime.Now;
LsttblProductAttributes.Add(tblProductAttribute);
}
}
}
db.TblProductAttributes.AddRange(LsttblProductAttributes);
db.SaveChanges();
TempData["msg"] = "1";
return(RedirectToAction("products"));
}
TempData["msg"] = "0";
}
catch (Exception e)
{
TempData["msg"] = "0";
}
return(View(tblProduct));
}
