internal static String Save(DB.GLX_Recon entry, DataContext dataContext) { try { if (dataContext.EntityAccountingContext.GetEntityState(entry) == EntityState.Detached) { dataContext.EntityAccountingContext.GLX_Recon.Add(entry); } Validation.ValidateEntity(dataContext.EntityAccountingContext, entry); } catch (Validation.EntityValidationException ex) { return(dataContext.PackageValidationException()); } return("Success"); }
//public static DB.GLX_Recon GetNextItem(DB.GLX_Recon glx_recon, DataContext dataContext) //{ // return dataContext.EntitySystemContext.SYS_Recon.OrderBy(o => o.StartDate).Where(n => n.StartDate > glx_recon.StartDate && n.StartDate != glx_recon.StartDate).FirstOrDefault(); //} //public static DB.GLX_Recon GetPreviousItem(DB.GLX_Recon glx_recon, DataContext dataContext) //{ // return dataContext.EntitySystemContext.SYS_Recon.OrderByDescending(o => o.StartDate).Where(n => n.StartDate > glx_recon.StartDate && n.StartDate != glx_recon.StartDate).FirstOrDefault(); //} public static void RejectRecon(DB.GLX_Recon glx_recon, DataContext dataContext) { glx_recon.StatusId = (byte)SYS.SYS_Status.Rejected; dataContext.EntityAccountingContext.ExecuteSqlCommand(string.Format("UPDATE [CDS_GLX].[GLX_Line] set ReconId = null WHERE ReconId = {0}", glx_recon.Id)); }