protected void btnGeneratereport_Click(object sender, EventArgs e)
{
Model.MTransportPayment p = new Model.MTransportPayment();
BTransportpayment pd = new BTransportpayment();
p.Startdate = Convert.ToDateTime(txtStartDate.Text);
p.Enddate = Convert.ToDateTime(txtEndDate.Text);
p.Vehicletype = dpVehicletype.SelectedItem.Text;
DataSet DS = new DataSet();
DS = pd.TransportPaymentDetails(p);
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='6' style='text-align:center'>");
if (Session["CollectionCenterLoggedIn"] != null)
{
sb.Append("<b>" + Session["CollectionCenterLoggedIn"].ToString() + "</b>");
}
else
{
sb.Append("<b>Nanjil Milk Collection Centre, Mulagumoodu, K.K.Dt.</b>");
}
sb.Append("</th colspan='3'>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("TIN:330761667331<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='6' style='text-align:center'>");
sb.Append("<u>Transport Payment-BankList Report</u> <br/>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("PH:248370,248605");
sb.Append("</td>");
//sb.Append("<td></td>");
//sb.Append("<td></td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='3' style='text-align:left'>");
sb.Append("Date : " + DateTime.Now.ToString());
sb.Append("</td>");
sb.Append("<td colspan='3'>");
sb.Append("<b>Vehicle Type:</b> " + dpVehicletype.SelectedItem.Text.ToString());
//+ " " + DS.Tables[1].Rows[0]["VehicleType"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Sr.No</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left' colspan='2'>");
sb.Append("<b>Party Name</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left' colspan='2'>");
sb.Append("<b>IFSC</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left' colspan='2'>");
sb.Append("<b>Acc.No</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Net Amt</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
int count = 0;
double amt = 0.00;
double NetAmt = 0.00;
foreach (DataRow row in DS.Tables[0].Rows)
{
count++;
sb.Append("<td>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left' colspan='2'>");
sb.Append(row["VehicleOwnerName"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:left' colspan='2'>");
sb.Append(row["IFSCCode"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:left' colspan='2'>");
sb.Append(row["AccountNo"].ToString());
sb.Append("</td>");
sb.Append("<td>");
try { amt = Convert.ToDouble(row["Amount"]); }
catch { amt = 0.00; }
NetAmt += amt;
sb.Append(Convert.ToDecimal(amt).ToString("0.00"));
//sb.Append(row["Amount"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='10'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Total :</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
sb.Append("<td colspan='4'>");
sb.Append("</td>");
sb.Append("<td style= 'text-align:left'>");
sb.Append("<b>Net Amount :</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>" + Convert.ToDecimal(NetAmt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
Payment.Text = result;
Session["ctrl"] = pnlPayment;
}
else
{
result = "No Records Found";
Payment.Text = result;
}
uprouteList.Update();
}
protected void btnExporttoexcell_Click1(object sender, EventArgs e)
{
Model.MTransportPayment p = new Model.MTransportPayment();
BTransportpayment pd = new BTransportpayment();
p.flag = "Excel";
p.Vehicletype = dpVehicletype.SelectedItem.Text;
p.Startdate = Convert.ToDateTime(txtStartDate.Text);
p.Enddate = Convert.ToDateTime(txtEndDate.Text);
DataSet DS1 = new DataSet();
DS1 = pd.TransportPaymentDetails(p);
//Create a dummy GridView
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS1))
{
DataSet DS2 = new DataSet();
DS2 = pd.TransportPaymentBankListExcel(p);
GridView GridView1 = new GridView();
GridView1.ShowHeader = true;
GridView1.AllowPaging = false;
GridView1.DataSource = DS2;
GridView1.DataBind();
Response.Clear();
Response.Buffer = true;
string filename = "Demo";
//string filename = DS2.Tables[1].Rows[0]["CenterCode"] + "" + "_" + dpIfscCode.SelectedItem.Text + "" + "_" + DateTime.Now.ToString("dd-MM-yyyy").ToString();
//string filename = DS2.Tables[1].Rows[0]["CenterCode"]+"" + "_" + DS2.Tables[0].Rows[0]["IFSCCode"] + "" + "_" + DateTime.Now.ToString("dd-MM-yyyy").ToString();
Response.AddHeader("content-disposition", "attachment;filename= " + filename + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
//Apply text style to each Row
GridView1.Rows[i].Attributes.Add("class", "textmode");
}
GridView1.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
else
{
result = "No Records to download";
Payment.Text = result;
}
}
protected void btnExportinText_Click(object sender, EventArgs e)
{
Model.MTransportPayment p = new Model.MTransportPayment();
BTransportpayment pd = new BTransportpayment();
p.flag = "Notepad";
p.Vehicletype = dpVehicletype.SelectedItem.Text;
p.Startdate = Convert.ToDateTime(txtStartDate.Text);
p.Enddate = Convert.ToDateTime(txtEndDate.Text);
DataSet DS1 = new DataSet();
DS1 = pd.TransportPaymentDetails(p);
//SqlCommand cmd = new SqlCommand(strQuery);
//DataTable dt = GetData(cmd);
//Create a dummy GridView
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS1))
{
DataSet DS2 = new DataSet();
DS2 = pd.TransportPaymentBankListExcel(p);
GridView GridView1 = new GridView();
GridView1.ShowHeader = false;
GridView1.AllowPaging = false;
GridView1.DataSource = DS2;
GridView1.DataBind();
string txt = string.Empty;
foreach (TableCell cell in GridView1.HeaderRow.Cells)
{
//Add the Header row for Text file.
// txt += cell.Text + "\t\t";
}
//txt += "\r\n";
Response.Clear();
Response.Buffer = true;
string filename = dpVehicletype.SelectedItem.Text;
//DS2.Tables[1].Rows[0]["CenterCode"] + "" + "_" + dpIfscCode.SelectedItem.Text + "" + "_" + DateTime.Now.ToString("dd-MM-yyyy").ToString();
Response.AddHeader("content-disposition", "attachment;filename= " + filename + ".txt");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.text";
foreach (GridViewRow row in GridView1.Rows)
{
foreach (TableCell cell in row.Cells)
{
//Add the Data rows.
txt += cell.Text;
}
//Add new line.
txt += "\r\n";
}
Response.Output.Write(txt.ToString());
Response.End();
}
else
{
result = "No Records to download";
Payment.Text = result;
}
}
