//============= #region Delete public static SourceContext.MSG Delete(IEnumerable <Entities.SSBCCompoundTrackings> items) { var _return = new SourceContext.MSG(); try { var dbContext = new SourceContext(); foreach (var item in items) { var itemDel = dbContext.SSBCCompoundTrackings.Where(s => s.TrackNo == item.TrackNo).FirstOrDefault(); dbContext.Entry(itemDel).State = System.Data.Entity.EntityState.Deleted; } ; dbContext.SaveChanges(); _return = new SourceContext.MSG("Deleted", false); } catch (Exception err) { _return = new SourceContext.MSG("Deleted", true); _return.MsgInformation += "\n " + err.ToString(); } return(_return); }
public static SourceContext.MSG Save(Entities.SSBCCompoundTrackings item, string Symbol) { var _return = new SourceContext.MSG(); try { using (var dbContext = new SourceContext()) { //check the ObjectState property and mark appropriate EntityState if (item.UpdateStatus == "Added") { var items = dbContext.SSBCCompoundTrackings.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 = "CP" + 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.ParentTrackNo).IsModified = false; dbContext.Entry(item).Property(x => x.MixTrackNo).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 SourceContext.MSG(item.UpdateStatus, false); } } } catch (Exception err) { _return = new SourceContext.MSG(item.UpdateStatus, true); _return.MsgInformation += "\n " + err.ToString(); } return(_return); }