private void AddNewRow()
{
DataSet ds = new DataSet();
ds = (DataSet)ViewState["ObjPOds"];
DataRow row = ds.Tables["SaleReturnTable"].NewRow();
if (lblSNo.Text.Trim() != string.Empty)
{
row["Sno"] = lblSNo.Text;
}
else
{
row["Sno"] = SysFunc.GetNewMaxID("Sno", 3, ds);
}
row["Sno"] = ds.Tables["SaleReturnTable"].Rows.Count + 1;
row["ItemCode"] = txtItemCode.Text.Trim();
row["PartItemNo"] = SysFunc.GetPartItemNoByItemCode(ddlParts.SelectedValue.ToString());
row["PartItemName"] = SysFunc.GetItemDescByItemCode(ddlParts.SelectedValue.ToString());
row["Unit"] = txtUnit.Text.Trim();
row["UnitCode"] = txtUnitCode.Text.Trim();
row["Rate"] = txtRate.Text.Trim();
row["Qty"] = txtQty.Text;
row["Amount"] = txtTotalAmt.Text;
row["Location"] = txtLocDesc.Text;
row["LocationCode"] = txtLocCode.Text;
row["AvgRate"] = txtAvgCost.Text;
ds.Tables["SaleReturnTable"].Rows.Add(row);
//ViewState["ObjPOds"] = ds;
GvMain.DataSource = ds.Tables["SaleReturnTable"];
GvMain.DataBind();
ViewState["ObjPOds"] = ds;
}
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;
}
}
