protected void BtnRemove_loc_Click(object sender, ImageClickEventArgs e)
        {
            DataSet dsdelete = new DataSet();

            Label itemcode = (Label)GridView_Location.FindControl("lblItemNo");

            dsdelete = (DataSet)Session["LocationDS"];

            try
            {
                ImageButton BtnLnk2    = (ImageButton)sender;
                GridViewRow rowGv      = (GridViewRow)BtnLnk2.Parent.Parent;
                int         rowGvIndex = rowGv.RowIndex;

                dsdelete.Tables[0].Rows[rowGvIndex].Delete();
                dsdelete.Tables[0].AcceptChanges();
                if (dsdelete.Tables[0].Rows.Count == 0)
                {
                    DataRow dr = dsdelete.Tables[0].NewRow();
                    dsdelete.Tables[0].Rows.Add(dr);
                }


                GridView_Location.DataSource = dsdelete.Tables[0];
                GridView_Location.DataBind();

                Session["LocationDS"] = dsdelete;
            }
            catch (Exception ex)
            {
                success_add_item.Visible   = true;
                success_add_item.ForeColor = Color.Red;
                success_add_item.Text      = ex.Message;
            }
        }
        protected void GridView_Location_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            DataSet ds = new DataSet();

            GridView_Location.EditIndex = -1;

            ds = (DataSet)Session["LocationDS"];

            GridView_Location.DataSource = ds.Tables[0];

            GridView_Location.DataBind();
        }
        protected void GridView_Location_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            try
            {
                DataSet ds_update = new DataSet();

                TextBox      txtqty    = (TextBox)GridView_Location.Rows[e.RowIndex].FindControl("txtQty");
                DropDownList ToLocCode = (DropDownList)GridView_Location.Rows[e.RowIndex].FindControl("ddlToLoc_code");
                Label        itemcode  = (Label)GridView_Location.Rows[e.RowIndex].FindControl("lblItemNo");

                double qty = double.Parse(txtqty.Text.Trim() == "" ? "0" : txtqty.Text.Trim());

                if (ToLocCode.SelectedIndex == 0)
                {
                    success_add_item.Visible = true;
                    success_add_item.Text    = "Select (To Location)";
                    return;
                }

                if (qty <= 0 || txtqty.Text.Trim() == string.Empty)
                {
                    success_add_item.Visible = true;
                    success_add_item.Text    = "Quantity can not Zero(0) or empty.";
                    return;
                }


                ds_update = (DataSet)Session["LocationDS"];

                foreach (DataRow dr in ds_update.Tables[0].Rows)
                {
                    if (dr["ItemCode"].ToString() == itemcode.Text)
                    {
                        dr["ToLocCode"] = ToLocCode.SelectedItem.Value;
                        dr["Qty"]       = qty;
                    }
                }

                GridView_Location.EditIndex = -1;

                GridView_Location.DataSource = ds_update.Tables[0];
                GridView_Location.DataBind();

                Session["LocationDS"] = ds_update;
            }
            catch (Exception ex)
            {
                success_add_item.Visible   = true;
                success_add_item.ForeColor = Color.Red;
                success_add_item.Text      = ex.Message;
            }
        }
        private void create_grid()
        {
            ds = new DataSet();
            ds.Tables.Add();
            ds.Tables[0].Columns.Add(new DataColumn("ItemCode", typeof(string)));
            ds.Tables[0].Columns.Add(new DataColumn("PartItemNo", typeof(string)));
            ds.Tables[0].Columns.Add(new DataColumn("ItemDesc", typeof(string)));
            ds.Tables[0].Columns.Add(new DataColumn("FromLocCode", typeof(string)));
            ds.Tables[0].Columns.Add(new DataColumn("ToLocCode", typeof(string)));
            ds.Tables[0].Columns.Add(new DataColumn("Qty", typeof(string)));

            DataRow dr = ds.Tables[0].NewRow();

            ds.Tables[0].Rows.Add(dr);


            GridView_Location.DataSource = ds.Tables[0];
            GridView_Location.DataBind();

            Session["LocationDS"] = ds;
        }
        protected void GridView_Location_RowEditing(object sender, GridViewEditEventArgs e)
        {
            try
            {
                DataSet ds = new DataSet();

                GridView_Location.EditIndex = e.NewEditIndex;

                ds = (DataSet)Session["LocationDS"];

                GridView_Location.DataSource = ds.Tables[0];

                GridView_Location.DataBind();
            }

            catch (Exception ex)
            {
                success_add_item.Visible   = true;
                success_add_item.ForeColor = Color.Red;
                success_add_item.Text      = ex.Message;
            }
        }
        private void create_row_location()
        {
            DropDownList ddlitem_code  = (DropDownList)GridView_Location.FooterRow.FindControl("ddlItemCode");
            DropDownList ddlToLoc_code = (DropDownList)GridView_Location.FooterRow.FindControl("ddlToLoc_code");
            TextBox      txtFromLoc    = (TextBox)GridView_Location.FooterRow.FindControl("txtFromLoc");
            TextBox      txtQty        = (TextBox)GridView_Location.FooterRow.FindControl("txtQty");

            if (ddlitem_code.SelectedIndex == 0)
            {
                success_add_item.Visible = true;
                success_add_item.Text    = "Select Part No.";
                return;
            }
            if (ddlToLoc_code.SelectedIndex == 0)
            {
                success_add_item.Visible = true;
                success_add_item.Text    = "Select To Location ";
                return;
            }
            if (txtQty.Text == "" || txtQty.Text == "0")
            {
                success_add_item.Visible = true;
                success_add_item.Text    = "Quantity cannot be empty or Zer(0)";
                return;
            }
            try
            {
                DataTable dt_newrow = new DataTable();

                string ItemCode, LocCode = "";
                ItemCode = ddlitem_code.SelectedValue.ToString().Substring(0, 8); //00000010,01B006
                LocCode  = ddlitem_code.SelectedValue.ToString().Substring(9, 6); //ddlitem_code.SelectedItem.Value.ToString().Length)

                string qry = "SELECT PartItemNo ,ItemDesc from Item Where ItemCode = '" + ItemCode + "' AND DealerCode in ('" + Session["DealerCode"] + "','COMON')";
                dt_newrow = SysFunc.GetData(qry);

                ds = new DataSet();

                ds = (DataSet)Session["LocationDS"];

                DataRow row = ds.Tables[0].NewRow();

                row["ItemCode"]    = ItemCode;
                row["PartItemNo"]  = dt_newrow.Rows[0]["PartItemNo"].ToString();
                row["ItemDesc"]    = dt_newrow.Rows[0]["ItemDesc"].ToString();
                row["FromLocCode"] = LocCode;
                row["ToLocCode"]   = ddlToLoc_code.SelectedItem.Value;
                row["Qty"]         = txtQty.Text.Trim();

                ds.Tables[0].Rows.Add(row);

                GridView_Location.DataSource = ds.Tables[0];
                GridView_Location.DataBind();

                Session["LocationDS"] = ds;
            }
            catch (Exception ex)
            {
                success_add_item.Visible   = true;
                success_add_item.ForeColor = Color.Red;
                success_add_item.Text      = ex.Message;
            }
        }