public int Created(ProductionModel data)
{
try
{
if (data.ProductID == 0)
{
var checkdata = _context.PRODUCTs.Where(x => x.ProductNameDesc == data.ProductNameDesc).ToList();
if (checkdata.Count() > 0)
{
return -1;
}
var new_data = new PRODUCT();
new_data.ProductNameDesc = data.ProductNameDesc;
new_data.ProductNameSort = data.ProductNameSort;
new_data.Color = data.Color ?? "";
new_data.Status = 1;
new_data.CreateBy = data.CreateBy ?? 0;
new_data.CreateDate = DateTime.Now;
new_data.UpdateBy = data.UpdateBy ?? 0;
new_data.UpdateDate = DateTime.Now;
new_data.Note = data.Note ?? "";
_context.Entry(new_data).State = EntityState.Added;
_context.SaveChanges();
var product_price = new PRODUCT_PRICE();
product_price.ProductID = new_data.ProductID;
product_price.CurrentPrice = data.CurrentPrice;
product_price.CreateBy = data.CreateBy ?? 0;
product_price.CreateDate = DateTime.Now;
product_price.UpdateBy = data.UpdateBy ?? 0;
product_price.UpdateDate = DateTime.Now;
product_price.Note = data.Note ?? "";
var result = CreatedProductPrice(product_price);
return result;
}
else
{
var checkdata = _context.PRODUCTs.Where(x => x.ProductNameDesc == data.ProductNameDesc && x.ProductID != data.ProductID).ToList();
if (checkdata.Count() > 0)
{
return -1;
}
var old_data = _context.PRODUCTs.Find(data.ProductID);
if (old_data != null)
{
old_data.ProductNameDesc = data.ProductNameDesc;
old_data.ProductNameSort = data.ProductNameSort;
old_data.Color = data.Color ?? "";
old_data.Status = 1;
old_data.UpdateBy = data.UpdateBy ?? 0;
old_data.UpdateDate = DateTime.Now;
old_data.Note = data.Note ?? "";
_context.Entry(old_data).State = EntityState.Modified;
_context.SaveChanges();
var product_price = new PRODUCT_PRICE();
product_price.ProductID = data.ProductID;
product_price.CurrentPrice = data.CurrentPrice;
product_price.CreateBy = data.CreateBy ?? 0;
product_price.CreateDate = DateTime.Now;
product_price.UpdateBy = data.UpdateBy ?? 0;
product_price.UpdateDate = DateTime.Now;
product_price.Note = data.Note ?? "";
var result = CreatedProductPrice(product_price);
return result;
}
return 0;
}
}
catch (Exception ex)
{
return 0;
}
}
public int CreatedProductPrice(PRODUCT_PRICE product_price)
{
try
{
var data = _context.PRODUCT_PRICE.Where(x => x.ProductID == product_price.ProductID).SingleOrDefault();
if (data != null)
{
data.WasPrice = data.CurrentPrice;
data.CurrentPrice = product_price.CurrentPrice;
data.Status = 1;
data.UpdateBy = product_price.UpdateBy;
data.UpdateDate = product_price.UpdateDate;
data.CreateBy = product_price.CreateBy;
data.CreateDate = product_price.CreateDate;
data.Note = product_price.Note;
data.Portions = "Regular";
_context.Entry(data).State = EntityState.Modified;
_context.SaveChanges();
return 1;
}
else
{
var new_data = new PRODUCT_PRICE();
new_data.ProductID = product_price.ProductID;
new_data.WasPrice = 0;
new_data.CurrentPrice = product_price.CurrentPrice;
new_data.Status = 1;
new_data.UpdateBy = product_price.UpdateBy;
new_data.UpdateDate = product_price.UpdateDate;
new_data.CreateBy = product_price.CreateBy;
new_data.CreateDate = product_price.CreateDate;
new_data.Note = product_price.Note;
new_data.Portions = "Regular";
_context.Entry(new_data).State = EntityState.Added;
_context.SaveChanges();
return 1;
}
}
catch (Exception)
{
return 0;
}
}
