internal static string AddEditInvoice(InvoiceVm invoiceVm)
{
string isSaved = "true";
AccountingEntities db = new AccountingEntities();
int invoiceId = invoiceVm.InvoiceId;
byte invFor = invoiceVm.InvoiceType;
// int hbId = invoiceVm.HouseBillId;
InvoiceAP invDb;
if (invoiceId == 0)
{
invDb = new InvoiceAP();
}
else
{
invDb = db.InvoiceAPs.Include("InvoiceDetailAPs").Include("InvoiceTotalAPs")
.Where(x => x.InvoiceId == invoiceId).FirstOrDefault();
//Delete Invoice details and totals .. will insert it again
var invDbTotals = invDb.InvoiceTotalAPs;
var invDbDetails = invDb.InvoiceDetailAPs;
foreach (var item in invDbDetails)
{
invDb.InvoiceDetailAPs.Remove(item);
}
foreach (var item in invDbTotals)
{
invDb.InvoiceTotalAPs.Remove(item);
}
}
Mapper.CreateMap <InvoiceVm, InvoiceAP>()
.ForMember(x => x.InvoiceTotalAPs, y => y.Ignore())
.ForMember(x => x.InvoiceDetailAPs, y => y.Ignore())
.IgnoreAllNonExisting();
Mapper.Map(invoiceVm, invDb);
InvoiceDetailAP invDetail;
Mapper.CreateMap <InvoiceDetailVm, InvoiceDetailAP>().IgnoreAllNonExisting();
foreach (var item in invoiceVm.InvoiceDetails)
{
if (item.IsSelected == true)
{
invDetail = new InvoiceDetailAP();
Mapper.Map(item, invDetail);
invDb.InvoiceDetailAPs.Add(invDetail);
}
}
InvoiceTotalAP invTotalDb;
foreach (var item in invoiceVm.InvoiceTotals)
{
invTotalDb = new InvoiceTotalAP()
{
CurrencyId = item.CurrencyId,
TotalAmount = item.TotalAmount,
CurrencySign = item.CurrencySign
};
invDb.InvoiceTotalAPs.Add(invTotalDb);
}
using (TransactionScope transaction = new TransactionScope())
{
try
{
//Add shipper or consignee to accounting chart
string creditAccountId = "";
if (invFor == 1) //carrier
{
creditAccountId = AccountingChartHelper
.GetAccountIdByPkAndTbName(invoiceVm.CarrierId.Value, "Carrier", "CarrierId");
if (string.IsNullOrEmpty(creditAccountId))
{
creditAccountId = AccountingChartHelper.AddCarrierToChart(invoiceVm.CarrierId.Value);
}
}
else if (invFor == 2) //Contractor
{
creditAccountId = AccountingChartHelper
.GetAccountIdByPkAndTbName(invoiceVm.ContractorId.Value, "Contractor", "ContractorId");
if (string.IsNullOrEmpty(creditAccountId))
{
creditAccountId = AccountingChartHelper.AddContractorToChart(invoiceVm.ContractorId.Value);
}
}
else if (invFor == 3) //Custom Clearance
{
creditAccountId = AccountingChartHelper.GetCCCashDepAccountId(invoiceVm.OperationId);
if (!string.IsNullOrEmpty(creditAccountId))
{
invDb.InvStatusId = 4; //paid with cash deposit
}
else // In this case there was no cash deposit paid .. I added an account to sotre
//any credit amount for custom clearance
{
creditAccountId = ((int)AccountingChartEnum.CustomClearanceSupplier).ToString();
}
}
if (invoiceId == 0)
{
invDb.InvoiceCode = AdminHelper.GeneratePrefixCode(PrefixForEnum.APInvoice, true);
db.InvoiceAPs.Add(invDb);
}
db.SaveChanges();
invoiceVm.InvoiceId = invDb.InvoiceId;
invoiceVm.InvoiceCode = invDb.InvoiceCode;
//Change HB status
if (invoiceId == 0)
{
//Add invoice to accounting transactions table
if (!string.IsNullOrEmpty(creditAccountId))
{
AddAPInvToTransTable(creditAccountId, invoiceVm);
}
//if (invFor == 3) //Custom Clearance
if (invFor == 3) //will link the cash out receipts with same currency to this invoice as it is paid
{
int operId = invoiceVm.OperationId;
int savedInvId = invoiceVm.InvoiceId;
int currId = invoiceVm.InvCurrencyId;
decimal invAmount = invoiceVm.InvoiceTotals.FirstOrDefault().TotalAmount;
//Get cashout receiptIds
var cashoutReceiptIds = db.CashOutReceipts.Include("CashOutReceiptInvs")
.Where(x => x.OperationId == operId && x.CurrencyId == currId)
.ToList();
CashOutReceiptInv cashOutReceiptInv;
decimal prevPaidFromReceipt, receiptAmount, amountToPay = 0;
foreach (var item in cashoutReceiptIds)
{
receiptAmount = item.ReceiptAmount;
//Get what paid before by this receipt
prevPaidFromReceipt = item.CashOutReceiptInvs.Sum(x => x.PaidAmount);
amountToPay = receiptAmount - prevPaidFromReceipt;
if (amountToPay <= 0) //This receipt total amount is used by another invoices
{
continue;
}
if (invAmount <= 0) //This Invoice is total paid
{
break;
}
if (amountToPay > invAmount)
{
amountToPay = invAmount;
}
//Add cash out receipt invoice
cashOutReceiptInv = new CashOutReceiptInv();
cashOutReceiptInv.ReceiptId = item.ReceiptId;
cashOutReceiptInv.InvoiceId = savedInvId;
cashOutReceiptInv.PaidAmount = amountToPay;
db.CashOutReceiptInvs.Add(cashOutReceiptInv);
invAmount = invAmount - amountToPay;
}
db.SaveChanges();
}
// HouseBillHelper.ChangeHBStatus(invDb.HouseBillId, (byte)StatusEnum.InvoiceIssued);
OperationHelper.ChangeOperationStatus(invDb.OperationId, (byte)StatusEnum.InvoiceIssued);
}
transaction.Complete();
}
catch (DbEntityValidationException e)
{
isSaved = "false " + e.Message;
//AdminHelper.LastIdRemoveOne(PrefixForEnum.AccountingInvoice);
}
catch (Exception e)
{
isSaved = "false " + e.Message;
//AdminHelper.LastIdRemoveOne(PrefixForEnum.AccountingInvoice);
}
}
return(isSaved);
}
internal static string AddEditCashReceipt(CashInVm cashInVmObj, out int savedReceiptId, bool addToTrans = true)
{
string isSaved = "true";
AccountingEntities db = new AccountingEntities();
int receiptId = cashInVmObj.ReceiptId;
savedReceiptId = receiptId;
CashOutReceipt cashDbObj;
if (receiptId == 0)
{
cashDbObj = new CashOutReceipt();
}
else
{
cashDbObj = db.CashOutReceipts.Include("CashOutReceiptChecks")
.Include("CashOutReceiptInvs")
.Where(x => x.ReceiptId == receiptId).FirstOrDefault();
//Delete invoice list .. will insert it again
var invList = cashDbObj.CashOutReceiptInvs.ToList();
foreach (var item in invList)
{
cashDbObj.CashOutReceiptInvs.Remove(item);
}
//Delete check list .. will insert it again
var checkList = cashDbObj.CashOutReceiptChecks.ToList();
foreach (var item in checkList)
{
cashDbObj.CashOutReceiptChecks.Remove(item);
}
}
Mapper.CreateMap <CashInVm, CashOutReceipt>()
.ForMember(x => x.CashOutReceiptInvs, y => y.Ignore())
.ForMember(x => x.CashOutReceiptChecks, y => y.Ignore())
.IgnoreAllNonExisting();
Mapper.Map(cashInVmObj, cashDbObj);
CashOutReceiptCheck cashCheckDb;
foreach (var item in cashInVmObj.CashInReceiptChecks)
{
if (!string.IsNullOrEmpty(item.CheckNumber))
{
cashCheckDb = new CashOutReceiptCheck();
Mapper.CreateMap <CashInCheckVm, CashOutReceiptCheck>().IgnoreAllNonExisting();
Mapper.Map(item, cashCheckDb);
cashDbObj.CashOutReceiptChecks.Add(cashCheckDb);
}
}
if (cashInVmObj.OperationId != null) //CC Cash Deposit
{
CashOutCCCashDeposit cashDeposit = new CashOutCCCashDeposit();
cashDeposit.OperationId = cashInVmObj.OperationId.Value;
cashDeposit.ReceiptId = cashInVmObj.ReceiptId;
cashDbObj.CashOutCCCashDeposits.Add(cashDeposit);
}
else if (cashInVmObj.AgentId == null) //Cash Receipt for invoice
{
//Add Receipt invoices
CashOutReceiptInv cashInvDb;
foreach (var item in cashInVmObj.CashInReceiptInvs)
{
if (item.IsSelected)
{
cashInvDb = new CashOutReceiptInv();
Mapper.CreateMap <CashInInvoiceVm, CashOutReceiptInv>().IgnoreAllNonExisting();
item.CashInReceipt = null;
Mapper.Map(item, cashInvDb);
cashDbObj.CashOutReceiptInvs.Add(cashInvDb);
}
}
}
else //Cash Receipt for Agent Note
{
//Add Receipt Agent Notes
CashOutReceiptAgNote cashAgNoteDb;
foreach (var item in cashInVmObj.CashInReceiptInvs)
{
if (item.IsSelected)
{
cashAgNoteDb = new CashOutReceiptAgNote();
Mapper.CreateMap <CashInInvoiceVm, CashOutReceiptAgNote>().IgnoreAllNonExisting();
item.CashInReceipt = null;
Mapper.Map(item, cashAgNoteDb);
cashDbObj.CashOutReceiptAgNotes.Add(cashAgNoteDb);
}
}
}
using (TransactionScope transaction = new TransactionScope())
{
try
{
if (receiptId == 0)
{
cashDbObj.ReceiptCode = AdminHelper.GeneratePrefixCode(PrefixForEnum.CashOut, true);
db.CashOutReceipts.Add(cashDbObj);
}
db.SaveChanges();
cashInVmObj.ReceiptId = cashDbObj.ReceiptId;
cashInVmObj.ReceiptCode = cashDbObj.ReceiptCode;
savedReceiptId = cashInVmObj.ReceiptId;
#region Add To Transaction Table
if (addToTrans)
{
//Add shipper or consignee to accounting chart
string debitAccountId = "";
if (cashInVmObj.OperationId != null) //CC Cash Deposit
{
debitAccountId = AccountingChartHelper.GetCCCashDepAccountId(cashInVmObj.OperationId.Value);
if (string.IsNullOrEmpty(debitAccountId))
{
debitAccountId = AccountingChartHelper.AddCCCashDepositToChart(cashInVmObj.OperationId.Value);
}
}
else if (!string.IsNullOrEmpty(cashInVmObj.PartnerAccountId)) //Partner Drawing
{
debitAccountId = cashInVmObj.PartnerAccountId;
}
else if (cashInVmObj.AgentId == null) //Cash Receipt for invoice
{
if (cashInVmObj.InvoiceType == 1) //carrier
{
debitAccountId = AccountingChartHelper
.GetAccountIdByPkAndTbName(cashInVmObj.CarrierId.Value, "Carrier", "CarrierId");
if (string.IsNullOrEmpty(debitAccountId))
{
debitAccountId = AccountingChartHelper.AddCarrierToChart(cashInVmObj.CarrierId.Value);
}
}
else if (cashInVmObj.InvoiceType == 2) //contractor
{
debitAccountId = AccountingChartHelper
.GetAccountIdByPkAndTbName(cashInVmObj.ContractorId.Value, "Contractor", "ContractorId");
if (string.IsNullOrEmpty(debitAccountId))
{
debitAccountId = AccountingChartHelper.AddContractorToChart(cashInVmObj.ContractorId.Value);
}
}
else if (cashInVmObj.InvoiceType == 3) //custom clearance .. 22/11/2016
{
debitAccountId = ((int)AccountingChartEnum.CustomClearanceSupplier).ToString();
}
}
else //Cash Receipt for Agent Note
{
debitAccountId = AccountingChartHelper.GetAccountIdByPkAndTbName(cashInVmObj.AgentId.Value, "Agent", "AgentId");
if (string.IsNullOrEmpty(debitAccountId))
{
debitAccountId = AccountingChartHelper.AddAgentToChart(cashInVmObj.AgentId.Value, 2); //AgentNoteType = 2 .. Credit Agent
}
}
if (receiptId == 0)
{
//Add invoice to accounting transactions table
AddReceiptToTransTable(debitAccountId, cashInVmObj);
foreach (var item in cashInVmObj.CashInReceiptInvs)
{
if (item.IsSelected)
{
if (item.InvoiceId != 0) //Cash Receipt for invoice
{
//Change Invoice status
if (item.AmountDue == 0)
{
InvoiceHelper.ChangeInvStatus(item.InvoiceId, InvStatusEnum.Paid, true);
}
else if (item.CollectedAmount != 0 && item.AmountDue != 0)
{
InvoiceHelper.ChangeInvStatus(item.InvoiceId, InvStatusEnum.PartiallyPaid, true);
}
}
else //Cash Receipt for Agent Note
{
//Change Agent Note status
if (item.AmountDue == 0)
{
AgentNoteHelper.ChangeAgNoteStatus(item.AgentNoteId, InvStatusEnum.Paid);
}
else if (item.CollectedAmount != 0 && item.AmountDue != 0)
{
AgentNoteHelper.ChangeAgNoteStatus(item.AgentNoteId, InvStatusEnum.PartiallyPaid);
}
}
}
}
}
}
#endregion
transaction.Complete();
}
catch (DbEntityValidationException e)
{
isSaved = "false " + e.Message;
//AdminHelper.LastIdRemoveOne(PrefixForEnum.AccountingInvoice);
}
catch (Exception e)
{
isSaved = "false " + e.Message;
//AdminHelper.LastIdRemoveOne(PrefixForEnum.AccountingInvoice);
}
}
return(isSaved);
}
