protected void btnDCSelect_Click(object sender, EventArgs e) { string sql = "select * from DCMaster where DealerCode='" + Session["DealerCode"].ToString() + "' And DCNo='" + ddDCNumber.Text + "'"; DataTable dt = myFunc.GetData(sql); if (dt.Rows.Count > 0) { dpDCDate.Date = Convert.ToDateTime(dt.Rows[0]["DCDate"].ToString()); ddPONumber.Text = dt.Rows[0]["PONo"].ToString(); ddPONumber.Visible = false; lblPONo.Visible = true; lblPONo.Text = dt.Rows[0]["PONo"].ToString(); this.Session["PONumber"] = dt.Rows[0]["PONo"].ToString(); txtVendorDCNo.Text = dt.Rows[0]["VendorDCNo"].ToString(); txtRemarks.Text = dt.Rows[0]["Remarks"].ToString(); this.Session["DCNumber"] = ddDCNumber.Text; LoadPOInfo(lblPONo.Text); //btnPOSelect_Click(btnPOSelect, EventArgs.Empty); // loading details of DC DataSet ds = new DataSet(); ds = (DataSet)this.Session["DCDataSet"]; ds.Tables["DCItems"].Rows.Clear(); dt = myFunc.GetData("select * from DCDetail where DealerCode='" + Session["DealerCode"].ToString() + "' And DCNo='" + ddDCNumber.Text + "'"); if (dt.Rows.Count != 0) { foreach (DataRow dRow in dt.Rows) { DataRow row = ds.Tables["DCItems"].NewRow(); row["Sno"] = ds.Tables["DCItems"].Rows.Count + 1; row["PartItemNo"] = myFunc.GetPartItemNoByItemCode(dRow["ItemCode"].ToString()); row["PartItemName"] = myFunc.GetItemDescByItemCode(dRow["ItemCode"].ToString()); row["unit"] = myFunc.GetUnitDescByPartItemNo(row["PartItemNo"].ToString()); row["POQuantity"] = dRow["POQty"].ToString(); row["BalanceQuantity"] = dRow["BalQty"].ToString(); row["DCQuantity"] = dRow["DCQty"].ToString(); row["Selected"] = true; ds.Tables["DCItems"].Rows.Add(row); } } Session["DCDataSet"] = ds; GridViewDC.DataSource = ds; GridViewDC.DataBind(); btnDelete.Enabled = true; lblDCStatus.Text = "Edited"; } else { lblMSG.Text = "DC number not found"; return; } }
protected void ddlDCno_SelectedIndexChanged(object sender, EventArgs e) { lblMode.Text = "Edit Mode"; string sql = "select * from DCMaster where DealerCode='" + Session["DealerCode"].ToString() + "' And DCNo='" + ddlDCno.SelectedValue + "'"; DataTable dt = myFunc.GetData(sql); if (dt.Rows.Count > 0) { txtDCDate.Text = dt.Rows[0]["DCDate"].ToString(); //ddlPONo.Text = dt.Rows[0]["PONo"].ToString(); ddlPONo.Visible = false; lblPONo.Visible = true; lblPONo.Text = dt.Rows[0]["PONo"].ToString(); this.Session["PONumber"] = dt.Rows[0]["PONo"].ToString(); txtVendorDCn0.Text = dt.Rows[0]["VendorDCNo"].ToString(); txtRemarks.Text = dt.Rows[0]["Remarks"].ToString(); this.Session["DCNumber"] = ddlDCno.SelectedValue; LoadPOInfo(lblPONo.Text); //btnPOSelect_Click(btnPOSelect, EventArgs.Empty); // loading details of DC DataTable dtTable = new DataTable(); dtTable = (DataTable)this.Session["DCTable"]; dtTable.Rows.Clear(); dt = myFunc.GetData("select * from DCDetail where DealerCode='" + Session["DealerCode"].ToString() + "' And DCNo='" + ddlDCno.SelectedValue + "'"); if (dt.Rows.Count != 0) { foreach (DataRow dRow in dt.Rows) { DataRow row = dtTable.NewRow(); row["Sno"] = dtTable.Rows.Count + 1; row["PartItemNo"] = myFunc.GetPartItemNoByItemCode(dRow["ItemCode"].ToString()); row["PartItemName"] = myFunc.GetItemDescByItemCode(dRow["ItemCode"].ToString()); row["unit"] = myFunc.GetUnitDescByPartItemNo(row["PartItemNo"].ToString()); row["POQuantity"] = dRow["POQty"].ToString(); row["BalanceQuantity"] = dRow["BalQty"].ToString(); row["DCQuantity"] = dRow["DCQty"].ToString(); //row["Selected"] = true; dtTable.Rows.Add(row); } } Session["DCTable"] = dtTable; gv_DC.DataSource = dtTable; gv_DC.DataBind(); txtStatus.Text = "OLD"; //btnDelete.Enabled = true; } else { return; } }