private void GetHtmlDetails()
{
this.Page.Title = "Invoice " + lblInvoiceDate.Text;
SimsInvoice objsimsinvoice = new SimsInvoice();
objsimsinvoice.UserName = Membership.GetUser().UserName;
CheckBox chkServicetaxoption = new CheckBox();
chkServicetaxoption.ID = "chkServicetaxoption";
chkServicetaxoption.Checked = true;
objsimsinvoice.ProductDivisionId = 18;
string[] rawUrl = { };
if (Session["quryParam"] != null)
{
rawUrl = Convert.ToString(Session["quryParam"]).Split('&');
if (!string.IsNullOrEmpty(rawUrl[0].Split('=')[1]))
{
objsimsinvoice.YearId = Convert.ToInt32(rawUrl[0].Split('=')[1]);
}
else
{
objsimsinvoice.YearId = 2014;
}
if (!string.IsNullOrEmpty(rawUrl[1].Split('=')[1]))
{
objsimsinvoice.MonthId = Convert.ToInt32(rawUrl[1].Split('=')[1]);
}
else
{
objsimsinvoice.MonthId = 11;
}
if (!string.IsNullOrEmpty(rawUrl[2].Split('=')[1]))
{
if (!(rawUrl[2].Split('=')[1].Split('|')[0].ToString() == ""))
{
objsimsinvoice.AscId = Convert.ToInt32(rawUrl[2].Split('=')[1].Split('|')[0].Trim());
}
else
{
objsimsinvoice.AscId = 0;
}
if (!(rawUrl[2].Split('=')[1].Split('|')[1].ToString() == ""))
{
objsimsinvoice.RegionId = Convert.ToInt32(rawUrl[2].Split('=')[1].Split('|')[1].Trim());
}
else
{
objsimsinvoice.RegionId = 0;
}
if (!(rawUrl[2].Split('=')[1].Split('|')[1].ToString() == ""))
{
objsimsinvoice.BranchId = Convert.ToInt32(rawUrl[2].Split('=')[1].Split('|')[2].Trim());
}
else
{
objsimsinvoice.BranchId = 0;
}
}
if (objsimsinvoice.AscId == 0)
{
spnSoldto.Visible = false;
}
if (string.IsNullOrEmpty(rawUrl[4].Split('=')[1]))
{
chkServicetaxoption.Checked = true;
}
else
{
chkServicetaxoption.Checked = rawUrl[4].Split('=')[1].Equals("0") ? false : true;
}
if (!string.IsNullOrEmpty(rawUrl[3].Split('=')[1]))
{
if (!string.IsNullOrEmpty(rawUrl[3].Split('=')[1].Split('|')[0]))
{
lblRegion.Text = Convert.ToString(rawUrl[3].Split('=')[1].Split('|')[0]);
}
else
{
lblRegion.Text = "";
}
if (!string.IsNullOrEmpty(rawUrl[3].Split('=')[1].Split('|')[1]))
{
lblBranch.Text = Convert.ToString(rawUrl[3].Split('=')[1].Split('|')[1]);
}
else
{
lblBranch.Text = "";
}
}
else
{
trRB.Visible = false;
}
if (objsimsinvoice.YearId > 2015)
{
imglogo.ImageUrl = "../../images/CromptonLogo.jpg";
}
//Set Year month
lblYear.Text = Convert.ToString(objsimsinvoice.YearId);
lblmonth.Text = objsimsinvoice.MonthId != 0 ? CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(objsimsinvoice.MonthId) : "";
DataSet dsInvoice = objsimsinvoice.GetInvoiceDetails();
if (dsInvoice != null)
{
if (dsInvoice.Tables[1].Rows.Count > 0)
{
lblCustomerName.Text = "<b>" + dsInvoice.Tables[1].Rows[0]["Sc_Name"].ToString() + "</b>";
lblAscAddress.Text = dsInvoice.Tables[1].Rows[0]["Addres"].ToString();
}
if (dsInvoice.Tables[2].Rows.Count > 0)
{
lblInvoiceNo.Text = dsInvoice.Tables[2].Rows[0]["InvoiceNo"].ToString();
lblInvoiceDate.Text = dsInvoice.Tables[2].Rows[0]["InvoiceDt"].ToString();
}
#region Update invoice details
if (!lblInvoiceNo.Text.Contains("(Re Print)"))
{
objsimsinvoice.InvoiceBillNo = lblInvoiceNo.Text;
objsimsinvoice.UpdateInvoicePrintStatus();
}
#endregion
if (dsInvoice.Tables[0].Rows.Count > 0)
{
double taxableAmt = Math.Round(Convert.ToDouble(dsInvoice.Tables[0].Compute("Sum(TaxableAmt)", "")), 2);
foreach (DataRow dr in dsInvoice.Tables[0].Rows)
{
if (dr["ActivityParameter_SNo"].ToString().Equals("0"))
{
lblQuanityfd.Text = dr["Quantity"].ToString();
lblfdUnitPrice.Text = dr["UnitPrice"].ToString();
lblfdamount.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("953"))
{
lbllcopquantity1.Text = dr["Quantity"].ToString();
lbllcopunitprice1.Text = dr["UnitPrice"].ToString();
lbllcopamount1.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("961"))
{
lbllcopquantity2.Text = dr["Quantity"].ToString();
lbllcopunitprice2.Text = dr["UnitPrice"].ToString();
lbllcopamount2.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("952"))
{
lbllcopgyquantity1.Text = dr["Quantity"].ToString();
lbllcopgyunitprice1.Text = dr["UnitPrice"].ToString();
lbllcopgyamount1.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("960"))
{
lbllcopgyquantity2.Text = dr["Quantity"].ToString();
lbllcopgyunitprice2.Text = dr["UnitPrice"].ToString();
lbllcopgyamount2.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("957"))
{
lblcoquantity1.Text = dr["Quantity"].ToString();
lblcounitprice1.Text = dr["UnitPrice"].ToString();
lblcoamount1.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("958"))
{
lblcoquantity2.Text = dr["Quantity"].ToString();
lblcounitprice2.Text = dr["UnitPrice"].ToString();
lblcoamount2.Text = dr["Amount"].ToString();
}
///
if (dr["ActivityParameter_SNo"].ToString().Equals("954"))
{
lblcoquantity3.Text = dr["Quantity"].ToString();
lblcounitprice3.Text = dr["UnitPrice"].ToString();
lblcoamount3.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("955"))
{
lblcoquantity4.Text = dr["Quantity"].ToString();
lblcounitprice4.Text = dr["UnitPrice"].ToString();
lblcoamount4.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("956"))
{
lblcoquantity5.Text = dr["Quantity"].ToString();
lblcounitprice5.Text = dr["UnitPrice"].ToString();
lblcoamount5.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("959"))
{
lblFoodProcessorQuantity.Text = dr["Quantity"].ToString();
lblFoodProcessorUnitPrice.Text = dr["UnitPrice"].ToString();
lblFoodProcessorAmount.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("964"))
{
lbllocalforoutstationwaterqty.Text = dr["Quantity"].ToString();
lbllocalforoutstationwaterUnitPrice.Text = dr["UnitPrice"].ToString();
lbllocalforoutstationwaterAmount.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("965"))
{
lbllocalforoutstationexptwaterqty.Text = dr["Quantity"].ToString();
lbllocalforoutstationexptwaterUnitPrice.Text = dr["UnitPrice"].ToString();
lbllocalforoutstationexptwaterAmount.Text = dr["Amount"].ToString();
}
}
double totalPrice = Convert.ToDouble(lblfdamount.Text) + Convert.ToDouble(lbllcopamount1.Text) +
Convert.ToDouble(lbllcopamount2.Text) + Convert.ToDouble(lbllcopgyamount1.Text) +
Convert.ToDouble(lbllcopgyamount2.Text) + Convert.ToDouble(lblcoamount1.Text) +
Convert.ToDouble(lblcoamount2.Text) + Convert.ToDouble(lblcoamount3.Text) +
Convert.ToDouble(lblcoamount4.Text) + Convert.ToDouble(lblcoamount5.Text) +
Convert.ToDouble(lbllocalforoutstationwaterAmount.Text) + Convert.ToDouble(lbllocalforoutstationexptwaterAmount.Text) +
Convert.ToDouble(lblFoodProcessorAmount.Text);
lblTotalAmount.Text = totalPrice.ToString("F");
lblTax.Text = taxableAmt.ToString("F"); //Convert.ToString(Math.Round((totalPrice * 12.35) / 100, 2));
if (chkServicetaxoption.Checked)
{
lblServiceChargesBracks.Text = "(+) ";
lblTAmount.Text = (totalPrice + taxableAmt).ToString("F"); //(Math.Round(totalPrice + ((totalPrice * 12.35) / 100), 2)).ToString("F");
}
else
{
trTaxDetails.Visible = false;
TrServicetaxSummary.Visible = false;
lblTAmount.Text = totalPrice.ToString("F");
}
tblInvoiceDtls.Visible = true;
tblInvoiceAscdetails.Visible = true;
tblEmptyMessage.Visible = false;
SummaryData();
if (Convert.ToInt32(objsimsinvoice.YearId) == 2015 && Convert.ToInt32(objsimsinvoice.MonthId) == 12)
{
lblServicetax.Text = "Service Tax (14.00 % from June 2015)<br/>Swach Bharat Cess (0.50 % from November 2015)";
}
else if (Convert.ToInt32(objsimsinvoice.YearId) > 2015)
{
lblServicetax.Text = "Service Tax (14.00 % from June 2015)<br/>Swach Bharat Cess (0.50 % from November 2015)";
}
else
{
lblServicetax.Text = "Service Tax (14.00 % from June 2015)";
}
}
}
chkServicetaxoption.Enabled = false;
}
else
{
Response.Write("<b style='color:red;' align='center'>Session is expired for Invoice. Please try again</b>");
}
}
