//=============
#region Delete
public static SSBC_Data.SourceContext.MSG Delete(IEnumerable <SSBC_Data.Entities.SSBCInventoryFirst> items)
{
var _return = new SSBC_Data.SourceContext.MSG();
try
{
var dbContext = new SSBC_Data.SourceContext();
foreach (var item in items)
{
var itemDel = dbContext.SSBCInventoryFirsts.Where(s => s.MaterialCo == item.MaterialCo &&
s.ColorCode == item.ColorCode).FirstOrDefault();
dbContext.Entry(itemDel).State = System.Data.Entity.EntityState.Deleted;
}
;
dbContext.SaveChanges();
_return = new SSBC_Data.SourceContext.MSG("Deleted", false);
}
catch (Exception err)
{
_return = new SSBC_Data.SourceContext.MSG("Deleted", true);
_return.MsgInformation += "\n " + err.ToString();
}
return(_return);
}
public static SSBC_Data.SourceContext.MSG Save(SSBC_Data.Entities.SSBCMixVouchers item)
{
var _return = new SSBC_Data.SourceContext.MSG();
try
{
using (var dbContext = new SSBC_Data.SourceContext())
{
//check the ObjectState property and mark appropriate EntityState
if (item.UpdateStatus == "Added")
{
var items = dbContext.SSBCMixVouchers;
var itemCheck = items.Where(s => s.VoucherId == item.VoucherId).ToList();
if (itemCheck.Count > 0)
{
_return.IsError = true;
_return.MsgInformation = "Can not save data <<Duplication>>!";
}
else
{
//item.UserAdded = tmpLogin.Id;
//item.UserAddedTime = DateTime.Now;
//item.UserUpdate = tmpLogin.Id;
//item.UserUpdateTime = DateTime.Now;
// int MaxID = items.Count() == 0 ? 0 : items.Max(x => x == null ? 0 :(int)x.Seq);
// item.Seq = MaxID + 1;
// item.VoucherId = "I" +item.Seq.ToString();
dbContext.Entry(item).State = System.Data.Entity.EntityState.Added;
}
}
else if (item.UpdateStatus == "Modified")
{
//item.UserUpdate = tmpLogin.Id;
//item.UserUpdateTime = DateTime.Now;
dbContext.Entry(item).State = System.Data.Entity.EntityState.Modified;
//dbContext.Entry(item).Property(x => x.Seq).IsModified = false;
//dbContext.Entry(item).Property(x => x.UserAdded).IsModified = false;
//dbContext.Entry(item).Property(x => x.UserAddedTime).IsModified = false;
//dbContext.Entry(item).Property(x => x.Isdel).IsModified = false;
}
else if (item.UpdateStatus == "Deleted")
{
dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted;
}
else
{
dbContext.Entry(item).State = System.Data.Entity.EntityState.Unchanged;
}
//=========================
if (_return.IsError != true)
{
dbContext.SaveChanges();
_return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, false);
}
}
}
catch (Exception err)
{
_return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, true);
_return.MsgInformation += "\n " + err.ToString();
}
return(_return);
}
public static SSBC_Data.SourceContext.MSG Save(SSBC_Data.Entities.SSBCCrushTrackings item, string Symbol)
{
var _return = new SSBC_Data.SourceContext.MSG();
try
{
using (var dbContext = new SSBC_Data.SourceContext())
{
//check the ObjectState property and mark appropriate EntityState
if (item.UpdateStatus == "Added")
{
var items = dbContext.SSBCCrushTrackings.Where(x => x.ScaleDate.Value.Year == item.ScaleDate.Value.Year);
var itemCheck = items.Where(s => s.TrackNo == item.TrackNo).ToList();
if (itemCheck.Count > 0)
{
_return.IsError = true;
_return.MsgInformation = "Can not save data <<Duplication>>!";
}
else
{
item.UserAdded = tmpLogin.Id;
item.UserAddedTime = DateTime.Now;
item.UserUpdate = tmpLogin.Id;
item.UserUpdateTime = DateTime.Now;
int MaxID = items.Count() == 0 ? 0 : items.Max(x => x == null ? 0 : (int)x.Seq);
item.Seq = MaxID + 1;
item.TrackNo = "CR" + item.ScaleDate.Value.Year.ToString().Substring(2, 2) + item.Seq.ToString("00000#") + "-" + Symbol;
dbContext.Entry(item).State = System.Data.Entity.EntityState.Added;
}
}
else if (item.UpdateStatus == "Modified")
{
item.UserUpdate = tmpLogin.Id;
item.UserUpdateTime = DateTime.Now;
dbContext.Entry(item).State = System.Data.Entity.EntityState.Modified;
dbContext.Entry(item).Property(x => x.Seq).IsModified = false;
dbContext.Entry(item).Property(x => x.UserAdded).IsModified = false;
dbContext.Entry(item).Property(x => x.UserAddedTime).IsModified = false;
//dbContext.Entry(item).Property(x => x.Isdel).IsModified = false;
}
else if (item.UpdateStatus == "Deleted")
{
dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted;
}
else
{
dbContext.Entry(item).State = System.Data.Entity.EntityState.Unchanged;
}
//=========================
if (_return.IsError != true)
{
dbContext.SaveChanges();
_return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, false);
}
}
}
catch (Exception err)
{
_return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, true);
_return.MsgInformation += "\n " + err.ToString();
}
return(_return);
}
public static SSBC_Data.SourceContext.MSG Save(SSBC_Data.Entities.SSBCMixTrackings item, decimal MaxBatchQty)
{
var _return = new SSBC_Data.SourceContext.MSG();
try
{
using (var dbContext = new SSBC_Data.SourceContext())
{
//check the ObjectState property and mark appropriate EntityState
if (item.UpdateStatus == "Added")
{
var items = dbContext.SSBCMixTrackings.Where(x => x.ScaleDate.Value.Year == item.ScaleDate.Value.Year);
var ItemGroup = items.Where(x => x.ProForBacode == item.ProForBacode);
var itemCheck = items.Where(s => s.TrackNo == item.TrackNo).ToList();
if (itemCheck.Count > 0)
{
_return.IsError = true;
_return.MsgInformation = "Can not save data <<Duplication>>!";
}
else
{
item.UserAdded = tmpLogin.Id;
item.UserAddedTime = DateTime.Now;
item.UserUpdate = tmpLogin.Id;
item.UserUpdateTime = DateTime.Now;
int BatchNo = ItemGroup.Count() == 0 ? 0 : ItemGroup.Max(x => x == null ? 0 : (int)x.BatchNo);
decimal Total_BatchQty = 0;
if (BatchNo == 0)
{
BatchNo = 1;
Total_BatchQty = 0;
}
else
{
Total_BatchQty = (decimal)ItemGroup.Sum(x => x.ScaleWeight);
}
if (Total_BatchQty + item.ScaleWeight <= MaxBatchQty)
{
item.BatchNo = BatchNo;
}
else
{
item.BatchNo = BatchNo + 1;
}
int MaxID = items.Count() == 0 ? 0 : items.Max(x => x == null ? 0 : (int)x.Seq);
item.Seq = MaxID + 1;
item.Year = item.ScaleDate.Value.Year.ToString();
item.TrackNo = "MI" + item.Year.Substring(2, 2) + item.Seq.ToString("00000#");
item.CountLabel = items.Where(x => x.ProForBacode == item.ProForBacode).Count();//
dbContext.Entry(item).State = System.Data.Entity.EntityState.Added;
}
}
else if (item.UpdateStatus == "Modified")
{
item.UserUpdate = tmpLogin.Id;
item.UserUpdateTime = DateTime.Now;
dbContext.Entry(item).State = System.Data.Entity.EntityState.Modified;
dbContext.Entry(item).Property(x => x.Seq).IsModified = false;
dbContext.Entry(item).Property(x => x.UserAdded).IsModified = false;
dbContext.Entry(item).Property(x => x.UserAddedTime).IsModified = false;
//dbContext.Entry(item).Property(x => x.Isdel).IsModified = false;
}
else if (item.UpdateStatus == "Deleted")
{
dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted;
}
else
{
dbContext.Entry(item).State = System.Data.Entity.EntityState.Unchanged;
}
//=========================
if (_return.IsError != true)
{
dbContext.SaveChanges();
_return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, false);
}
}
}
catch (Exception err)
{
_return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, true);
_return.MsgInformation += "\n " + err.ToString();
}
return(_return);
}