public ProductModal DeleteProduct(int intProductId)
{
ProductModal _objdata = new ProductModal();
tbl_Products _objproduct = new tbl_Products();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Products.Where(x => x.int_id == intProductId).FirstOrDefault();
if (_query != null)
{
tbl_Products _log = new tbl_Products();
_log = dataContext.tbl_Products.Where(x => x.int_id == intProductId).FirstOrDefault();
_log.b_IsActive = false;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Product updated sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public ActionResult SaveProduct(HttpPostedFileBase file, ProductModal _viewProductModal)
{
var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState.IsValid)
{
List <ProductBrands> _listBrand = new List <ProductBrands>();
List <ProductCategory> _listCategory = new List <ProductCategory>();
_listBrand = _objproductBAL.GetBrands();
_listCategory = _objproductBAL.GetCategory();
_viewProductModal._listBrand = _listBrand;
_viewProductModal._listCategory = _listCategory;
if (file != null)
{
string strImgName = System.IO.Path.GetFileName(file.FileName);
string strPath = Server.MapPath("~/Content/product/");
if (!Directory.Exists(strPath))
{
Directory.CreateDirectory(strPath);
}
else
{
strPath = Server.MapPath("~/Content/product/");
}
string strImagePath = Server.MapPath("~/Content/product/" + strImgName);
file.SaveAs(strImagePath);
_viewProductModal.strImagePath = strImgName;
if (_viewProductModal.intProductId == 0)
{
_objproductBAL.SaveProduct(_viewProductModal);
}
else
{
_objproductBAL.UpdateProduct(_viewProductModal);
}
ModelState.AddModelError("", _viewProductModal.StatusMessaage);
}
ModelState.Clear();
}
return(RedirectToAction("Index", "Product"));
}
public ActionResult AddProductTable(ProductModal data)
{
Products prod = new Products
{
Product = data.Product,
ProductGroupName = data.ProductGroupName,
BreadUnits = Convert.ToDouble(data.BreadUnits.Replace('.', ',')),
Carbohydrates = Convert.ToDouble(data.Carbohydrates.Replace('.', ',')),
GrammInUnit = data.GrammInUnit,
ProductGroup = Read.getProductGroups().First(x => x.GroupName == data.ProductGroupName).GroupID
};
if (data != null)
{
Create.insertProduct(prod);
}
return(RedirectToAction("Content", "Admin"));
}
public ProductModal GetProductById(ProductModal _productmodal)
{
ProductModal _objproduct = new ProductModal();
using (newconecommerce dataContext = new newconecommerce())
{
_productmodal = (from x in dataContext.tbl_Products
where x.int_id == _productmodal.intProductId
select new ProductModal
{
strProductName = x.v_name,
dblPrice = x.fl_price,
dblWeight = x.fl_weight,
strImagePath = x.v_image,
intQuantity = x.int_quantity,
flLength = x.fl_length,
flBreadth = x.fl_breadth,
flHeight = x.fl_height,
flGST = x.fl_GST,
dblQtyDiscount = x.fl_QtyDiscount,
intBrands = x.int_BrandsId,
intCategory = x.int_CategoryId,
strDescription = x.v_description_info
}).AsEnumerable().Select(x => new ProductModal
{
strProductName = x.strProductName,
dblPrice = x.dblPrice,
dblWeight = x.dblWeight,
strImagePath = x.strImagePath,
intQuantity = x.intQuantity,
flLength = x.flLength,
flBreadth = x.flBreadth,
flHeight = x.flHeight,
flGST = x.flGST,
dblQtyDiscount = x.dblQtyDiscount,
intBrands = x.intBrands,
intCategory = x.intCategory,
strDescription = x.strDescription
}).FirstOrDefault();
return(_productmodal);
}
}
public ProductModal UpdateProduct(ProductModal _objdata)
{
tbl_Products _objproduct = new tbl_Products();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Products.Where(x => x.int_id == _objdata.intProductId).FirstOrDefault();
if (_query != null)
{
tbl_Products _log = new tbl_Products();
_log = dataContext.tbl_Products.Where(x => x.int_id == _objdata.intProductId).FirstOrDefault();
_log.v_name = _objdata.strProductName;
_log.fl_price = _objdata.dblPrice;
_log.int_quantity = _objdata.intQuantity;
_log.fl_weight = _objdata.dblWeight;
_log.fl_length = _objdata.flLength;
_log.fl_breadth = _objdata.flBreadth;
_log.fl_height = _objdata.flHeight;
_log.fl_GST = _objdata.flGST;
_log.fl_QtyDiscount = _objdata.dblQtyDiscount;
_log.int_BrandsId = _objdata.intBrands;
_log.int_CategoryId = _objdata.intCategory;
_log.v_image = _objdata.strProductName;
_log.v_description_info = _objdata.strDescription;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Product updated sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public ActionResult SaveProduct(int intProductId)
{
ProductModal _viewProductModal = new ProductModal();
_viewProductModal.intProductId = intProductId;
List <ProductBrands> _listBrand = new List <ProductBrands>();
List <ProductCategory> _listCategory = new List <ProductCategory>();
_listBrand = _objproductBAL.GetBrands();
_listCategory = _objproductBAL.GetCategory();
if (_viewProductModal.intProductId != 0)
{
_viewProductModal = _objproductBAL.GetProductById(_viewProductModal);
}
_viewProductModal._listBrand = _listBrand;
_viewProductModal._listCategory = _listCategory;
return(View(_viewProductModal));
}
public ActionResult EditProductTable(int ID)
{
Products product = Read.getBreadUnitsTable().FirstOrDefault(x => x.ID == ID);
ProductModal pm = new ProductModal
{
ID = product.ID,
Product = product.Product,
ProductGroup = product.ProductGroup,
ProductGroupName = product.ProductGroupName,
BreadUnits = product.BreadUnits.ToString().Replace(',', '.'),
Carbohydrates = product.Carbohydrates.ToString().Replace(',', '.'),
GrammInUnit = product.GrammInUnit
};
List <string> groups = new List <string>();
Read.getProductGroups().ForEach(x => groups.Add(x.GroupName));
ViewBag.Groups = new SelectList(groups);
return(PartialView("~/Views/Admin/Content/ProductForms/EditProduct.cshtml", pm));
}
public ProductModal SaveProduct(ProductModal _objdata)
{
tbl_Products _objproduct = new tbl_Products();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
_objproduct.v_name = _objdata.strProductName;
_objproduct.fl_price = Convert.ToDouble(_objdata.dblPrice);
_objproduct.int_quantity = _objdata.intQuantity;
_objproduct.fl_weight = Convert.ToDouble(_objdata.dblWeight);
_objproduct.fl_length = Convert.ToDouble(_objdata.flLength);
_objproduct.fl_breadth = Convert.ToDouble(_objdata.flBreadth);
_objproduct.fl_height = Convert.ToDouble(_objdata.flHeight);
_objproduct.fl_GST = Convert.ToDouble(_objdata.flGST);
_objproduct.fl_QtyDiscount = _objdata.dblQtyDiscount;
_objproduct.int_BrandsId = _objdata.intBrands;
_objproduct.int_CategoryId = _objdata.intCategory;
_objproduct.v_image = _objdata.strImagePath;
_objproduct.v_description_info = _objdata.strDescription;
_objproduct.dt_created_on = DateTime.Now;
_objproduct.b_IsActive = true;
dataContext.tbl_Products.Add(_objproduct);
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
_objdata.StatusMessaage = "Product save sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public ProductModal GetProductById(ProductModal _productmodal)
{
return(_dataaccess.GetProductById(_productmodal));
}
public ProductModal UpdateProduct(ProductModal _objproduct)
{
return(_dataaccess.UpdateProduct(_objproduct));
}
public ProductModal SaveProduct(ProductModal _objproduct)
{
return(_dataaccess.SaveProduct(_objproduct));
}
