//=============
#region Delete
public static Source.Data.SourceContext.MSG Delete(IEnumerable <Source.Data.Entities.StockCloseEnds> items)
{
var _return = new Source.Data.SourceContext.MSG();
try
{
var dbContext = new Source.Data.SourceContext();
foreach (var item in items)
{
var itemDel = dbContext.StockCloseEnds.Where(s => s.Yy == item.Yy &&
s.Mm == item.Mm &&
s.StockName == item.StockName).FirstOrDefault();
dbContext.Entry(itemDel).State = System.Data.Entity.EntityState.Deleted;
}
;
dbContext.SaveChanges();
_return = new Source.Data.SourceContext.MSG("Deleted", false);
}
catch (Exception err)
{
_return = new Source.Data.SourceContext.MSG("Deleted", true);
_return.MsgInformation += "\n " + err.ToString();
}
return(_return);
}
public static Source.Data.SourceContext.MSG Save(Source.Data.Entities.StockCloseEnds item)
{
var _return = new Source.Data.SourceContext.MSG();
try
{
// using (var dbContext = new Source.Data.SourceContext())
// {
// //check the ObjectState property and mark appropriate EntityState
// if (item.UpdateStatus == "Added")
// {
// var items = dbContext.StockCloseEnds;
// var itemCheck = items.Where(s => s.Yy == item.Yy
// && s.Mm == item.Mm
// && s.StockName == item.StockName).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.Yy = "I" +item.Seq.ToString();
// item.Mm = "I" +item.Seq.ToString();
// item.StockName = "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 Source.Data.SourceContext.MSG(item.UpdateStatus, false);
// }
// }
}
catch (Exception err)
{
_return = new Source.Data.SourceContext.MSG(item.UpdateStatus, true);
_return.MsgInformation += "\n " + err.ToString();
}
return(_return);
}
public static Source.Data.SourceContext.MSG Save(Source.Data.Entities.StationTracking item, string Symbol)
{
var _return = new Source.Data.SourceContext.MSG();
try
{
using (var dbContext = new Source.Data.SourceContext())
{
//check the ObjectState property and mark appropriate EntityState
if (item.UpdateStatus == "Added")
{
var items = dbContext.StationTrackings.Where(x => x.Station == item.Station && x.Year == item.Year);
var itemCheck = items.Where(s => s.SessionID == item.SessionID).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.SessionID = Symbol + item.Year.Substring(2, 2) + item.Seq.ToString("00000#");
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 Source.Data.SourceContext.MSG(item.UpdateStatus, false);
}
}
}
catch (Exception err)
{
_return = new Source.Data.SourceContext.MSG(item.UpdateStatus, true);
_return.MsgInformation += "\n " + err.ToString();
}
return(_return);
}
