public static DB.GLX_Header CreateReversalEntry(DB.GLX_Header glx_header, DataContext dataContext) { DB.GLX_Header glx_header_reversal = GLX.GLX_Header.New; glx_header_reversal.JournalTypeId = (byte)GLX.GLX_JournalType.Reversal; glx_header_reversal.Reference = glx_header.Reference; glx_header_reversal.Description = String.Format("Reverse {0}", glx_header.Description); glx_header_reversal.TrackId = glx_header.TrackId; glx_header_reversal.Date = DateTime.Now; //TODO: Fix this //glx_header_reversal.InternalReference = (glx_header.InternalReference ?? "") + ".REV"; // Check if entry period is still open DB.SYS_Period period = SYS.SYS_Period.Load(glx_header.PeriodId, dataContext); if (period.StatusId == (byte)SYS.SYS_Status.Open) { glx_header_reversal.Date = glx_header.Date; glx_header_reversal.PeriodId = period.Id; } // Add reversal lines - they currently default to aging 00 though foreach (DB.GLX_Line line in glx_header.GLX_Line) { DB.GLX_Line glx_line_reversal = GLX.GLX_Line.New; glx_line_reversal.EntityId = line.EntityId; glx_line_reversal.Amount = -line.Amount; glx_line_reversal.CenterId = line.CenterId; glx_line_reversal.CreatedBy = ApplicationDataContext.Instance.LoggedInUser.PersonId; glx_line_reversal.CreatedOn = DateTime.Now; glx_line_reversal.AgingId = line.AgingId; glx_header_reversal.GLX_Line.Add(glx_line_reversal); } return(glx_header_reversal); }
public static DB.ITM_History GetItemCurrentHistory(DB.ITM_Inventory entry, DataContext dataContext) { DB.SYS_Period currentPeriod = SYS.SYS_Period.GetCurrentPeriod(dataContext); DB.ITM_History history = dataContext.EntityInventoryContext.ITM_History.FirstOrDefault(n => n.InventoryId == entry.InventoryId && n.PeriodId == currentPeriod.Id && n.SiteId == ApplicationDataContext.Instance.LoggedInUser.DefaultSiteId); return(history); }
public static System.Data.DataTable GetPayable(DB.SYS_Period period, string filter, DataContext dataContext) { String query = ""; if (BL.ApplicationDataContext.Instance.AccessGranted(BL.SEC.AccessCodes.FIAARE)) { query = "SELECT Type, AccountId, Title, Reference, Description, Date, Balance, Period, Aging, TrackNumber, LineId FROM CDS_GLX.VW_PayableItems WHERE ((Type='OI') OR (Type='BBF' AND PeriodId=" + period.Id + ")) AND " + filter + " ORDER BY Date"; } else { query = "SELECT Type, AccountId, Title, Reference, Description, Date, Balance, Period, Aging, TrackNumber, LineId FROM CDS_GLX.VW_PayableItems WHERE ((Type='OI') OR (Type='BBF' AND PeriodId=" + period.Id + ")) AND " + filter + ") AND SiteId=" + BL.ApplicationDataContext.Instance.LoggedInUser.DefaultSiteId + " ORDER BY Date"; } System.Data.SqlClient.SqlDataAdapter adapter = ApplicationDataContext.Instance.GetAdapter("SELECT Type, AccountId, Title, Reference, Description, Date, Balance, Period, Aging, TrackNumber, LineId FROM CDS_GLX.VW_PayableItems WHERE ((Type='OI') OR (Type='BBF' AND PeriodId=" + period.Id + ")) AND " + filter + " ORDER BY Date"); System.Data.DataTable tblResult = new System.Data.DataTable(); adapter.Fill(tblResult); return(tblResult); }
internal static String Save(DB.SYS_Period entry, DataContext dataContext) { try { if (dataContext.EntitySystemContext.GetEntityState(entry) == EntityState.Detached) { Save(new List <DB.SYS_Period>() { entry }, dataContext); } Validation.ValidateEntity(dataContext.EntitySystemContext, entry); } catch (Validation.EntityValidationException ex) { return(dataContext.PackageValidationException()); } return("Success"); }
public static DB.SYS_Period GetPreviousItem(DB.SYS_Period period, DataContext dataContext) { return(dataContext.EntitySystemContext.SYS_Period.OrderByDescending(o => o.EndDate).FirstOrDefault(n => n.EndDate < period.EndDate && n.EndDate != period.EndDate)); }
public static DB.SYS_Period GetNextItem(DB.SYS_Period period, DataContext dataContext) { return(dataContext.EntitySystemContext.SYS_Period.OrderBy(o => o.EndDate).FirstOrDefault(n => n.EndDate > period.EndDate && n.EndDate != period.EndDate)); }