protected void btnDelete_Click(object sender, EventArgs e) { try { #region DELETE // string TranDate = HfTranDate.Value; if (HfTransNo.Value != string.Empty && HfTransDate.Value != string.Empty) { string str = OP_STOCK_BALLogicLayer.DeleteSTOCK_OP_BALDetailsByID(HfTransNo.Value, Convert.ToDateTime(HfTransDate.Value.ToString())); if (str.Contains("successfully")) { lblmsg.Text = "Record Deleted Successfully"; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Cannot")) { lblmsg.Text = "Cannot Delete This Record It Used by Other Data"; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "Error:STOCK OPENING BALANCE Not Deleted"; lblmsg.ForeColor = Color.Red; } clear(); FillGrid(Session["COMP_CODE"].ToString()); UserRights(); } #endregion } catch (Exception) { throw; } }
public void FillGrid(string CompCode) { try { DataTable Dt = new DataTable(); Dt = OP_STOCK_BALLogicLayer.GetAllSTOCK_OP_BALDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); DataView Dv = new DataView(Dt); if (CompCode != string.Empty) { Dv.RowFilter = "COMP_CODE=" + Session["COMP_CODE"].ToString(); } GvStocktOpeningBalance.DataSource = Dv.ToTable(); GvStocktOpeningBalance.DataBind(); DtSearch = Dv.ToTable(); } catch (Exception) { throw; } }
protected void BtncallUpd_Click(object sender, EventArgs e) { try { if (BtncallUpd.Text == "UPDATE") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true); } else { OP_STOCK_BALLogicLayer insert = new OP_STOCK_BALLogicLayer(); insert.COMP_CODE = Session["COMP_CODE"].ToString(); insert.BRANCH_CODE = Session["BRANCH_CODE"].ToString(); // insert.TRAN_DATE = Convert.ToDateTime(TxtTranDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy"); //HfTransDate.Value.Trim(); // insert.TRAN_NO = HfTransNo.Value.Trim(); insert.YRDT1 = Convert.ToDateTime(Session["FIN_YEAR"]).ToString("yyyy-MM-dd"); insert.TRNDT = Convert.ToDateTime(TxtTranDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy");//TxtTranDate.Text.Trim(); insert.SRNO = HfSrNo.Value.Trim(); insert.SCODE = HfDetailSCode.Value.Trim().ToUpper(); if (TxtQuantity.Text == string.Empty) { insert.QTY = "0"; } else { insert.QTY = TxtQuantity.Text.Trim(); } if (TxtRate.Text == string.Empty) { insert.RATE = "0"; } else { insert.RATE = TxtRate.Text.Trim(); } if (TxtAmount.Text == string.Empty) { insert.AMT = "0"; } else { insert.AMT = TxtAmount.Text.Trim(); } insert.REMARK = ""; insert.INS_USERID = Session["USERNAME"].ToString(); insert.INS_TERMINAL = Session["PC"].ToString(); insert.INS_DATE = ""; insert.UPD_USERID = Session["USERNAME"].ToString(); insert.UPD_TERMINAL = Session["PC"].ToString(); insert.UPD_DATE = ""; if (BtncallUpd.Text.Trim().ToUpper() == "SAVE") { string str = OP_STOCK_BALLogicLayer.InsertSTOCK_OP_BALDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "STOCK OPENING BALANCE DETAIL ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(Session["COMP_CODE"].ToString()); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "STOCK OPENING BALANCE MASTER ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : STOCK OPENING BALANCE DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } } } catch (Exception) { throw; } }
protected void GvStocktOpeningBalance_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Deletea") { #region DELETE clear(); int id = int.Parse(e.CommandArgument.ToString()); GridViewRow row = GvStocktOpeningBalance.Rows[id]; HiddenField HfTranDateGrid = (row.FindControl("HfTransDateGrid")) as HiddenField; DataTable dt = OP_STOCK_BALLogicLayer.GetAllIDWiseSTOCK_OP_BALDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfBranchCode.Value = dt.Rows[0]["BRANCH_CODE"].ToString(); HfYearDate1.Value = dt.Rows[0]["YRDT1"].ToString(); HfTransDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTransNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); HfSrNo.Value = dt.Rows[0]["SRNO"].ToString(); TxtTranDate.Text = Convert.ToDateTime(dt.Rows[0]["TRNDT"].ToString()).ToString("dd-MM-yyyy"); TxtQuantity.Text = dt.Rows[0]["QTY"].ToString(); TxtRate.Text = dt.Rows[0]["RATE"].ToString(); TxtAmount.Text = dt.Rows[0]["AMT"].ToString(); // HfDetailSCode.Value = dt.Rows[0]["SCODE"].ToString(); FillTxtProductNameOnUpdate(dt.Rows[0]["SCODE"].ToString()); } btnSave.Visible = false; btnDelete.Visible = true; Btncalldel.Visible = true; BtncallUpd.Visible = false; ControllerDisable(); #endregion } if (e.CommandName == "Edita") { #region Edit clear(); int id = int.Parse(e.CommandArgument.ToString()); GridViewRow row = GvStocktOpeningBalance.Rows[id]; HiddenField HfTranDateGrid = (row.FindControl("HfTransDateGrid")) as HiddenField; DataTable dt = OP_STOCK_BALLogicLayer.GetAllIDWiseSTOCK_OP_BALDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfBranchCode.Value = dt.Rows[0]["BRANCH_CODE"].ToString(); HfYearDate1.Value = dt.Rows[0]["YRDT1"].ToString(); HfTransDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTransNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); HfSrNo.Value = dt.Rows[0]["SRNO"].ToString(); TxtTranDate.Text = Convert.ToDateTime(dt.Rows[0]["TRNDT"].ToString()).ToString("dd-MM-yyyy"); TxtQuantity.Text = dt.Rows[0]["QTY"].ToString(); TxtRate.Text = dt.Rows[0]["RATE"].ToString(); TxtAmount.Text = dt.Rows[0]["AMT"].ToString(); // HfDetailSCode.Value = dt.Rows[0]["SCODE"].ToString(); FillTxtProductNameOnUpdate(dt.Rows[0]["SCODE"].ToString()); BtncallUpd.Text = "UPDATE"; #endregion } #region CHECK UPDATE RIGHTS if (Session["UPDATE"] != null) { if (Session["UPDATE"].ToString() == "Y") { ControllerEnable(); } else { ControllerDisable(); } } #endregion Btncalldel.Visible = false; BtncallUpd.Visible = true; btnSave.Visible = true; UserRights(); } if (e.CommandName == "Viewa") { #region SET TEXT ON VIEW clear(); int id = int.Parse(e.CommandArgument.ToString()); GridViewRow row = GvStocktOpeningBalance.Rows[id]; HiddenField HfTranDateGrid = (row.FindControl("HfTransDateGrid")) as HiddenField; DataTable dt = OP_STOCK_BALLogicLayer.GetAllIDWiseSTOCK_OP_BALDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfBranchCode.Value = dt.Rows[0]["BRANCH_CODE"].ToString(); HfYearDate1.Value = dt.Rows[0]["YRDT1"].ToString(); HfTransDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTransNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); HfSrNo.Value = dt.Rows[0]["SRNO"].ToString(); TxtTranDate.Text = Convert.ToDateTime(dt.Rows[0]["TRNDT"].ToString()).ToString("dd-MM-yyyy"); TxtQuantity.Text = dt.Rows[0]["QTY"].ToString(); TxtRate.Text = dt.Rows[0]["RATE"].ToString(); TxtAmount.Text = dt.Rows[0]["AMT"].ToString(); // HfDetailSCode.Value = dt.Rows[0]["SCODE"].ToString(); FillTxtProductNameOnUpdate(dt.Rows[0]["SCODE"].ToString()); #endregion } ControllerDisable(); btnSave.Visible = false; Btncalldel.Visible = false; BtncallUpd.Visible = false; UserRights(); } } catch (Exception ex) { lblmsg.Text = ex.Message.ToString(); } }
protected void btnSave_Click(object sender, EventArgs e) { try { #region INSERT OPENING STOCK MASTER OP_STOCK_BALLogicLayer insert = new OP_STOCK_BALLogicLayer(); insert.COMP_CODE = HfCompCode.Value.Trim(); insert.BRANCH_CODE = HfBranchCode.Value.Trim(); insert.TRAN_DATE = Convert.ToDateTime(HfTransDate.Value.Trim().ToString()).ToString("MM-dd-yyyy"); //HfTransDate.Value.Trim(); insert.TRAN_NO = HfTransNo.Value.Trim(); insert.YRDT1 = Convert.ToDateTime(HfYearDate1.Value.Trim()).ToString("yyyy-MM-dd"); insert.TRNDT = Convert.ToDateTime(TxtTranDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy");//TxtTranDate.Text.Trim(); insert.SRNO = HfSrNo.Value.Trim(); insert.SCODE = HfDetailSCode.Value.Trim().ToUpper(); if (TxtQuantity.Text == string.Empty) { insert.QTY = "0"; } else { insert.QTY = TxtQuantity.Text.Trim(); } if (TxtRate.Text == string.Empty) { insert.RATE = "0"; } else { insert.RATE = TxtRate.Text.Trim(); } if (TxtAmount.Text == string.Empty) { insert.AMT = "0"; } else { insert.AMT = TxtAmount.Text.Trim(); } insert.REMARK = ""; insert.INS_USERID = Session["USERNAME"].ToString(); insert.INS_TERMINAL = Session["PC"].ToString(); insert.INS_DATE = ""; insert.UPD_USERID = Session["USERNAME"].ToString(); insert.UPD_TERMINAL = Session["PC"].ToString(); insert.UPD_DATE = ""; #endregion if (btnSave.Text.Trim().ToUpper() == "SAVE") { string str = OP_STOCK_BALLogicLayer.InsertSTOCK_OP_BALDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "STOCK OPENING BALANCE DETAIL ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(Session["COMP_CODE"].ToString()); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "STOCK OPENING BALANCE MASTER ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : STOCK OPENING BALANCE DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } else { string str = OP_STOCK_BALLogicLayer.UpdateBRAND_COMPLAIN_MASDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "STOCK OPENING BALANCE DETAIL UPDATE SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(Session["COMP_CODE"].ToString()); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "STOCK OPENING BALANCE MASTER ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : STOCK OPENING BALANCE DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } } catch (Exception) { throw; } }