protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PopulateSearchDropdowns();
//applyrole();
//generate report
FinalProductStock_Search repParamSearch = new FinalProductStock_Search();
ReportViewer1.Visible = false;
//GenerateRDLCReport(repParamSearch);
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
FinalProductStock_Search repParamSearch = new FinalProductStock_Search();
GenerateRDLCReport(repParamSearch);
string FromDate_StockDate = Request.Form["_dtFromDate_StockDate"];
lbItemName.SelectedIndex = -1;
lbCompany.SelectedIndex = -1;
lbGodownName.SelectedIndex = -1;
lbStockGroup.SelectedIndex = -1;
//--- Set Current Date in Date Fileds Input Box
lblmsg.Text = "";
}
private void GenerateRDLCReport(FinalProductStock_Search repParamSearch)
{
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/rdlcs/Report_FinalProductStock.rdlc");
DataSet dt = (new Report_DL()).GetReportData_FinalProductStock(repParamSearch);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource()
{
Name = "dsFinalProductStock",
Value = dt.Tables[0]
});
ReportViewer1.LocalReport.Refresh();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
FinalProductStock_Search repParamSearch = new FinalProductStock_Search();
//--- Company:: Multi Select List Box Values --
string strCompany = string.Empty;
foreach (ListItem item in lbCompany.Items)
{
if (item.Selected)
{
strCompany += "'" + item.Text + "'";
strCompany += ",";
}
}
if (lbCompany.SelectedIndex != -1)
{
repParamSearch.Company = strCompany.Remove(strCompany.Length - 1, 1);// Remove last ,lbCompany.SelectedItem.Text;
}
//--- ItemName:: Multi Select List Box Values ItemName--
string strItemName = string.Empty;
foreach (ListItem item in lbItemName.Items)
{
if (item.Selected)
{
strItemName += "'" + item.Text + "'";
strItemName += ",";
}
}
if (lbItemName.SelectedIndex != -1)
{
repParamSearch.ItemName = strItemName.Remove(strItemName.Length - 1, 1);// Remove last , lbItemName.SelectedItem.Text;
}
//--- GodownName:: Multi Select List Box Values ItemName--
string strGodownName = string.Empty;
foreach (ListItem item in lbGodownName.Items)
{
if (item.Selected)
{
strGodownName += "'" + item.Text + "'";
strGodownName += ",";
}
}
if (lbGodownName.SelectedIndex != -1)
{
repParamSearch.GodownName = strGodownName.Remove(strGodownName.Length - 1, 1);// lbGodownName.SelectedItem.Text;
}
//--- StockGroup:: Multi Select List Box Values ItemName--
string strStockGroup = string.Empty;
foreach (ListItem item in lbStockGroup.Items)
{
if (item.Selected)
{
strStockGroup += "'" + item.Text + "'";
strStockGroup += ",";
}
}
if (lbStockGroup.SelectedIndex != -1)
{
repParamSearch.StockGroup = strStockGroup.Remove(strStockGroup.Length - 1, 1);// lbStockGroup.SelectedItem.Text;
}
repParamSearch.StartDate_StockDate = Page.Request.Form["_dtFromDate_StockDate"].ToString();
repParamSearch.EndDate_StockDate = Page.Request.Form["_dtToDate_StockDate"].ToString();
bool blncontinue = true;
if (blncontinue)
{
GenerateRDLCReport(repParamSearch);
}
}
public DataSet GetReportData_FinalProductStock(FinalProductStock_Search repParamSearch)
{
LeadTime_Report_List lstLeadTimeReport = new LeadTime_Report_List();
Common.OpenConnection();
String strSQL = "";
strSQL += "SELECT Top(1000) sd.CompanyID, sd.StockDate, sd.StockItemName, sd.GodownName, sd.BatchName, sd.Quantity, sd.UOM, sd.Rate, sd.Amount * -1 AS amount, SI.StockGroup ";
strSQL += "FROM dbo.TD_Txn_StockDetails AS sd ";
strSQL += "INNER JOIN dbo.TD_Mst_StockItem AS SI ON sd.CompanyID = SI.CompanyID AND sd.StockItemName = SI.StockItemName ";
string WhSQL = "";
string strconcat = "";
if (repParamSearch.Company != null && repParamSearch.Company != "" && repParamSearch.Company != "select")
{
WhSQL = WhSQL + strconcat + " sd.CompanyID In (" + repParamSearch.Company + ")";
strconcat = " and ";
}
if (repParamSearch.StockGroup != null && repParamSearch.StockGroup != "" && repParamSearch.StockGroup != "select")
{
WhSQL = WhSQL + strconcat + " SI.StockGroup In (" + repParamSearch.StockGroup + ")";
strconcat = " and ";
}
if (repParamSearch.GodownName != null && repParamSearch.GodownName != "" && repParamSearch.GodownName != "select")
{
WhSQL = WhSQL + strconcat + " sd.GodownName In (" + repParamSearch.GodownName + ")";
strconcat = " and ";
}
if (repParamSearch.StartDate_StockDate != null && repParamSearch.StartDate_StockDate != "")
{
WhSQL = WhSQL + strconcat + " sd.StockDate>='" + repParamSearch.StartDate_StockDate + "'";
strconcat = " and ";
}
if (repParamSearch.EndDate_StockDate != null && repParamSearch.EndDate_StockDate != "")
{
WhSQL = WhSQL + strconcat + " sd.StockDate<='" + repParamSearch.EndDate_StockDate + "'";
strconcat = " and ";
}
if (repParamSearch.ItemName != null && repParamSearch.ItemName != "" && repParamSearch.ItemName != "select")
{
WhSQL = WhSQL + strconcat + " sd.StockItemName In (" + repParamSearch.ItemName + ")";
strconcat = " and ";
}
if (WhSQL != null && WhSQL != "")
{
strSQL = strSQL + " where " + WhSQL;
}
strSQL += " Order by CompanyID, StockDate, StockGroup, GodownName";
SqlCommand cmd = new SqlCommand(strSQL, Common.conn);
DataSet dsLeadTime = new DataSet();
using (SqlDataAdapter sda = new SqlDataAdapter())
{
sda.SelectCommand = cmd;
sda.Fill(dsLeadTime, "rpt_LeadTime");
}
return(dsLeadTime);
}
