internal static String Save(DB.GLX_Tax entry, DataContext dataContext) { try { if (dataContext.EntityAccountingContext.GetEntityState(entry) == EntityState.Detached) { dataContext.EntityAccountingContext.GLX_Tax.Add(entry); } Validation.ValidateEntity(dataContext.EntityAccountingContext, entry); } catch (Validation.EntityValidationException ex) { return(dataContext.PackageValidationException()); } return("Success"); }
public static DB.GLX_Tax GetPreviousItem(DB.GLX_Tax glx_tax, DataContext dataContext) { return(dataContext.EntityAccountingContext.GLX_Tax.OrderByDescending(o => o.Name).Where(n => n.Name.CompareTo(glx_tax.Name) < 0 && n.Name.CompareTo(glx_tax.Name) != 0).FirstOrDefault()); }
public static List <DB.GLX_Header> CreateReceipts(DataRow[] rows, Dictionary <Int64, String> accountsColumns, Dictionary <string, GLX.PaymentAccount> paymentAccounts, DataContext dataContext) { List <DB.GLX_Header> headers = new List <DB.GLX_Header>(); foreach (DataRow row in rows) { // Make a new header entry DB.GLX_Header header = GLX.GLX_Header.New; //GET PERIOD FROM DATE header.PeriodId = SYS.SYS_Period.Load(Convert.ToDateTime(row["colEntryDate"]), dataContext).Id; header.Date = Convert.ToDateTime(row["colEntryDate"]); header.PostedDate = Convert.ToDateTime(row["colEntryDate"]).Date; header.Reference = Convert.ToString(row["colEntryReference"]); header.StatusId = (byte)SYS.SYS_Status.Posted; if (Convert.ToDecimal(row["colTotal"]) >= 0) { header.Description = "DEBTOR PAYMENT RECEIVED"; header.JournalTypeId = (byte)GLX.GLX_JournalType.Receipts; } else { header.Description = "DEBTOR PAYMENT REVERSAL"; header.JournalTypeId = (byte)GLX.GLX_JournalType.Reversal; } if (row["TrackNumber"] != DBNull.Value && Convert.ToInt64(row["TrackNumber"]) != -1) { header.TrackId = Convert.ToInt64(row["TrackNumber"]); } else { header.TrackId = -1; } // Add the lines DB.GLX_Line linedebtor = GLX.GLX_Line.New; linedebtor.EntityId = Convert.ToInt64(row["AccountId"]); header.ReferencePeriodId = header.PeriodId; linedebtor.AgingId = Convert.ToByte(row["colEntryAging"]); linedebtor.Amount = 0; header.GLX_Line.Add(linedebtor); Dictionary <Int64, Decimal> taxAccounts = new Dictionary <Int64, Decimal>(); foreach (var pair in accountsColumns) { GLX.PaymentAccount pa = paymentAccounts[pair.Value]; Decimal val = Convert.ToDecimal(row[pair.Value]); if (val != 0) { DB.GLX_Line line = GLX.GLX_Line.New; header.GLX_Line.Add(line); line.EntityId = pair.Key; line.AgingId = !dataContext.EntityAccountingContext.GLX_Account.Where(n => n.Id.Equals(pair.Key)).Select(n => n.AgingAccount).FirstOrDefault() ? (byte)1 : linedebtor.AgingId; DB.GLX_Tax taxType = dataContext.EntityAccountingContext.GLX_Tax.FirstOrDefault(n => n.Id == pa.TaxId); if (taxType != null && taxType.Percentage != 0) { line.Amount = Math.Round(val / (1 + taxType.Percentage), 2, MidpointRounding.AwayFromZero); taxAccounts.Add(taxType.EntityId.Value, Math.Round(val - line.Amount, 2, MidpointRounding.AwayFromZero)); } else { line.Amount = val; } linedebtor.Amount -= val; // Credit the debtor with the indicated amount } } foreach (var account in taxAccounts.GroupBy(account => account.Key).Select(amount => new { id = amount.Key, amount = amount.Sum(account => account.Value) })) { DB.GLX_Line line = GLX.GLX_Line.New; line.EntityId = account.id; line.AgingId = linedebtor.AgingId; line.Amount = account.amount; header.GLX_Line.Add(line); } headers.Add(header); } return(headers); }