using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WEBUI.Forms
{
public partial class StockReports : System.Web.UI.Page
{
DataTable lDt;
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
fillgalarycombo();
}
}
private void BindGrid()
{
lDt = new DataTable();
DL.clsDB clsDB = new DL.clsDB();
//lDt = clsDB.GetDataSet("EXEC USP_POS_DateWiseStockCB_ReportAll '" +
// clsGlobals.gSecurityObject.FinCd +
// "','" + clsGlobals.gSecurityObject.CompCd +
// "','" + Convert.ToDateTime(dtpFromDate.Text).ToString("yyyy-MM-dd") +
// "','" + Convert.ToDateTime(dtpToDate.Text).ToString("yyyy-MM-dd") +
// "','" + gallery +
// "' ", CommandType.Text).Tables[0];
lDt = clsDB.GetDataSet("EXEC USP_POS_DateWiseStockCB_ReportAll '" +
'5' +
"','" +"12" +
"','" + Convert.ToDateTime("01/03/2015").ToString("yyyy-MM-dd") +
"','" + Convert.ToDateTime("23/03/2015").ToString("yyyy-MM-dd") +
"','" + "0" +
"' ", CommandType.Text).Tables[0];
GridView1.DataSource = lDt;
GridView1.DataBind();
}
private void fillgalarycombo()
{
DataTable lDt = new DataTable();
DL.clsDB clsDB = new DL.clsDB();
try
{
//lDt = clsDB.GetDataSet("Exec GetUnitName '" +
// Convert.ToString(CommonClasses.clsGlobals.gSecurityObject.CompCd) +
// "'", CommandType.Text).Tables[0];
lDt = clsDB.GetDataSet("Exec GetUnitName '" +
Convert.ToString("12") +
"'", CommandType.Text).Tables[0];
System.Data.DataRow dr;
dr = lDt.NewRow();
dr[0] = "All";
dr[1] = "0";
lDt.Rows.InsertAt(dr, 0);
cmbGallery.DataSource = lDt;
cmbGallery.DataTextField= lDt.Columns[0].ColumnName.ToString();
cmbGallery.DataValueField = lDt.Columns[1].ColumnName.ToString();
cmbGallery.DataBind();
}
catch { }
}
protected void CmbRefresh_Click(object sender, EventArgs e)
{
BindGrid();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
BindGrid();
}
protected void Unnamed_Click(object sender, EventArgs e)
{
DL.clsDB clsDB = new DL.clsDB();
lDt = clsDB.GetDataSet("EXEC USP_POS_DateWiseStockCB_ReportAll '" +
'5' +
"','" + "12" +
"','" + Convert.ToDateTime("01/03/2015").ToString("yyyy-MM-dd") +
"','" + Convert.ToDateTime("23/03/2015").ToString("yyyy-MM-dd") +
"','" + "0" +
"' ", CommandType.Text).Tables[0];
DataView DV = new DataView(lDt);
DV.RowFilter = "Gallery Name = '" + mm.Text.Trim() + "'";
GridView1.DataSource = DV;
GridView1.DataBind();
}
}
}