protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var qs = "0";
if (Request.QueryString["NotePadId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["NotePadId"]);
qs = _BOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["NotePadId"]))
{
// string NoteId = Request.QueryString["NotePadId"].ToString();
GetContactNote(Convert.ToInt32(qs));
cmdSubmit.Text = "Update";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindCreditType();
BindBankAccount();
BindDepListMethod();
var qs = "0";
if (Request.QueryString["ReceiptId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["ReceiptId"]);
qs = _BOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["ReceiptId"]))
{
// string receiptid = Request.QueryString["ReceiptId"].ToString();
GetReceiptTypes(Convert.ToInt32(qs));
cmdSubmit.Text = "Update";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindDivisions();
BindClientType();
BindGroup();
BindGroupMaster();
var qs = "0";
if (Request.QueryString["ConsultantId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["ConsultantId"]);
qs = _objBOUtiltiy.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["ConsultantId"]))
{
int ConsultId = Convert.ToInt32(qs);
cmdSubmit.Text = "Update";
GetConsultantDetails(ConsultId);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindType();
BindCategory();
BindVAT();
ddlLandSubCategory.Enabled = false;
var qs = "0";
if (Request.QueryString["ComId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["ComId"]);
qs = _objBOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["ComId"]))
{
int commId = Convert.ToInt32(qs);
btnSubmit.Text = "Update";
GetCommType(commId);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var qs = "0";
if (Request.QueryString["TId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["TId"]);
qs = _objBOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["TId"]))
{
int TId = Convert.ToInt32(qs);
// int TId = Convert.ToInt32(Request.QueryString["TId"]);
btnSubmit.Text = "Update";
GetTicketType(TId);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoopTextboxes(Page.Controls);
BindStatus();
BindServiceType();
BindDivisions();
BindConsultants();
BindBankNames();
BindCommsType();
BindPaymentMethods();
BindAccountTypes();
BindCountry();
BindSupplierInvoice();
BindItemLoadType();
BindNotepadType();
BindMainAccounts();
BindGroupMaster();
var qs = "0";
if (Request.QueryString["SupplierId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["SupplierId"]);
qs = _BOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["SupplierId"]))
{
string supplierId = qs;
// string supplierId = Request.QueryString["SupplierId"].ToString();
GetAirSuppliers(Convert.ToInt32(supplierId));
cmdSubmit.Text = "Update";
}
}
}
private void Queystring()
{
var qs = "0";
if (Request.QueryString["VatId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["VatId"]);
qs = _objBOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["VatId"]))
{
int VatId = Convert.ToInt32(qs);
// int VatId = Convert.ToInt32(Request.QueryString["VatId"]);
btnSubmit.Text = "Update";
GetVatDetails(VatId);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var qs = "0";
if (Request.QueryString["BookDestId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["BookDestId"]);
qs = _objBOUtiltiy.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["BookDestId"]))
{
int DestId = Convert.ToInt32(qs);
GetDestinationsDetails(DestId);
cmdSubmit.Text = "Update";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindCountries();
var qs = "0";
if (Request.QueryString["AirportId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["AirportId"]);
qs = _BOUtilities.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["AirportId"]))
{
int airportId = Convert.ToInt32(qs);
GetAirport(airportId);
cmdSubmit.Text = "Update";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindCountries();
var qs = "0";
if (Request.QueryString["StateId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["StateId"]);
qs = objBOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["StateId"]))
{
int Stateid = Convert.ToInt32(qs);
btnSubmit.Text = "Update";
getStateDetails(Stateid);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindTansactionAction();
var qs = "0";
if (Request.QueryString["CashBookId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["CashBookId"]);
qs = _BOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["CashBookId"]))
{
// int cashBookId = Convert.ToInt32(Request.QueryString["CashBookId"].ToString());
GetCashBook(Convert.ToInt32(qs));
cmdSubmit.Text = "Update";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindContinents();
BindTravelCategory();
var qs = "0";
if (Request.QueryString["Id"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["Id"]);
qs = _objBOUtiltiy.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["Id"]))
{
// int CountryId = Convert.ToInt32(Request.QueryString["Id"]);
GetCountries(Convert.ToInt32(qs));
cmdSubmit.Text = "Update";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGraphics();
BindMainAccounts();
var qs = "0";
if (Request.QueryString["BankAcId"] == null)
{
qs = "0";
}
else
{
string getId = Convert.ToString(Request.QueryString["BankAcId"]);
qs = _objBOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
}
if (!string.IsNullOrEmpty(Request.QueryString["BankAcId"]))
{
int bankAccId = Convert.ToInt32(qs);
btnSubmit.Text = "Update";
GetBankAccDetails(bankAccId);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (Session["UserCompanyId"] == null)
//{
// string script = string.Format("alert('Your session has expired');window.location ='InvoiceList.aspx';");
// ScriptManager.RegisterClientScriptBlock(Page, typeof(System.Web.UI.Page), "redirect", script, true);
// //Response.Redirect("Login.aspx");
//}
// else
// {
try
{
if (!IsPostBack)
{
int PFinvid = 0;
int PFcompanyId = 0;
var qs = "0";
string PFTempuniqCode = "";
if (!string.IsNullOrEmpty(Session["UserCompanyId"].ToString()))
{
PFcompanyId = Convert.ToInt32(Session["UserCompanyId"].ToString());
}
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
string getId = Convert.ToString(Request.QueryString["id"]);
qs = _objBOUtiltiy.Decrypts(HttpUtility.UrlDecode(getId), true);
PFinvid = Convert.ToInt32(qs);
}
DataSet objds = objBALPFInvoice.GetPFServiceFeeMergeValue(PFinvid, PFTempuniqCode);
DataSet objDs = objBALPFInvoice.GetPFPdfDetails(PFinvid, PFcompanyId);
StreamReader reader = new StreamReader(Server.MapPath("~/HtmlTemps/PFPdfInvoice.html"));
string readFile = reader.ReadToEnd();
reader.Close();
StringBuilder sbMainrow = new StringBuilder();
StringBuilder sbLandrow = new StringBuilder();
int PFComapanyAddress = 0;
int PFDocuHeader = 0;
int PFFlight = 0;
int PFLand = 0;
int PFLandOnly = 0;
int PFSF = 0;
int PFGC = 0;
int PFPrintStyleId = 0;
if (objDs.Tables.Count > 0)
{
#region Company Deatils
if (objDs.Tables[5].Rows.Count > 0)
{
foreach (DataRow dtlRow in objDs.Tables[5].Rows)
{
if (PFComapanyAddress == 0)
{
readFile = readFile.Replace("{CompanyName}", dtlRow["CompanyName"].ToString());
readFile = readFile.Replace("{address}", dtlRow["CompanyAddress"].ToString());
readFile = readFile.Replace("{Country}", dtlRow["CountryName"].ToString() + " .");
readFile = readFile.Replace("{State}", dtlRow["StateName"].ToString() + " ,");
readFile = readFile.Replace("{City}", dtlRow["CityName"].ToString() + " ,");
readFile = readFile.Replace("{currency}", dtlRow["currency"].ToString() + " ");
string strImagPath = Server.MapPath("../images/" + dtlRow["comapnylogo"].ToString());
readFile = readFile.Replace("{Image}", "<img style='height:40px;width:250px;' src='" + "http://flv.swdtcpl.com/Logos/" + dtlRow["comapnylogo"].ToString() + "'></img>");
//readFile = readFile.Replace("{Image3}", "<img style='height:50px;width:70px;margin-left:100px;' src='" + "http://demofin.swdtcpl.com/img/" + dtlRow["comapnylogo"].ToString() + "'></img>");
//string strUrl = _objBOUtiltiy.LogoUrl();
//readFile = readFile.Replace("{Image}", "<img src='" + strUrl + "Logos/" + dtlRow["comapnylogo"].ToString() + "'></img>");
//readFile = readFile.Replace("{Image3}", "<img style='height:50px;width:70px;margin-left:100px;' src='" + strUrl + "Logos/" + dtlRow["comapnylogo"].ToString() + "'></img>");
}
PFComapanyAddress = 1;
}
}
if (objDs.Tables[5].Rows.Count == 0)
{
readFile = readFile.Replace("{CompanyName}", " ");
readFile = readFile.Replace("{address}", " ");
readFile = readFile.Replace("{Country}", " ");
readFile = readFile.Replace("{State}", " ");
readFile = readFile.Replace("{City}", " ");
readFile = readFile.Replace("{Image}", " ");
readFile = readFile.Replace("{Image3}", " ");
}
if (objDs.Tables[0].Rows.Count > 0)
{
foreach (DataRow dtlRow in objDs.Tables[0].Rows)
{
if (PFDocuHeader == 0)
{
PFPrintStyleId = Convert.ToInt32(dtlRow["PrintStyleId"].ToString());
readFile = readFile.Replace("{Invoice_No}", dtlRow["PFInvId"].ToString());
readFile = readFile.Replace("{Date}", dtlRow["InvDate"].ToString());
readFile = readFile.Replace("{Consultant}", dtlRow["ConsultantName"].ToString());
readFile = readFile.Replace("{Client1}", dtlRow["ClientName"].ToString());
readFile = readFile.Replace("{Client}", dtlRow["ClientName"].ToString());
readFile = readFile.Replace("{OrderNo}", dtlRow["PFInvOrder"].ToString());
}
PFDocuHeader = 1;
}
}
if (objDs.Tables[0].Rows.Count == 0)
{
readFile = readFile.Replace("{Document_No}", "123456546256");
readFile = readFile.Replace("{Date}", " ");
readFile = readFile.Replace("{Consultant}", " ");
readFile = readFile.Replace("{Client}", " ");
readFile = readFile.Replace("{OrderNo}", " ");
}
#endregion
decimal PFLandClientTotal = 0;
decimal PFFlihgtClientTotal = 0;
decimal PFServiceFeeClientTotal = 0;
decimal PFGeneralChargeClienttotal = 0;
decimal PFSepLandClientTotal = 0;
decimal PFSepLandExclAmt = 0;
decimal PFSepLandVat = 0;
decimal PFFlightExclAmt = 0;
decimal PFLandExclAmt = 0;
decimal PFServiceFeeExclAmt = 0;
decimal PFGeneralChargeExclAmt = 0;
decimal PFFlightVat = 0;
decimal PFLandVat = 0;
decimal PFServiceFeeVat = 0;
decimal PFGeneralChargeVat = 0;
decimal PFAirportTaxes = 0;
#region LandArrangement
if (objDs.Tables[2].Rows.Count > 0)
{
foreach (DataRow dtlRow in objDs.Tables[2].Rows)
{
if (PFPrintStyleId == 0)
{
if (PFLandOnly == 0)
{
sbLandrow.Append("<h3 class='text-center'><strong>Land Invoice Summary</strong></h3>");
sbLandrow.Append("<tr>");
sbLandrow.Append("<td colspan='7' style='background-color:#f5f5f5;border: 1px ridge black;font-weight:bold;padding:3px;color:blue;'>Land Arrangement</td>");
sbLandrow.Append("</tr>");
sbLandrow.Append("<tr>");
sbLandrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Type</td>");
sbLandrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Ser RefNo</td>");
sbLandrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Details</td>");
sbLandrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Excl Amt</td>");
sbLandrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Taxes</td>");
sbLandrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>VAT</td>");
sbLandrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Incl Amt</td>");
sbLandrow.Append("</tr>");
}
}
PFSepLandClientTotal = PFSepLandClientTotal + Convert.ToDecimal(string.IsNullOrEmpty(dtlRow["ClientTotal"].ToString().Trim()) ? ".00" : dtlRow["ClientTotal"].ToString().Trim());
PFSepLandExclAmt = PFSepLandExclAmt + Convert.ToDecimal(string.IsNullOrEmpty(dtlRow["Excl Amt"].ToString().Trim()) ? ".00" : dtlRow["Excl Amt"].ToString().Trim());
PFSepLandVat = PFSepLandVat + Convert.ToDecimal(string.IsNullOrEmpty(dtlRow["VAT"].ToString().Trim()) ? ".00" : dtlRow["VAT"].ToString().Trim());
//LandClientTotal = LandClientTotal + LandClientTotal;
//LandExclAmt = LandExclAmt + LandExclAmt;
//LandVat = LandVat + LandVat;
if (PFPrintStyleId == 0)
{
sbLandrow.Append("<tr>");
sbLandrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["LandArrId"] + "</td>");
sbLandrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["BookRefNo"] + "</td>");
sbLandrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["Details"] + "</td>");
sbLandrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["Excl Amt"] + "</td>");
sbLandrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>0.00</td>");
sbLandrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["VAT"] + "</td>");
sbLandrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["ClientTotal"] + "</td>");
sbLandrow.Append("</tr>");
PFLandOnly = 1;
}
}
//sbMainrow.Append("<tr>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>Land Total</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + LandClientTotal + "</td></tr>");
if (PFPrintStyleId == 0)
{
sbLandrow.Append("<tr>");
sbLandrow.Append("<td colspan='6' style='border: 1px ridge black; font-weight:bold;padding:3px;'>Land Total</td>");
sbLandrow.Append("<td colspan='7' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + PFSepLandClientTotal + "</td></tr>");
}
}
readFile = readFile.Replace("{LandData}", sbLandrow.ToString());
#endregion LandArrangement
#region AirTicket
if (objDs.Tables[1].Rows.Count > 0)
{
foreach (DataRow dtlRow in objDs.Tables[1].Rows)
{
if (PFPrintStyleId == 0)
{
if (PFFlight == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='7' style='background-color:#f5f5f5;border: 1px ridge black;font-weight:bold;padding:3px;color:blue;'>Air Tickets</td>");
sbMainrow.Append("</tr>");
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Prn</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Ticket No</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Passenger/Route/Dep Date</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Excl Amt</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Airport Taxes</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>VAT</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Incl Amt</td>");
sbMainrow.Append("</tr>");
}
}
PFFlihgtClientTotal = PFFlihgtClientTotal + Convert.ToDecimal(dtlRow["AirClientTotal"]);
PFFlightExclAmt = PFFlightExclAmt + Convert.ToDecimal(dtlRow["AirExclusiveFare"]);
PFFlightVat = PFFlightVat + Convert.ToDecimal(dtlRow["AirVatonFare"]);
PFAirportTaxes = PFAirportTaxes + Convert.ToDecimal(dtlRow["AirPortTaxes"]);
if (PFPrintStyleId == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["AirPnr"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["AirTicketNo"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'/>" + dtlRow["Details"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["AirExclusiveFare"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["AirPortTaxes"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["AirVatonFare"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["AirClientTotal"] + "</td>");
sbMainrow.Append("</tr>");
PFFlight = 1;
}
}
//sbMainrow.Append("<tr>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>Airport Taxes</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + AirportTaxes + "</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>0.00</td>");
//sbMainrow.Append("<td colspan='7' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + AirportTaxes + "</td></tr>");
// sbMainrow.Append("<tr>");
// sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>Air Tickets Total(Inclu Airport Taxes)</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
// sbMainrow.Append("<td colspan='7' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + FlihgtClientTotal + "</td></tr>");
if (PFPrintStyleId == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='6' style='border: 1px ridge black; font-weight:bold;padding:3px;'>Air Tickets Total(Inclu Airport Taxes)</td>");
sbMainrow.Append("<td colspan='7' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + PFFlihgtClientTotal + "</td></tr>");
//sbMainrow.Append("</tr>");
}
}
#endregion AirTicket
#region LandArrangement
if (objDs.Tables[2].Rows.Count > 0)
{
foreach (DataRow dtlRow in objDs.Tables[2].Rows)
{
if (PFPrintStyleId == 0)
{
if (PFLand == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='7' style='background-color:#f5f5f5;border: 1px ridge black;font-weight:bold;padding:3px;color:blue;'>Land Arrangement</td>");
sbMainrow.Append("</tr>");
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Type</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Ser RefNo</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Details</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Excl Amt</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Taxes</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>VAT</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Incl Amt</td>");
sbMainrow.Append("</tr>");
}
}
PFLandClientTotal = PFLandClientTotal + Convert.ToDecimal(string.IsNullOrEmpty(dtlRow["ClientTotal"].ToString().Trim()) ? ".00" : dtlRow["ClientTotal"].ToString().Trim());
PFLandExclAmt = PFLandExclAmt + Convert.ToDecimal(string.IsNullOrEmpty(dtlRow["Excl Amt"].ToString().Trim()) ? ".00" : dtlRow["Excl Amt"].ToString().Trim());
PFLandVat = PFLandVat + Convert.ToDecimal(string.IsNullOrEmpty(dtlRow["VAT"].ToString().Trim()) ? ".00" : dtlRow["VAT"].ToString().Trim());
//LandClientTotal = LandClientTotal + LandClientTotal;
//LandExclAmt = LandExclAmt + LandExclAmt;
//LandVat = LandVat + LandVat;
if (PFPrintStyleId == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["LandArrId"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["BookRefNo"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["Details"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["Excl Amt"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>0.00</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["VAT"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["ClientTotal"] + "</td>");
sbMainrow.Append("</tr>");
PFLand = 1;
}
}
//sbMainrow.Append("<tr>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>Land Total</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + LandClientTotal + "</td></tr>");
if (PFPrintStyleId == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='6' style='border: 1px ridge black; font-weight:bold;padding:3px;'>Land Total</td>");
sbMainrow.Append("<td colspan='7' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + PFLandClientTotal + "</td></tr>");
}
}
#endregion LandArrangement
#region ServiceFee
string merge = "";
if (objDs.Tables[3].Rows.Count > 0)
{
foreach (DataRow dtlRow in objDs.Tables[3].Rows)
{
merge = dtlRow["MergeC"].ToString();
if (dtlRow["MergeC"].ToString() == "0")
{
if (PFSF == 0)
{
if (PFPrintStyleId == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='7' style='background-color:#f5f5f5;border: 1px ridge black;font-weight:bold;padding:3px;color:blue;'>Service Fee</td>");
sbMainrow.Append("</tr>");
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Type</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>SourceRef</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Details</td>");
sbMainrow.Append("<td colspan='2' style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;text-align:center'>Excl Amt</td>");
//sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Taxes</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>VAT</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Incl Amt</td>");
sbMainrow.Append("</tr>");
}
}
string Clienttotal = string.IsNullOrEmpty(dtlRow["ClientTotal"].ToString().Trim()) ? ".00" : dtlRow["ClientTotal"].ToString().Trim();
string ExcluAmount = string.IsNullOrEmpty(dtlRow["ExcluAmount"].ToString().Trim()) ? ".00" : dtlRow["ExcluAmount"].ToString().Trim();
string VatAmount = string.IsNullOrEmpty(dtlRow["VatAmount"].ToString().Trim()) ? ".00" : dtlRow["VatAmount"].ToString().Trim();
PFServiceFeeClientTotal = PFServiceFeeClientTotal + Convert.ToDecimal(Clienttotal);
PFServiceFeeExclAmt = PFServiceFeeExclAmt + Convert.ToDecimal(ExcluAmount);
PFServiceFeeVat = PFServiceFeeVat + Convert.ToDecimal(VatAmount);
if (PFPrintStyleId == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["Typ"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["TktNumber"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["Details"] + "</td>");
sbMainrow.Append("<td colspan='2' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["ExcluAmount"] + "</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>0.00</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["VatAmount"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["ClientTotal"] + "</td>");
sbMainrow.Append("</tr>");
PFSF = 1;
}
}
}
// if (merge == "0")
// {
//sbMainrow.Append("<tr>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>Service Fee Total</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + ServiceFeeClientTotal + "</td></tr>");
if (PFPrintStyleId == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='6' style='border: 1px ridge black; font-weight:bold;padding:3px;'>Service Fee Total</td>");
if (PFServiceFeeClientTotal == 0)
{
sbMainrow.Append("<td colspan='7' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'> 0.00 </td></tr>");
}
else
{
sbMainrow.Append("<td colspan='7' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + PFServiceFeeClientTotal + "</td></tr>");
}
}
// }
}
#endregion Service
#region GeneralCharge
if (objDs.Tables[4].Rows.Count > 0)
{
foreach (DataRow dtlRow in objDs.Tables[4].Rows)
{
if (PFPrintStyleId == 0)
{
if (PFGC == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='7' style='background-color:#f5f5f5;border: 1px ridge black;font-weight:bold;padding:3px;color:blue;'>General Charge</td>");
sbMainrow.Append("</tr>");
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Type</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Ser RefNo</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Details</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Excl Amt</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Taxes</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>VAT</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Incl Amt</td>");
sbMainrow.Append("</tr>");
}
}
PFGeneralChargeClienttotal = PFGeneralChargeClienttotal + Convert.ToDecimal(dtlRow["ClientTot"]);
PFGeneralChargeExclAmt = PFGeneralChargeExclAmt + Convert.ToDecimal(dtlRow["ExcluAmt"]);
PFGeneralChargeVat = PFGeneralChargeVat + Convert.ToDecimal(dtlRow["VatAmount"]);
if (PFPrintStyleId == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["Type"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["Ref"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["Details"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["ExcluAmt"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>0.00</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["VatAmount"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["ClientTot"] + "</td>");
sbMainrow.Append("</tr>");
PFGC = 1;
}
}
//sbMainrow.Append("<tr>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>General Charge Total</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + GeneralChargeClienttotal + "</td></tr>");
if (PFPrintStyleId == 0)
{
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='6' style='border: 1px ridge black; font-weight:bold;padding:3px;'>General Charge Total</td>");
sbMainrow.Append("<td colspan='7' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + PFGeneralChargeClienttotal + "</td></tr>");
}
}
#endregion GeneralCharge
decimal TotalInvExclAmt = PFFlightExclAmt + PFLandExclAmt + PFServiceFeeExclAmt + PFGeneralChargeExclAmt;
decimal TotalVat = PFFlightVat + PFLandVat + PFServiceFeeVat + PFGeneralChargeVat;
decimal TotalInclAmount = PFFlihgtClientTotal + PFLandClientTotal + PFServiceFeeClientTotal + PFGeneralChargeClienttotal;
TotalInclAmount = Convert.ToDecimal(_objBOUtiltiy.FormatTwoDecimal(TotalInclAmount.ToString()));
// Invocie Total desing
//sbMainrow.Append("<tr>");
//sbMainrow.Append("<td colspan='7'><br/></td>");
//sbMainrow.Append("</tr>");
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='7' style='background-color:#f5f5f5;border: 1px ridge black;font-weight:bold;padding:3px;color:blue;text-align:center'>Summary<br/></td>");
sbMainrow.Append("</tr>");
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='3' style='border: 1px ridge black; font-weight:bold;padding:3px;color:blue;'>Invoice Total</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + TotalInvExclAmt + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + PFAirportTaxes + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + TotalVat + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + TotalInclAmount + "</td></tr>");
// Balance From you desing
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='6' style='border: 1px ridge black; font-weight:bold;padding:3px;color:blue;'>Total Due</td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
//sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'></td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + TotalInclAmount + "</td></tr>");
}
readFile = readFile.Replace("{MainRows}", sbMainrow.ToString());
string StrContent = readFile;
//GenerateHTML_TO_PDF(StrContent, true, "", false);
string strFileName = "PFInvoice" + " " + PFinvid;
string strFileSavePath = Server.MapPath("../PdfDocuments/" + strFileName + ".pdf");
GenerateHTML_TO_PDF(StrContent, true, strFileSavePath, true);
}
}
catch (Exception ex)
{
lblMsg.Text = _objBOUtiltiy.ShowMessage("danger", "Danger", ex.Message);
ExceptionLogging.SendExcepToDB(ex);
}
// }
}
private void Receipt_Pdf()
{
int companyId = 0; int invid = 0; var qs = "0";
if (HttpContext.Current.Session["UserCompanyId"] != null)
{
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
string getId = Convert.ToString(Request.QueryString["id"]);
qs = _BOUtility.Decrypts(HttpUtility.UrlDecode(getId), true);
invid = Convert.ToInt32(qs);
}
if (!string.IsNullOrEmpty(Session["UserCompanyId"].ToString()))
{
companyId = Convert.ToInt32(Session["UserCompanyId"].ToString());
}
DataSet objDs = _objBALTransactions.Get_PrintReceipt(Convert.ToInt32(invid), companyId);
if (objDs.Tables.Count > 0)
{
StreamReader reader = new StreamReader(Server.MapPath("~/HtmlTemps/ReceiptPdf.html"));
string readFile = reader.ReadToEnd();
reader.Close();
int header = 0;
StringBuilder sbMainrow = new StringBuilder();
int ComapanyAddress = 0;
int DocuHeader = 0;
string currency = "";
string companyname = "";
string address = "";
string country = ""; string state = ""; string city = "";
int PrintStyleId = 0;
#region Company Deatils
if (objDs.Tables[0].Rows.Count > 0)
{
foreach (DataRow dtlRow in objDs.Tables[0].Rows)
{
if (ComapanyAddress == 0)
{
readFile = readFile.Replace("{CompanyName}", dtlRow["CompanyName"].ToString());
readFile = readFile.Replace("{address}", dtlRow["CompanyAddress"].ToString());
readFile = readFile.Replace("{Country}", dtlRow["CountryName"].ToString() + " .");
readFile = readFile.Replace("{State}", dtlRow["StateName"].ToString() + " ,");
readFile = readFile.Replace("{City}", dtlRow["CityName"].ToString() + " ,");
readFile = readFile.Replace("{currency}", dtlRow["currency"].ToString() + " ");
string strImagPath = Server.MapPath("../images/" + dtlRow["comapnylogo"].ToString());
readFile = readFile.Replace("{Image}", "<img style='height:40px;width:250px;' src='" + "http://flv.swdtcpl.com/Logos/" + dtlRow["comapnylogo"].ToString() + "'></img>");
//readFile = readFile.Replace("{Image3}", "<img style='height:50px;width:70px;margin-left:100px;' src='" + "http://demofin.swdtcpl.com/img/" + dtlRow["comapnylogo"].ToString() + "'></img>");
companyname = dtlRow["CompanyName"].ToString();
address = dtlRow["CompanyAddress"].ToString();
country = dtlRow["CountryName"].ToString();
state = dtlRow["StateName"].ToString();
city = dtlRow["CityName"].ToString();
currency = dtlRow["currency"].ToString();
//string strUrl = _objBOUtiltiy.LogoUrl();
//readFile = readFile.Replace("{Image}", "<img src='" + strUrl + "Logos/" + dtlRow["comapnylogo"].ToString() + "'></img>");
//readFile = readFile.Replace("{Image3}", "<img style='height:50px;width:70px;margin-left:100px;' src='" + strUrl + "Logos/" + dtlRow["comapnylogo"].ToString() + "'></img>");
}
ComapanyAddress = 1;
}
}
if (objDs.Tables[0].Rows.Count == 0)
{
readFile = readFile.Replace("{CompanyName}", " ");
readFile = readFile.Replace("{address}", " ");
readFile = readFile.Replace("{Country}", " ");
readFile = readFile.Replace("{State}", " ");
readFile = readFile.Replace("{City}", " ");
readFile = readFile.Replace("{Image}", " ");
readFile = readFile.Replace("{Image3}", " ");
}
if (objDs.Tables[1].Rows.Count > 0)
{
foreach (DataRow dtlRow in objDs.Tables[1].Rows)
{
if (DocuHeader == 0)
{
PrintStyleId = Convert.ToInt32(dtlRow["PrintStyleId"].ToString());
readFile = readFile.Replace("{Invoice_No}", dtlRow["PaymentSourceRef"].ToString());
readFile = readFile.Replace("{Date}", dtlRow["InvDate"].ToString());
readFile = readFile.Replace("{Consultant}", dtlRow["ConsultantName"].ToString());
if (dtlRow["ClientPostalAddress"].ToString() != "")
{
readFile = readFile.Replace("{clientAddress}", "Address :" + dtlRow["ClientPostalAddress"].ToString());
}
else
{
readFile = readFile.Replace("{clientAddress}", " ");
}
if (dtlRow["ClientVatRegNo"].ToString() != "")
{
readFile = readFile.Replace("{clientvatNo}", dtlRow["ClientVatRegNo"].ToString());
}
else
{
readFile = readFile.Replace("{clientvatNo}", " ");
}
readFile = readFile.Replace("{Client1}", dtlRow["ClientName"].ToString());
readFile = readFile.Replace("{Client}", dtlRow["ClientName"].ToString());
readFile = readFile.Replace("{OrderNo}", dtlRow["OrderNo"].ToString());
}
DocuHeader = 1;
}
}
if (objDs.Tables[1].Rows.Count == 0)
{
readFile = readFile.Replace("{Document_No}", "");
readFile = readFile.Replace("{Date}", " ");
readFile = readFile.Replace("{Consultant}", " ");
readFile = readFile.Replace("{clientAddress}", " ");
readFile = readFile.Replace("{Client}", " ");
readFile = readFile.Replace("{OrderNo}", " ");
readFile = readFile.Replace("{clientvatNo}", " ");
}
#endregion
if (objDs.Tables[2].Rows.Count > 0)
{
decimal invTotal = 0;
decimal allocate = 0;
decimal invNet = 0;
foreach (DataRow dtlRow in objDs.Tables[2].Rows)
{
invTotal = invNet;
if (header == 0)
{
// sbMainrow.Append("<table>");
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='7' style='background-color:#f5f5f5;border: 1px ridge black;font-weight:bold;padding:3px;color:blue;'>Invoice Details</td>");
sbMainrow.Append("</tr>");
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Invoice Number</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Client Name</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Invoice Total</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Receipt Amount</td>");
sbMainrow.Append("<td style='font-weight:bold;border: 1px ridge black;padding: 5px;background-color: white;border-bottom: 1px ridge black;border-radius:5px;'>Net Balance</td>");
sbMainrow.Append("</tr>");
invTotal = Convert.ToDecimal(dtlRow["InvoiceTotal"]);
header = 1;
}
sbMainrow.Append("<tr>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["InvId"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;'>" + dtlRow["ClientName"] + "</td>");
allocate = Convert.ToDecimal(dtlRow["AllocatedAmount"]);
invNet = invTotal - allocate;
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'/>" + invTotal + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["AllocatedAmount"] + "</td>");
sbMainrow.Append("<td style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + invNet + "</td>");
sbMainrow.Append("</tr>");
sbMainrow.Append("<tr>");
sbMainrow.Append("<td colspan='4' style='border: 1px ridge black; font-weight:bold;padding:3px;color:blue;'>Mode Of Payment</td>");
sbMainrow.Append("<td colspan='4' style='border: 1px ridge black; font-weight:bold;padding:3px;text-align:right'>" + dtlRow["RecDescription"] + "</td></tr>");
// sbMainrow.Append("</table>");
}
}
readFile = readFile.Replace("{MainRows}", sbMainrow.ToString());
string StrContent = readFile;
GenerateHTML_TO_PDF(StrContent, true, "", false);
//GenerateHTML_TO_PDF(StrContent, true, "", false);
}
}
else
{
Response.Redirect("../Login.aspx");
}
}
