protected void Button1_Click(object sender, EventArgs e)
{
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report/outstandingamount.rdlc");
outstandingamount dsCustomers = GetData();
ReportDataSource datasource = new ReportDataSource("outstandingamount", dsCustomers.Tables[0]);
//ReportParameter rp = new ReportParameter("Startdate", txtfrmdate.Text.ToString());
//ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
//ReportParameter rp1 = new ReportParameter("Enddate", txttodate.Text.ToString());
//ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1 });
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
}
private outstandingamount GetData()
{
string listvalue = "";
foreach (ListItem item in SKT.Items)
{
if (item.Selected)
{
listvalue += item.Value + ",";
}
}
string Productvalue = "";
foreach (ListItem item1 in NPANONNPA.Items)
{
if (item1.Selected)
{
Productvalue += item1.Value + ",";
}
}
string Returntypevalue = "";
foreach (ListItem item2 in Division.Items)
{
if (item2.Selected)
{
Returntypevalue += item2.Value + ",";
}
}
string partytypevalue = "";
foreach (ListItem item3 in partytype.Items)
{
if (item3.Selected)
{
partytypevalue += item3.Value + ",";
}
}
string statusvalue = "";
foreach (ListItem item4 in status.Items)
{
if (item4.Selected)
{
statusvalue += item4.Value + ",";
}
}
string HQvalue = "";
foreach (ListItem item5 in HQ.Items)
{
if (item5.Selected)
{
HQvalue += item5.Value + ",";
}
}
string ZSMvalue = "";
foreach (ListItem item6 in ZSM.Items)
{
if (item6.Selected)
{
ZSMvalue += item6.Value + ",";
}
}
string RSMvalue = "";
foreach (ListItem item7 in RSM.Items)
{
if (item7.Selected)
{
RSMvalue += item7.Value + ",";
}
}
string DSOvalue = "";
foreach (ListItem item8 in DSO.Items)
{
if (item8.Selected)
{
DSOvalue += item8.Value + ",";
}
}
string REFERBYvalue = "";
foreach (ListItem item9 in ReferBy.Items)
{
if (item9.Selected)
{
REFERBYvalue += item9.Value + ",";
}
}
string conString = ConfigurationManager.ConnectionStrings["ConnectionString_master"].ConnectionString;
SqlCommand cmd = new SqlCommand("outstandingautomationafterprocess");
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@startdate", txtfrmdate.Text.Trim());
cmd.Parameters.AddWithValue("@endate", txttodate.Text.Trim());
cmd.Parameters.AddWithValue("@customercode", Customercode.Text.Trim());
cmd.Parameters.AddWithValue("@Billno", BillNo.Text.Trim());
cmd.Parameters.AddWithValue("@SKT", listvalue);
cmd.Parameters.AddWithValue("@HQ", HQvalue);
cmd.Parameters.AddWithValue("@ZSM", ZSMvalue);
cmd.Parameters.AddWithValue("@RSM", RSMvalue);
cmd.Parameters.AddWithValue("@DSO", DSOvalue);
cmd.Parameters.AddWithValue("@REFERBY", REFERBYvalue);
cmd.Parameters.AddWithValue("@NPANONNPA", Productvalue);
cmd.Parameters.AddWithValue("@division", Returntypevalue);
cmd.Parameters.AddWithValue("@partytype", partytypevalue);
cmd.Parameters.AddWithValue("@status", statusvalue);
cmd.Parameters.Add("@message", SqlDbType.VarChar, 300);
cmd.Parameters["@message"].Direction = ParameterDirection.Output;
sda.SelectCommand = cmd;
using (outstandingamount dsCustomers = new outstandingamount())
{
sda.Fill(dsCustomers, "outstandingamount");
lblmsg.Text = cmd.Parameters["@message"].Value.ToString();
return(dsCustomers);
}
}
}
}