public ActionResult ProductEntry()
{
GetSetting();
ProductModels.ProductDetail detail = new ProductModels.ProductDetail();
if (ViewBag.isMultiBranchDifProductByBranch == true)
{
detail.lstBranch = GetProductAvailableBranch();
}
return(View(detail));
}
public ActionResult InsertProductVariant(ProductModels.ProductDetail product)
{
GetSetting();
ProductModels.ProductVariant variant = new ProductModels.ProductVariant();
variant.Variant = product.ProductVariant.Variant.ToString();
lstProductVariant.Add(variant);
ViewBag.Variant = lstProductVariant;
ProductModels.ProductDetail detail = new ProductModels.ProductDetail();
if (ViewBag.isMultiBranchDifProductByBranch == true)
{
detail.lstBranch = GetProductAvailableBranch();
}
return(View("ProductEntry", detail));
}
public ActionResult InsertProduct(ProductModels.ProductDetail product, HttpPostedFileBase file, int[] availableBranch)
{
//Entities.PrcInsertProduct(product.ProductModel.Code, product.ProductModel.SortCode, product.ProductModel.ProductName, product.ProductModel.Description, product.ProductModel.SubMenuID,1200,1500,1300, product.ProductModel.isUnit, product.ProductModel.isStock, product.ProductModel.Photo, product.ProductModel.AlertQuantity, Convert.ToInt16(product.ProductModel.DiscountPercent),null, product.ProductModel.QRCode, product.ProductModel.isVariant);
GetSetting();
ProductModels.ProductDetail detail = new ProductModels.ProductDetail();
var pCode = Entities.S_Product.Where(p => p.Code == product.ProductModel.Code).FirstOrDefault();
var pSortCode = Entities.S_Product.Where(p => p.SortCode == product.ProductModel.SortCode).FirstOrDefault();
if (pCode == null && pSortCode == null)
{
S_Product tbl_Product = new S_Product();
tbl_Product.ProductName = product.ProductModel.ProductName;
tbl_Product.Code = product.ProductModel.Code;
tbl_Product.SortCode = product.ProductModel.SortCode;
tbl_Product.Description = product.ProductModel.Description;
if (product.ProductModel.SubMenuID == 0)
{
tbl_Product.SubMenuID = null;
}
else
{
tbl_Product.SubMenuID = product.ProductModel.SubMenuID;
}
if (product.ProductModel.PurchasePrice == 0)
{
tbl_Product.PurPrice = null;
}
else
{
tbl_Product.PurPrice = (decimal)product.ProductModel.PurchasePrice;
}
if (product.ProductModel.SalePrice == 0)
{
tbl_Product.SalePrice = null;
}
else
{
tbl_Product.SalePrice = (decimal)product.ProductModel.SalePrice;
}
if (product.ProductModel.WholeSalePrice == 0)
{
tbl_Product.WholeSalePrice = null;
}
else
{
tbl_Product.WholeSalePrice = (decimal)product.ProductModel.WholeSalePrice;
}
tbl_Product.IsUnit = product.ProductModel.isUnit;
tbl_Product.IsStock = product.ProductModel.isStock;
if (file != null)
{
if (file.ContentLength > 0)
{
product.ProductModel.Photo = new byte[file.ContentLength];
file.InputStream.Read(product.ProductModel.Photo, 0, file.ContentLength);
tbl_Product.Photo = product.ProductModel.Photo;
}
}
else
{
tbl_Product.Photo = null;
}
if (product.ProductModel.AlertQuantity == 0)
{
tbl_Product.AlertQty = null;
}
else
{
tbl_Product.AlertQty = product.ProductModel.AlertQuantity;
}
if (product.ProductModel.DiscountPercent == 0)
{
tbl_Product.DisPercent = null;
}
else
{
tbl_Product.DisPercent = (Int16)product.ProductModel.DiscountPercent;
}
tbl_Product.Barcode = product.ProductModel.BarCode;
tbl_Product.QRcode = product.ProductModel.QRCode;
tbl_Product.IsVariant = product.ProductModel.isVariant;
Entities.S_Product.Add(tbl_Product);
Entities.SaveChanges();
//Get Recently ProductID
int product_id = Entities.S_Product.Max(p => p.ProductID);
//if MultiBranch and difference product by branch
if (availableBranch != null)
{
for (int i = 0; i < availableBranch.Count(); i++)
{
S_ProductBranch tbl_ProductBranch = new S_ProductBranch();
tbl_ProductBranch.ProductID = product_id;
tbl_ProductBranch.BranchID = availableBranch[i];
Entities.S_ProductBranch.Add(tbl_ProductBranch);
Entities.SaveChanges();
}
}
//if Product Variant...
if (lstProductVariant.Count > 0)
{
for (int i = 0; i < lstProductVariant.Count; i++)
{
S_ProductVariant tbl_ProductVariant = new S_ProductVariant();
tbl_ProductVariant.ProductID = product_id;
tbl_ProductVariant.Variant = lstProductVariant[i].Variant.ToString();
Entities.S_ProductVariant.Add(tbl_ProductVariant);
Entities.SaveChanges();
}
lstProductVariant.Clear();
}
ModelState.Clear();
ViewBag.Message = "Product is Inserted Successful...";
}
else
{
if (pCode != null && pSortCode == null)
{
ViewBag.Message = "Product Code is Duplicate";
}
else if (pCode == null && pSortCode != null)
{
ViewBag.Message = "Product SortCode is Duplicated..";
}
else
{
ViewBag.Message = "Product Code and SortCode are duplicated";
}
ViewBag.Variant = lstProductVariant;
if (availableBranch != null)
{
ViewBag.isCheckedBranch = availableBranch;
}
}
if (ViewBag.isMultiBranchDifProductByBranch == true)
{
detail.lstBranch = GetProductAvailableBranch();
}
return(View("ProductEntry", detail));
}
