public void GeneratePurchaseOrderHeaderRequestPayment(int TblPurchaseOrderHeaderRequest, DateTime startingDate, float percentage, float InstallmentCounts, float InstallmentInterval, float amount, string Description, int setting)
{
using (var entity = new WorkFlowManagerDBEntities())
{
//var AmountAfterFirstPayment = amount - (amount * percentage / 100);
//var downPayment = new TblPurchaseOrderHeaderRequestPayment()
//{
// TblPurchaseOrderHeaderRequest = TblPurchaseOrderHeaderRequest,
// Amount = Convert.ToDecimal((amount * percentage / 100)),
// DueDate = startingDate,
// Description = Description,
// Status = 0
//};
//entity.TblPurchaseOrderHeaderRequestPayments.AddObject(downPayment);
for (int i = 0; i < InstallmentCounts; i++)
{
var row = new TblPurchaseOrderHeaderRequestPayment()
{
TblPaymentScheduleSettings = setting,
TblPurchaseOrderHeaderRequest = TblPurchaseOrderHeaderRequest,
Amount = Convert.ToDecimal((amount * percentage / 100) / InstallmentCounts),
DueDate = startingDate.AddDays(InstallmentInterval * (i)),
Description = Description,
Status = 0
};
entity.TblPurchaseOrderHeaderRequestPayments.AddObject(row);
}
entity.SaveChanges();
}
}
private int DeleteTblPurchaseOrderHeaderRequestPayment(TblPurchaseOrderHeaderRequestPayment row, int index)
{
using (var entity = new WorkFlowManagerDBEntities())
{
var query = (from e in entity.TblPurchaseOrderHeaderRequestPayments
where e.Iserial == row.Iserial
select e).SingleOrDefault();
if (query != null)
{
entity.DeleteObject(query);
}
entity.SaveChanges();
}
return(row.Iserial);
}
