private void SelectedItemNameDetails(string pStrItemName)
{
gvItemsReceived.DataSource = SelectedIssueHeadDetails.GetDetailsOfSelectedItemName(pStrItemName).Tables[0];
gvItemsReceived.DataBind();
gvItemsReceived.Visible = true;
gvItemsIssued.DataSource = SelectedIssueHeadDetails.GetDetailsOfSelectedItemName(pStrItemName).Tables[1];
gvItemsIssued.DataBind();
gvItemsIssued.Visible = true;
if (gvItemsReceived.Rows.Count > 0)
{
gvItemsReceived.FooterRow.Cells[6].Text = SelectedIssueHeadDetails.GetDetailsOfSelectedItemName(pStrItemName).Tables[0].Compute("sum(Quantity)", "").ToString();
LblTotal1.Text = gvItemsReceived.FooterRow.Cells[6].Text;
}
else
{
LblTotal1.Text = "0.00";
}
if (gvItemsIssued.Rows.Count > 0)
{
gvItemsIssued.FooterRow.Cells[6].Text = SelectedIssueHeadDetails.GetDetailsOfSelectedItemName(pStrItemName).Tables[1].Compute("sum(Quantity)", "").ToString();
LblTotal2.Text = gvItemsIssued.FooterRow.Cells[6].Text;
}
else
{
LblTotal2.Text = "0.00";
}
Label1.Visible = true;
Label2.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["item"] != null)
{
lblItemName.Text = HttpUtility.UrlDecode(Request.QueryString["item"].ToString());
gvItemsInventory.DataSource = SelectedIssueHeadDetails.GetSelectedItemNameDetails(lblItemName.Text).Tables[0];
gvItemsInventory.DataBind();
gvItemsInventory.Visible = true;
}
}
private void SelectedIssueHeadNameDetails(string pStrIssueHeadName)
{
if (pStrIssueHeadName == "All" || pStrIssueHeadName == "")
{
gvItemsInventory.DataSource = SelectedIssueHeadDetails.GetAllDetails().Tables[0];
gvItemsInventory.DataBind();
gvItemsInventory.Visible = true;
}
else
{
gvItemsInventory.DataSource = SelectedIssueHeadDetails.GetSelectedIssueHeadDetails(pStrIssueHeadName).Tables[0];
gvItemsInventory.DataBind();
gvItemsInventory.Visible = true;
}
}
private void SelectedItemNameDetails(string pStrItemName)
{
gvItemsReceived.DataSource = SelectedIssueHeadDetails.GetDetailsOfSelectedItemName(pStrItemName).Tables[0];
gvItemsReceived.DataBind();
gvItemsReceived.Visible = true;
gvItemsIssued.DataSource = SelectedIssueHeadDetails.GetDetailsOfSelectedItemName(pStrItemName).Tables[1];
gvItemsIssued.DataBind();
gvItemsIssued.Visible = true;
if (gvItemsReceived.Rows.Count > 0)
{
gvItemsReceived.FooterRow.Cells[6].Text = SelectedIssueHeadDetails.GetDetailsOfSelectedItemName(pStrItemName).Tables[0].Compute("sum(Quantity)", "").ToString();
LblTotal1.Text = gvItemsReceived.FooterRow.Cells[6].Text;
}
else
{
LblTotal1.Text = "0.00";
}
if (gvItemsIssued.Rows.Count > 0)
{
gvItemsIssued.FooterRow.Cells[6].Text = SelectedIssueHeadDetails.GetDetailsOfSelectedItemName(pStrItemName).Tables[1].Compute("sum(Quantity)", "").ToString();
LblTotal2.Text = gvItemsIssued.FooterRow.Cells[6].Text;
}
else
{
LblTotal2.Text = "0.00";
}
double totalBalance = (Convert.ToDouble(LblTotal1.Text) - Convert.ToDouble(LblTotal2.Text));
if (totalBalance < 0)
{
lblTotalBalance.ForeColor = System.Drawing.Color.Red;
}
else
{
lblTotalBalance.ForeColor = System.Drawing.Color.Green;
}
lblTotalBalance.Text = totalBalance.ToString();
// Label1.Visible = LblTotal1.Visible = Label2.Visible = LblTotal2.Visible = true;
LblTotal1.Visible = LblTotal2.Visible = lblTotalBalance.Visible = true;
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (tbDate.Text == "")
{
return;
}
string selectedIssueHead = IssueHeadList.SelectedValue.ToString();
string myDate = DateTime.ParseExact(tbDate.Text, "dd/MM/yyyy", null).ToString("MM/dd/yyyy");
if (selectedIssueHead == "All" || selectedIssueHead == "")
{
gvItemsInventory.DataSource = SelectedIssueHeadDetails.GetAllDetailsByDate(myDate);
gvItemsInventory.DataBind();
gvItemsInventory.Visible = true;
}
else
{
gvItemsInventory.DataSource = SelectedIssueHeadDetails.GetSelectedIssueHeadDetails(selectedIssueHead, myDate);
gvItemsInventory.DataBind();
gvItemsInventory.Visible = true;
}
}
private void SelectedItemName(string pStrItemName)
{
gvItemsInventory.DataSource = SelectedIssueHeadDetails.GetSelectedItemNameDetails(pStrItemName).Tables[0];
gvItemsInventory.DataBind();
gvItemsInventory.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
//this is for one item
if (Request.QueryString["item"] != null)
{
string itemNameDecoded = HttpUtility.UrlDecode(Request.QueryString["item"].ToString());
con.Open();
SqlCommand cmdw = new SqlCommand("sp_GetDetailedInventoryByItemName '" + itemNameDecoded + "'", con);
SqlDataReader drd = cmdw.ExecuteReader();
GridView1.DataSource = drd;
GridView1.DataBind();
drd.Close();
con.Close();
GridView1.UseAccessibleHeader = true;
GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else if (Request.QueryString["IssueHeadName"] != null)
{
string decodedIHN = Utilities.QueryStringDecode(Request.QueryString["IssueHeadName"]);
string dateStockPosition = "";
//from date and to date - all issue head , specific issue head, dates can be empty or not empty
//1 no dates and all issuehead
//2 no dates and specific issuehead
//3 dates and all issue heads
//4 dates and specific issue head
if ((decodedIHN == "All") && (Request.QueryString["date"] == null)) //1
{
SqlConnection conn = new SqlConnection(AppConns.GetConnectionString());
SqlCommand cmd = new SqlCommand("sp_GetDetailedInventory", conn);
DataTable dt = new DataTable();
try
{
conn.Open();
SqlDataReader drd = cmd.ExecuteReader();
dt.Load(drd);
drd.Close();
}
catch (Exception ex)
{
ex.ToString();
}
finally
{
conn.Close();
}
if (Request.QueryString["Id"] == "1")
{
GridView1.DataSource = dt;
GridView1.DataBind();
GridView1.UseAccessibleHeader = true;
GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;
GridView1.Visible = true;
}
else if (Request.QueryString["Id"] == "2")
{
GridView2.DataSource = dt;
GridView2.DataBind();
GridView2.UseAccessibleHeader = true;
GridView2.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
else if ((decodedIHN != "All") && (Request.QueryString["date"] == null)) //if specific Ihn 2
{
if (Request.QueryString["Id"] == "1")
{
GridView1.DataSource = SelectedIssueHeadDetails.GetSelectedIssueHeadDetails(decodedIHN).Tables[0];
GridView1.DataBind();
GridView1.UseAccessibleHeader = true;
GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;
GridView1.Visible = true;
}
else if (Request.QueryString["Id"] == "2")
{
GridView2.DataSource = SelectedIssueHeadDetails.GetSelectedIssueHeadDetails(decodedIHN).Tables[0];
GridView2.DataBind();
GridView2.Visible = true;
GridView2.UseAccessibleHeader = true;
GridView2.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
//3
else if ((decodedIHN == "All") && (Request.QueryString["date"] != null)) //if all Ihn and dates 3
{
dateStockPosition = Request.QueryString["date"];
lblFromDate.Visible = true;
lblFromDate.Text = "Stock Position Date: " + dateStockPosition;
///
if (Request.QueryString["Id"] == "1")
{
GridView1.DataSource = SelectedIssueHeadDetails.GetAllDetailsByDate(dateStockPosition);
GridView1.DataBind();
GridView1.UseAccessibleHeader = true;
GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;
GridView1.Visible = true;
}
else if (Request.QueryString["Id"] == "2")
{
GridView2.DataSource = SelectedIssueHeadDetails.GetAllDetailsByDate(dateStockPosition);
GridView2.DataBind();
GridView2.UseAccessibleHeader = true;
GridView2.HeaderRow.TableSection = TableRowSection.TableHeader;
GridView2.Visible = true;
}
}
else if ((decodedIHN != "All") && (Request.QueryString["date"] != "")) //if specific Ihn and dates 4
{
dateStockPosition = Request.QueryString["date"];
lblFromDate.Visible = true;
lblFromDate.Text = "Stock Position Date: " + dateStockPosition;
if (Request.QueryString["Id"] == "1")
{
GridView1.DataSource = SelectedIssueHeadDetails.GetSelectedIssueHeadDetails(decodedIHN, dateStockPosition);
GridView1.DataBind();
GridView1.UseAccessibleHeader = true;
GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;
GridView1.Visible = true;
}
else if (Request.QueryString["Id"] == "2")
{
GridView2.DataSource = SelectedIssueHeadDetails.GetSelectedIssueHeadDetails(decodedIHN, dateStockPosition);
GridView2.DataBind();
GridView2.UseAccessibleHeader = true;
GridView2.HeaderRow.TableSection = TableRowSection.TableHeader;
GridView2.Visible = true;
}
}
}
}
