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);
}
