protected void BtnRemovePart_Click(object sender, ImageClickEventArgs e)
{
DataSet dsDelete = new DataSet();
try
{
if (ddlStockReturnNo.SelectedIndex != 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "The Return is already Saved; now you could not change/delete the record...");
return;
}
dsDelete = (DataSet)ViewState["ObjPOds"];
ImageButton BtnLnk = (ImageButton)sender;
GridViewRow rowGv = (GridViewRow)BtnLnk.Parent.Parent;
int rowGvIndex = rowGv.RowIndex;
dsDelete.Tables[0].Rows[rowGvIndex].Delete();
GvMain.DataSource = dsDelete.Tables[0];
GvMain.DataBind();
dsDelete.Tables[0].AcceptChanges();
LbErr.Text = "";
ViewState["ObjPOds"] = dsDelete;
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
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;
}
private void CtlClear(string strChk)
{
DataSet ds = new DataSet();
try
{
txtRetDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
txtRemarks.Text = string.Empty;
txtPartItemDesc.Text = string.Empty;
txtUnit.Text = string.Empty;
txtUnitCode.Text = string.Empty;
txtIssueQty.Text = string.Empty;
txtRemaining.Text = string.Empty;
txtTotalStock.Text = string.Empty;
txtStockLoc.Text = string.Empty;
txtRetQty.Text = string.Empty;
txtTotalAmt.Text = string.Empty;
txtIssueRate.Text = string.Empty;
txtLocCode.Text = string.Empty;
txtLocDesc.Text = string.Empty;
ddlIssueNo.SelectedIndex = 0;
ds = (DataSet)ViewState["ObjPOds"];
ds.Tables[0].Rows.Clear();
ViewState["ObjPOds"] = ds;
GvMain.DataSource = ds;
GvMain.DataBind();
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
private void CtlClear(string strChk)
{
DataSet ds = new DataSet();
try
{
ddlCustomer.Enabled = true;
SysFunc.ClearTextBoxes(Page);
ddlSRNO.SelectedIndex = 0;
txtRetDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
ddlCustomer.SelectedIndex = 0;
rdCounterSale.Checked = false;
rdJobCard.Checked = false;
rdCounterSale.Enabled = false;
rdJobCard.Enabled = false;
ddlSaleInvNo.Items.Clear();
ddlParts.Items.Clear();
ds = (DataSet)ViewState["ObjPOds"];
ds.Tables["SaleReturnTable"].Rows.Clear();
ViewState["ObjPOds"] = ds;
GvMain.DataSource = ds;
GvMain.DataBind();
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
protected void GvMain_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
DataSet ds = new DataSet();
GvMain.EditIndex = -1;
ds = (DataSet)ViewState["ObjPOds"];
GvMain.DataSource = ds.Tables[0];
GvMain.DataBind();
}
protected void GvMain_RowEditing(object sender, GridViewEditEventArgs e)
{
DataSet ds = new DataSet();
if (ddlStockReturnNo.SelectedIndex != 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "The Return is already Saved; now you could not change/delete the record...");
return;
}
GvMain.EditIndex = e.NewEditIndex;
ds = (DataSet)ViewState["ObjPOds"];
GvMain.DataSource = ds.Tables[0];
GvMain.DataBind();
}
protected void GvMain_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DataSet ds = new DataSet();
double DQty = 0.0, DRate = 0.0, DRemainingQty = 0.0, DTotal = 0.0;
try
{
Label lblItemCode = (Label)GvMain.Rows[e.RowIndex].FindControl("lblEditItemCode");
TextBox txtEditRetQty = (TextBox)GvMain.Rows[e.RowIndex].FindControl("txtEditRetQty");
Label lblEditRate = (Label)GvMain.Rows[e.RowIndex].FindControl("lblEditRate");
Label lblEditRemainingQty = (Label)GvMain.Rows[e.RowIndex].FindControl("lblEditRemainingQty");
DQty = Convert.ToDouble(txtEditRetQty.Text.Trim() == "" ? "0" : txtEditRetQty.Text.Trim());
DRate = Convert.ToDouble(lblEditRate.Text.Trim() == "" ? "0" : lblEditRate.Text.Trim());
DRemainingQty = Convert.ToDouble(lblEditRemainingQty.Text.Trim() == "" ? "0" : lblEditRemainingQty.Text.Trim());
if (DQty <= 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "Return Quantity can not be zero(0)");
return;
}
if (DQty > DRemainingQty)
{
SysFunc.UserMsg(LbErr, Color.Red, "Return Quantity can not be greater then Remaining quantity");
return;
}
DTotal = DRate * DQty;
ds = (DataSet)ViewState["ObjPOds"];
foreach (DataRow dr in ds.Tables[0].Rows) // search whole table
{
if (dr["ItemCode"].ToString() == lblItemCode.Text) // if id==2
{
dr["ReturnQty"] = DQty.ToString();
dr["Amount"] = DTotal.ToString();
}
}
GvMain.EditIndex = -1;
GvMain.DataSource = ds.Tables[0];
GvMain.DataBind();
ViewState["ObjPOds"] = ds;
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
DataSet dsDelete = new DataSet();
try
{
if (ddlSRNO.SelectedIndex != 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "Already sales returned do not change ");
return;
}
dsDelete = (DataSet)ViewState["ObjPOds"];
ImageButton BtnLnk = (ImageButton)sender;
GridViewRow rowGv = (GridViewRow)BtnLnk.Parent.Parent;
int rowGvIndex = rowGv.RowIndex;
dsDelete.Tables["SaleReturnTable"].Rows[rowGvIndex].Delete();
GvMain.DataSource = dsDelete.Tables["SaleReturnTable"];
GvMain.DataBind();
dsDelete.Tables["SaleReturnTable"].AcceptChanges();
LbErr.Text = "";
ViewState["ObjPOds"] = dsDelete;
//calculate total parts amount
if (dsDelete.Tables["SaleReturnTable"].Rows.Count > 0)
{
double iRate = 0;
foreach (DataRow dr in dsDelete.Tables["SaleReturnTable"].Rows)
{
iRate = iRate + Convert.ToDouble(dr["Amount"].ToString());
}
txtTotalAmt.Text = iRate.ToString();
}
else
{
txtTotalAmt.Text = "0";
}
//////////////////////
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
private void FillGV()
{
DataSet dsMain = new DataSet();
try
{
SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@ReturnNo", SqlDbType.Char, 10) };
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlStockReturnNo.SelectedValue.ToString().Trim();
dsMain = SysFunc.Get_Parts_Get_StockRetDetail(param);
GvMain.DataSource = dsMain.Tables[0];
GvMain.DataBind();
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
private void createPartsDT()
{
dsGVMain = new DataSet();
dsGVMain.Tables.Add();
dsGVMain.Tables[0].Columns.Add(new DataColumn("ItemCode", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("PartItemNo", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("PartItemName", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("Unit", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("UnitCode", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("RemainingQty", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("ReturnQty", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("Amount", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("Rate", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("Location", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("LocationCode", typeof(string)));
GvMain.DataSource = dsGVMain.Tables[0];
GvMain.DataBind();
ViewState["ObjPOds"] = dsGVMain;
}
private void createPartsDT()
{
ObjPOds = new DataSet();
ObjPOds.Tables.Add("SaleReturnTable");
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("Sno", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("ItemCode", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("PartItemNo", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("PartItemName", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("Unit", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("UnitCode", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("Rate", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("Qty", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("Amount", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("LocationCode", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("Location", typeof(string)));
ObjPOds.Tables["SaleReturnTable"].Columns.Add(new DataColumn("AvgRate", typeof(string)));
GvMain.DataSource = ObjPOds.Tables["SaleReturnTable"];
GvMain.DataBind();
ViewState["ObjPOds"] = ObjPOds;
}
private void createPartsDT()
{
dsGVMain = new DataSet();
dsGVMain.Tables.Add();
dsGVMain.Tables[0].Columns.Add(new DataColumn("ItemCode", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("PartItemNo", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("ItemDesc", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("Location", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("Quantity", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("BalQty", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("OLStock", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("issueQty", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("AvgCost", typeof(string)));
dsGVMain.Tables[0].Columns.Add(new DataColumn("Amount", typeof(string)));
//DataRow dr = dsGVMain.Tables[0].NewRow();
//dsGVMain.Tables[0].Rows.Add(dr);
GvMain.DataSource = dsGVMain.Tables[0];
GvMain.DataBind();
Session["dsParts"] = dsGVMain;
}
private void AddNewRow()
{
DataSet ds = new DataSet();
ds = (DataSet)ViewState["ObjPOds"];
DataRow row = ds.Tables[0].NewRow();
row["ItemCode"] = ddlPartsNo.SelectedValue.ToString().Trim();
row["PartItemNo"] = txtPartItemNo.Text;
row["PartItemName"] = txtPartItemDesc.Text.Trim();
row["Unit"] = txtUnit.Text.Trim();
row["UnitCode"] = txtUnitCode.Text.Trim();
row["RemainingQty"] = txtRemaining.Text.Trim();
row["ReturnQty"] = txtRetQty.Text.Trim();
row["Amount"] = txtTotalAmt.Text.Trim();
row["Rate"] = txtIssueRate.Text.Trim();
row["Location"] = txtLocDesc.Text;
row["LocationCode"] = txtLocCode.Text;
ds.Tables[0].Rows.Add(row);
GvMain.DataSource = ds.Tables[0];
GvMain.DataBind();
ViewState["ObjPOds"] = ds;
}
private void AddNewRow()
{
SqlDataReader dr = null;
//DataSet ds = new DataSet();
DataTable dt = new DataTable();
//DropDownList ddlParts = (DropDownList)GvMain.FooterRow.FindControl("ddlParts");
//TextBox txtFooterQty = (TextBox)GvMain.FooterRow.FindControl("txtFooterQty");
SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@SIRNo", SqlDbType.Char, 8), };
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlSirNo.SelectedValue.ToString();
SysFunc.ExecuteSP("Sp_SirDetail_Items_Select", param, ref dr);
if (dr.HasRows)
{
dt.Load(dr);
GvMain.DataSource = dt;
GvMain.DataBind();
}
else
{
createPartsDT();
}
//ds = (DataSet)Session["dsParts"];
//DataRow row = ds.Tables[0].NewRow();
//foreach (DataRow drTable in dt.Rows)
//{
// ////Get OH stock
// //DataSet dsOHStock = new DataSet();
// //dsOHStock = SysFunc.PartStock(drTable["ItemCode"].ToString(), Session["DealerCode"].ToString());
// //decimal DTotalStock = Convert.ToDecimal(dsOHStock.Tables[0].Rows[0]["Balance"]);
// ///////////////////////////////////////////////////////
// //Get Avg Cost
// DataSet dsAvgCost = new DataSet();
// decimal DAvgCost = 0;
// dsAvgCost = SysFunc.ItemAvgCost(drTable["ItemCode"].ToString(), Session["DealerCode"].ToString());
// if (dsAvgCost.Tables[0].Rows.Count != 0)
// {
// DAvgCost = Convert.ToDecimal(dsAvgCost.Tables[0].Rows[0]["Cost"]);
// }
// //////////////////////////////////////////////////////
// row["ItemCode"] = drTable["ItemCode"].ToString();
// row["PartItemNo"] = drTable["PartItemNo"].ToString();
// row["ItemDesc"] = drTable["ItemDesc"].ToString();
// row["Location"] = drTable["Location"].ToString();
// row["Quantity"] = drTable["Quantity"].ToString();
// row["BalQty"] = drTable["BalQty"].ToString();
// //row["OHStock"] = "0";
// row["OLStock"] = "0";
// row["AvgCost"] = DAvgCost.ToString();
// row["Amount"] = "0";
// ds.Tables[0].Rows.Add(row);
//}
//GvMain.DataSource = dt;
//GvMain.DataBind();
//Session["dsParts"] = ds;
//////////////////////
}
