protected void bind()
{
if (ddlCategory.SelectedIndex == 0)
{
GivMon.Visible = false;
btnSubmit.Visible = false;
return;
}
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
SqlDataAdapter adt = new SqlDataAdapter("select * from OrderDetails where categoryid='" + ddlCategory.SelectedValue.ToString() + "'", con);
DataSet ds = new DataSet();
adt.Fill(ds, "table");
string str = null;
if (ddlCategory.SelectedItem.Text == "All")
{
str = "SELECT CategoryMaster.CategoryName,ProductRepurchase.ProductCode,ProductRepurchase.ProductName,dbo.GetStock(ProductRepurchase.ProductID,'Admin') as Stock,ProductRepurchase.BV, ProductRepurchase.SalesAmount As MRP,0 AS Qty,0 as sAmt, ProductRepurchase.ProductID FROM ProductRepurchase INNER JOIN CategoryMaster ON ProductRepurchase.CategoryID = CategoryMaster.CategoryID where ProductRepurchase.status=0 and dbo.GetStock(ProductRepurchase.ProductID,'Admin') > 0";
}
else
{
str = " SELECT CategoryMaster.CategoryName,ProductRepurchase.ProductCode,ProductRepurchase.ProductName,dbo.GetStock(ProductRepurchase.ProductID,'Admin') as Stock,ProductRepurchase.BV, ProductRepurchase.SalesAmount As MRP,0 AS Qty,0 as sAmt, ProductRepurchase.ProductID FROM ProductRepurchase INNER JOIN CategoryMaster ON ProductRepurchase.CategoryID = CategoryMaster.CategoryID where ProductRepurchase.status=0 and CategoryMaster.CategoryID ='" + ddlCategory.SelectedValue.ToString() + "' and dbo.GetStock(ProductRepurchase.ProductID,'Admin') > 0";
}
SqlDataAdapter da = new SqlDataAdapter(str, con);
DataSet ds1 = new DataSet();
da.Fill(ds1, "ProductRepurchase");
if (ds1.Tables[0].Rows.Count > 0)
{
GivMon.DataSource = ds1;
GivMon.DataBind();
GivMon.Visible = true;
btnSubmit.Visible = true;
}
else
{
GivMon.Visible = false;
btnSubmit.Visible = false;
}
if (Session["Test"] != null)
{
Label6.Text = Session["Test"].ToString();
}
Label6.Visible = true;
adt.Dispose();
da.Dispose();
ds.Dispose();
ds1.Dispose();
con.Close();
}
protected void ddlCategory_SelectedIndexChanged1(object sender, EventArgs e)
{
if (ddlCategory.SelectedIndex == 0)
{
GivMon.DataSource = "";
GivMon.DataBind();
return;
}
if (YearArray.Count == 0)
{
bind();
}
else
{
bind();
int k = 1;
int rowscount = GivMon.Rows.Count;
int columnscount = GivMon.Columns.Count;
int a1 = YearArray.Count / 8;
int i = 0;
int MyNo = 2;
int MyNo1 = 2;
for (int m1 = 0; m1 < YearArray.Count; m1++)
{
for (int i1 = 0; i1 < GivMon.Rows.Count; i1++)
{
if (YearArray[m1].ToString() == GivMon.Rows[i1].Cells[1].Text)
{
TextBox text1 = (TextBox)GivMon.Rows[i1].FindControl("TextBox1");
if (i1 == 0)
{
text1.Text = YearArray[m1 + 5].ToString();
GivMon.Rows[i1].Cells[7].Text = YearArray[m1 + 5 + 1].ToString();
}
if (i1 == 1)
{
int zz = (((6 * MyNo)) + MyNo1);
text1.Text = YearArray[m1 + 5].ToString();
GivMon.Rows[i1].Cells[7].Text = YearArray[m1 + 5 + 1].ToString();
MyNo = MyNo + 1;
MyNo1 = MyNo1 + 2;
}
}
}
}
}
}
protected void bind()
{
if (ddlCategory.SelectedIndex == 0)
{
GivMon.Visible = false;
btnSubmit.Visible = false;
return;
}
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
SqlDataAdapter adt = new SqlDataAdapter("select * from productrepurchase where categoryid='" + ddlCategory.SelectedValue.ToString() + "' and Status !=1", con);
DataSet ds = new DataSet();
adt.Fill(ds, "table");
string str = " select (select CategoryName from categorymaster where CategoryID ='" + ddlCategory.SelectedValue.ToString() + "') CategoryName,CategoryID ,Productid,productCode,ProductName,BV,MRP,sAmt,sQuantity,sAmt as sTotalAmount from productrepurchase where CategoryID ='" + ddlCategory.SelectedValue.ToString() + "' and Status !=1";
SqlDataAdapter da = new SqlDataAdapter(str, con);
DataSet ds1 = new DataSet();
da.Fill(ds1, "productrepurchase");
if (ds1.Tables[0].Rows.Count > 0)
{
GivMon.DataSource = ds1;
GivMon.DataBind();
GivMon.Visible = true;
btnSubmit.Visible = true;
}
else
{
GivMon.Visible = false;
btnSubmit.Visible = false;
}
adt.Dispose();
da.Dispose();
ds.Dispose();
ds1.Dispose();
con.Close();
}
