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; ////////////////////// }