public ActionResult Add()
{
var model = new AddProduct();
try
{
model.Price = "0";
model.Discount = "0";
model.BrandSelectOptions = DropDownListOption.GetBrandOptions();
model.CategorySelectOptions = DropDownListOption.GetCategoryOptions();
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
// Write error log
var log = new Log();
log.LogDate = DateTime.Now;
log.Action = "Product - Add()";
log.Tags = "Error";
log.Message = ex.ToString();
db.Logs.Add(log);
}
return(View(model));
}
public ActionResult ImportHistory()
{
ViewBag.BrandSelectOptions = DropDownListOption.GetBrandOptions();
ViewBag.CategorySelectOptions = DropDownListOption.GetCategoryOptions();
ViewBag.SupplierSelectOptions = DropDownListOption.GetSupplierOptions();
return(View());
}
public ActionResult Edit(EditProduct model)
{
try
{
if (ModelState.IsValid)
{
var product = db.Products.Where(p => p.ProductId == model.ProductId).FirstOrDefault();
if (product != null)
{
decimal price = 0;
decimal discount = 0;
if (Decimal.TryParse(model.Price.Replace(",", ""), out price) &&
Decimal.TryParse(model.Discount.Replace(",", ""), out discount))
{
product.ProductName = model.ProductName;
product.ProductNameUnsign = StringExtensions.convertToUnSign(model.ProductName).ToLower();
product.Description = model.Description;
product.DescriptionUnsign = StringExtensions.convertToUnSign(model.Description).ToLower();
product.BrandId = model.BrandId;
product.CategoryId = model.CategoryId;
product.SKU = model.SKU;
product.QuantityPerUnit = model.QuantityPerUnit;
product.Price = price;
product.Discount = discount;
product.LastUpdate = DateTime.Now;
product.LastUpdateUser = GetLogonUserName();
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Giá sản phẩm không hợp lệ!");
}
}
else
{
ModelState.AddModelError("", "Không tìm thấy sản phẩm!!!");
}
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
// Write error log
var log = new Log();
log.LogDate = DateTime.Now;
log.Action = "Product - Edit()";
log.Tags = "Error";
log.Message = ex.ToString();
db.Logs.Add(log);
}
finally
{
model.BrandSelectOptions = DropDownListOption.GetBrandOptions(model.BrandId ?? 0);
model.CategorySelectOptions = DropDownListOption.GetCategoryOptions(model.CategoryId ?? 0);
}
return(View(model));
}
private void BindOption()
{
DropDownListOption.DataSource = SPARInsightManagement.Web.Code.Option.GetOptionList();
DropDownListOption.DataTextField = "Description";
DropDownListOption.DataValueField = "OptionId";
DropDownListOption.DataBind();
DropDownListOption.Items.Remove("4"); //Mobile
DropDownListOption.Items.Remove("5"); //Adhoc
DropDownListOption.Items.Insert(0, new ListItem("Please select", "0"));
}
public ActionResult Edit(int id)
{
var model = new EditProduct();
try
{
var product = db.Products.Where(p => p.ProductId == id).FirstOrDefault();
if (product != null)
{
model.ProductId = product.ProductId;
model.ProductName = product.ProductName;
model.Description = product.Description;
model.BrandId = product.BrandId;
model.CategoryId = product.CategoryId;
model.SKU = product.SKU;
model.QuantityPerUnit = product.QuantityPerUnit;
model.Price = product.Price.ToString("#,##0");
model.Discount = product.Discount.ToString("#,##0");
return(View(model));
}
else
{
ModelState.AddModelError("", "Không tìm thấy sản phẩm!!!");
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
// Write error log
var log = new Log();
log.LogDate = DateTime.Now;
log.Action = "Product - Edit()";
log.Tags = "Error";
log.Message = ex.ToString();
db.Logs.Add(log);
}
finally
{
model.BrandSelectOptions = DropDownListOption.GetBrandOptions(model.BrandId ?? 0);
model.CategorySelectOptions = DropDownListOption.GetCategoryOptions(model.CategoryId ?? 0);
}
return(View(model));
}
public ActionResult EditImport(int id)
{
var model = new EditImport();
try
{
var import = db.Imports.Where(im => im.ImportId == id).FirstOrDefault();
if (import != null)
{
model.ImportId = import.ImportId;
model.ImportDate = import.ImportDate.ToString("dd/MM/yyyy");
model.SupplierId = import.SupplierId;
model.ProductId = import.ProductId;
model.Quantity = import.Quantity.ToString("#,##0");
model.ImportPrice = import.ImportPrice.ToString("#,##0");
model.Note = import.Note;
model.SupplierSelectOptions = DropDownListOption.GetSupplierOptions(import.SupplierId);
model.ProductSelectOptions = DropDownListOption.GetProductOptions(import.ProductId);
}
else
{
ModelState.AddModelError("", "Không tìm thấy thông tin nhập kho!");
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
// Write error log
var log = new Log();
log.LogDate = DateTime.Now;
log.Action = "Stock - EditImport()";
log.Tags = "Error";
log.Message = ex.ToString();
db.Logs.Add(log);
}
return(View(model));
}
public ActionResult EditExport(EditExport model)
{
try
{
if (ModelState.IsValid)
{
var export = db.Exports.Where(im => im.ExportId == model.ExportId).FirstOrDefault();
if (export != null)
{
int quantity = 0;
decimal exportPrice = 0;
DateTime exportDate = DateTime.Now;
// Validate user input data
if (!DateTime.TryParseExact(model.ExportDate, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out exportDate))
{
ModelState.AddModelError("", "Ngày xuất không hợp lệ!");
return(View(model));
}
if (!int.TryParse(model.Quantity.Replace(",", ""), out quantity))
{
ModelState.AddModelError("", "Số lượng xuất không hợp lệ!");
return(View(model));
}
if (!decimal.TryParse(model.ExportPrice.Replace(",", ""), out exportPrice))
{
ModelState.AddModelError("", "Giá xuất không hợp lệ!");
return(View(model));
}
// update product unit in stock
var currentProduct = db.Products.Where(p => p.ProductId == export.ProductId).FirstOrDefault();
if (currentProduct != null)
{
currentProduct.UnitInStock -= export.Quantity;
}
if (currentProduct.ProductId == model.ProductId)
{
currentProduct.UnitInStock += quantity;
}
else
{
var updatedProduct = db.Products.Where(p => p.ProductId == model.ProductId).FirstOrDefault();
if (updatedProduct != null)
{
updatedProduct.UnitInStock += quantity;
}
}
// update import info
export.ExportDate = exportDate;
export.ProductId = model.ProductId;
export.Quantity = quantity;
export.ExportPrice = exportPrice;
export.Note = model.Note;
db.SaveChanges();
return(RedirectToAction("ExportHistory"));
}
else
{
ModelState.AddModelError("", "Không tìm thấy thông tin xuất kho!");
return(View(model));
}
}
else
{
ModelState.AddModelError("", "Thông tin xuất kho không hợp lệ!");
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
// Write error log
var log = new Log();
log.LogDate = DateTime.Now;
log.Action = "Stock - EditExport()";
log.Tags = "Error";
log.Message = ex.ToString();
db.Logs.Add(log);
}
finally
{
model.ProductSelectOptions = DropDownListOption.GetProductOptions(model.ProductId);
}
return(View(model));
}
public ActionResult Index()
{
ViewBag.BrandSelectOptions = DropDownListOption.GetBrandOptions();
ViewBag.CategorySelectOptions = DropDownListOption.GetCategoryOptions();
return(View());
}
