public static ObservableCollection <Source.Data.Entities.Stocks> ItemsSource() { try { var dbcontext = new Source.Data.SourceContext(); var list = new ObservableCollection <Source.Data.Entities.Stocks>(dbcontext.Stocks); var Items = (from a in list select new Source.Data.Entities.Stocks { Yy = a.Yy, Mm = a.Mm, ColorCode = a.ColorCode, MaterialCo = a.MaterialCo, MaterialType = a.MaterialType, StockName = a.StockName, QtyOpen = a.QtyOpen, QtyIn = a.QtyIn, QtyOut = a.QtyOut, QtyEnd = a.QtyEnd, IsChecked = false, AutoId = Source.Data.SourceContext.Action.CreateAutoID(), UpdateStatus = "Unchanged" } ); return(new ObservableCollection <Source.Data.Entities.Stocks>(Items)); } catch (Exception err) { return(new ObservableCollection <Source.Data.Entities.Stocks>()); } }
//============= #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.Entities.StationTracking GetBySessionID(string _SesstionID) { try { var dbcontext = new Source.Data.SourceContext(); return(dbcontext.StationTrackings.Where(x => x.SessionID == _SesstionID).First()); } catch (Exception err) { return(new Source.Data.Entities.StationTracking()); } }
public static ObservableCollection <Source.Data.Entities.StationTracking> ItemsSource(string _Station, String SessionSymbol) { try { var dbcontext = new Source.Data.SourceContext(); var list = new ObservableCollection <Source.Data.Entities.StationTracking>(dbcontext.StationTrackings.Where(x => x.Station == _Station && x.SessionID.Substring(0, 2) == SessionSymbol && x.IsReturn != true)); var Items = (from a in list select new Source.Data.Entities.StationTracking { SessionID = a.SessionID, Station = a.Station, Year = a.Year, Seq = a.Seq, ColorCode = a.ColorCode, ColorName = a.ColorName, MaterialCo = a.MaterialCo, MaterialName = a.MaterialName, MaterialType = a.MaterialType, ScaleWeight = a.ScaleWeight, ScaleDate = a.ScaleDate, WinlineCode = a.WinlineCode, ItemName = a.ItemName, SessionParent = a.SessionParent, UserUpdate = a.UserUpdate, UserUpdateTime = a.UserUpdateTime, UserAdded = a.UserAdded, UserAddedTime = a.UserAddedTime, IsChecked = false, AutoId = Source.Data.SourceContext.Action.CreateAutoID(), UpdateStatus = "Unchanged" } ); return(new ObservableCollection <Source.Data.Entities.StationTracking>(Items.OrderByDescending(x => x.ScaleDate))); } catch (Exception err) { return(new ObservableCollection <Source.Data.Entities.StationTracking>()); } }
public static ObservableCollection <Source.Data.Entities.StockCloseEnds> ItemsSource() { try { var dbcontext = new Source.Data.SourceContext(); var listStock = dbcontext.Stocks.ToList().GroupBy(x => new { x.Yy, x.Mm }).Select(x1 => new Source.Data.Entities.StockCloseEnds { Yy = x1.Key.Yy, Mm = x1.Key.Mm, IsLock = false, IsDefault = false, IsChecked = false, AutoId = Source.Data.SourceContext.Action.CreateAutoID(), UpdateStatus = "Added" }).ToList(); var list = dbcontext.StockCloseEnds.ToList(); foreach (var item in listStock) { var itemCheck = list.Where(x => x.Mm == item.Mm && x.Yy == item.Yy); if (itemCheck.Count() > 0) { item.IsLock = itemCheck.First().IsLock == null?false:itemCheck.First().IsLock; item.IsDefault = itemCheck.First().IsDefault == null?false: itemCheck.First().IsDefault; item.UpdateStatus = "Modified"; } } return(new ObservableCollection <Source.Data.Entities.StockCloseEnds>(listStock)); } catch (Exception err) { return(new ObservableCollection <Source.Data.Entities.StockCloseEnds>()); } }
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); }