private Voucher PrepareVoucher()
{
List <VoucherPaymentDetails> voucherPaymentDetailsList = new List <VoucherPaymentDetails>();
foreach (DataRow dr in _ClaimPaymentDetails.Rows)
{
VoucherPaymentDetails voucherPaymentDetails = new VoucherPaymentDetails()
{
CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name),
PaymentModeId = Convert.ToInt32(dr["PaymentModeId"].ToString()),
PaymentAmount = Convert.ToDecimal(dr["Amount"].ToString()),
PaymentModeName = dr["PaymentModeName"].ToString(),
Description = dr["PaymentDetails"].ToString()
};
voucherPaymentDetailsList.Add(voucherPaymentDetails);
}
VoucherPayment voucherPayment = new VoucherPayment()
{
VoucherPaymentDetailsList = voucherPaymentDetailsList,
TotalAmount = Convert.ToDecimal(lblTotalApprovedAmount.Text.Trim()),
CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name),
};
Voucher voucher = new Voucher()
{
VoucherPayment = voucherPayment,
CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name)
};
voucher.VoucherJson = PrepareVoucherJson();
return(voucher);
}
public string SelectVoucherDetail(long voucher_id)
{
List <Voucher> voucher = new List <Voucher>();
var orList = Database._PurchaseVoucherSelect(voucher_id, 0);
foreach (var o in orList)
{
Voucher or = new Voucher();
or.ID = o.ID;
or.SupplierID = o.SupplierID.Value;
or.SupplierName = o.SupplierName;
or.RefNo = o.RefNo;
or.RefNoSerial = o.ID.ToString();// o.RefSerial;
try { or.Cash = Database._PurchasedPaymentCashes.Where(x => x.PurchasedVoucherID == voucher_id).ToList <_PurchasedPaymentCash>(); }
catch { }
try { or.Checks = Database._PurchasedPaymentChecks.Where(x => x.PuchasedVoucherID == voucher_id).ToList <_PurchasedPaymentCheck>(); }
catch { }
//or.Payments
List <VoucherPayment> payment = new List <VoucherPayment>();
var invoice_payment = Database._PurchasedPaymentSelectBySupplier(0, voucher_id, 0, 0);
foreach (var p in invoice_payment)
{
VoucherPayment _p = new VoucherPayment();
_p.ID = p.ID;
_p.VoucherID = voucher_id;
_p.PurchaseID = p.PurchasedID.Value;
_p.Description = "Purchased";
_p.RefNo = Database._PurchasedInvoices.SingleOrDefault(x => x.ID == p.PurchasedID.Value).RefNo + Database._PurchasedInvoices.SingleOrDefault(x => x.ID == p.PurchasedID.Value).RefNoSerial;
var salesman_id = Database._PurchasedInvoices.SingleOrDefault(x => x.ID == p.PurchasedID.Value).Salesman;
_p.Salesman = Database._Employees.SingleOrDefault(x => x.ID == salesman_id).EmployeeName;
_p.TotalAmount = Database._PurchasedInvoices.SingleOrDefault(x => x.ID == p.PurchasedID.Value).SubTotal.Value;
_p.CreatedDate = Database._PurchasedInvoices.SingleOrDefault(x => x.ID == p.PurchasedID.Value).CreatedDate.Value;
_p.TotalPayment = p.Amount.Value;
payment.Add(_p);
}
or.Payments = payment;
voucher.Add(or);
}
return(JsonConvert.SerializeObject(voucher, Newtonsoft.Json.Formatting.None));
}
protected void btnGenerateVoucher_Click(object sender, EventArgs e)
{
try
{
if (ValidateGenerateVoucher())
{
Voucher voucher = PrepareVoucher();
Business.ClaimManagement.Voucher objVoucher = new Business.ClaimManagement.Voucher();
Business.ClaimManagement.VoucherPayment objVoucherPayment = new Business.ClaimManagement.VoucherPayment();
Business.ClaimManagement.VoucherPaymentDetailsDetails objVoucherPaymentDetailsDetails = new Business.ClaimManagement.VoucherPaymentDetailsDetails();
int voucherId = objVoucher.Voucher_Save(voucher);
VoucherPayment voucherPayment = voucher.VoucherPayment;
voucherPayment.VoucherId = voucherId;
int voucherPaymentId = objVoucherPayment.VoucherPayment_Save(voucherPayment);
int retValue = 0;
List <VoucherPaymentDetails> voucherPaymentDetailsList = new List <VoucherPaymentDetails>();
voucherPaymentDetailsList = voucher.VoucherPayment.VoucherPaymentDetailsList;
retValue = VoucherPaymentDetails_Save(objVoucherPaymentDetailsDetails, voucherPaymentId, retValue, voucherPaymentDetailsList);
DataTable dtVoucher = objVoucher.Voucher_GetById(voucherId);
if (dtVoucher != null && dtVoucher.AsEnumerable().Any() && retValue == voucherPaymentDetailsList.Count())
{
ClaimApplicationStatusUpdate();
int claimDisbursementId = ClaimDisbursement_Save(voucherId);
ClaimDisbursementDetails_Save(claimDisbursementId);
ClaimApplication_GetAll();
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('VoucherPrint.aspx?no=" + dtVoucher.Rows[0]["VoucherNo"].ToString() + "','mywindow','menubar=1,resizable=1,width=900,height=600');", true);
MessageSuccess.IsSuccess = true;
MessageSuccess.Text = string.Format("Voucher generated successfully. Voucher number is <a target='_blank' href='../ClaimManagement/VoucherPrint.aspx?no={0}'>{0}</a>", dtVoucher.Rows[0]["VoucherNo"].ToString());
MessageSuccess.Show = true;
lblTotalAmountPaying.Text = "0.00";
_ClaimPaymentDetails = null;
LoadClaimPaymentDetails();
}
else
{
Message.IsSuccess = false;
Message.Text = "Voucher generation failed.";
Message.Show = true;
ModalPopupExtender1.Show();
}
ClearPaymentDetailsControls();
_ClaimPaymentDetails.Clear();
LoadClaimPaymentDetails();
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
public void Setup()
{
_validator = new VoucherPaymentValidator();
_validPayment = new VoucherPayment()
{
Amount = 10,
Currency = "EUR",
PaymentDate = DateTime.Now,
PaymentType = PaymentType.Voucher,
Status = PaymentStatus.Pending,
VoucherId = "123456"
};
}
public void SetUp()
{
_invalidVoucherPayment = new VoucherPayment();
_validVoucherPayment = new VoucherPayment
{
Amount = 10,
Currency = "EUR",
PaymentDate = DateTime.Now,
PaymentType = PaymentType.Voucher,
Status = PaymentStatus.Pending,
VoucherId = "123456",
AvailableAmount = 0
};
}
