//============= #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.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); }
public static Source.Data.SourceContext.MSG Save(Source.Data.Entities.Stocks 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.Stocks; var itemCheck = items.Where(s => s.Yy == item.Yy && s.Mm == item.Mm && s.ColorCode == item.ColorCode && s.MaterialCo == item.MaterialCo && s.MaterialType == item.MaterialType && 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.ColorCode = "I" +item.Seq.ToString(); //item.MaterialCo = "I" +item.Seq.ToString(); //item.MaterialType = "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); }