protected void btnDelete_Click(object sender, EventArgs e) { try { #region DELETE // string TranDate = HfTranDate.Value; if (HfTranNo.Value != string.Empty && HfTranDate.Value != string.Empty) { string str = EXCISE_RATEMASLogicLayer.DeleteCHARGESDetailsByID(HfTranNo.Value, Convert.ToDateTime(HfTranDate.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:Service Tax Not Deleted"; lblmsg.ForeColor = Color.Red; } clear(); FillGrid(); UserRights(); } #endregion } catch (Exception) { throw; } }
public void FillGrid() { try { DataTable Dt = new DataTable(); Dt = EXCISE_RATEMASLogicLayer.GetAllEXCISE_RATEMASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); GvServiceTaxMaster.DataSource = Dt; GvServiceTaxMaster.DataBind(); } 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 { EXCISE_RATEMASLogicLayer insert = new EXCISE_RATEMASLogicLayer(); insert.TRAN_NO = HfTranNo.Value.Trim(); insert.FRDT = Convert.ToDateTime(TxtFromDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy"); //TxtFromDate.Text.Trim(); insert.TODT = Convert.ToDateTime(TxtToDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy"); //TxtToDate.Text.Trim(); if (TxtTax1.Text == string.Empty) { insert.EX_DUTY_PER = "0"; } else { insert.EX_DUTY_PER = TxtTax1.Text.Trim(); } insert.EX_DUTY_TITLE = TxtTitle1.Text.Trim().ToUpper(); if (TxtTax2.Text == string.Empty) { insert.EX_CESS_PER = "0"; } else { insert.EX_CESS_PER = TxtTax2.Text.Trim(); } insert.EX_CESS_TITLE = TxtTitle2.Text.Trim().ToUpper(); if (TxtTax3.Text == string.Empty) { insert.EX_SHCESS_PER = "0"; } else { insert.EX_SHCESS_PER = TxtTax3.Text.Trim(); } insert.EX_SHCESS_TITLE = TxtTitle3.Text.Trim().ToUpper(); if (TxtGST.Text == string.Empty) { insert.GST_RATE = "0"; } else { insert.GST_RATE = TxtGST.Text.Trim(); } if (TxtCGST.Text == string.Empty) { insert.CGST_RATE = "0"; } else { insert.CGST_RATE = TxtCGST.Text.Trim(); } if (TxtSGST.Text == string.Empty) { insert.SGST_RATE = "0"; } else { insert.SGST_RATE = TxtSGST.Text.Trim(); } if (TxtIGST.Text == string.Empty) { insert.IGST_RATE = "0"; } else { insert.IGST_RATE = TxtIGST.Text.Trim(); } insert.INS_USERID = Session["USERNAME"].ToString(); insert.INS_TERMINAL = Session["PC"].ToString(); insert.UPD_USERID = Session["USERNAME"].ToString(); insert.UPD_TERMINAL = Session["PC"].ToString(); if (BtncallUpd.Text.Trim().ToUpper() == "SAVE") { string str = EXCISE_RATEMASLogicLayer.InsertEXCISE_RATEMASDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "SERVICE TAX DETAIL ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "SERVICE TAX MASTER ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : SERVICE TAX DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } } } catch (Exception) { throw; } }
protected void GvServiceTaxMaster_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Deletea") { #region DELETE clear(); int id = int.Parse(e.CommandArgument.ToString()); //GridViewRow row = grdValidations.Rows[]; GridViewRow row = GvServiceTaxMaster.Rows[id - 1]; //Fetch value of Name. HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField; //GridViewRow row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); //HiddenField HfTranDateGrid = (HiddenField)e.row.FindControl("HfTranDateGrid"); DataTable dt = EXCISE_RATEMASLogicLayer.GetAllIDWiseEXCISE_RATEMASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); TxtFromDate.Text = Convert.ToDateTime(dt.Rows[0]["FRDT"].ToString()).ToString(); //dt.Rows[0]["FRDT"].ToString(); TxtToDate.Text = Convert.ToDateTime(dt.Rows[0]["TODT"].ToString()).ToString(); //dt.Rows[0]["TODT"].ToString(); TxtTax1.Text = dt.Rows[0]["EX_DUTY_PER"].ToString(); TxtTitle1.Text = dt.Rows[0]["EX_DUTY_TITLE"].ToString(); TxtTax2.Text = dt.Rows[0]["EX_CESS_PER"].ToString(); TxtTitle2.Text = dt.Rows[0]["EX_CESS_TITLE"].ToString(); TxtTax3.Text = dt.Rows[0]["EX_SHCESS_PER"].ToString(); TxtTitle3.Text = dt.Rows[0]["EX_SHCESS_TITLE"].ToString(); TxtGST.Text = dt.Rows[0]["GST_RATE"].ToString(); TxtCGST.Text = dt.Rows[0]["CGST_RATE"].ToString(); TxtSGST.Text = dt.Rows[0]["SGST_RATE"].ToString(); TxtIGST.Text = dt.Rows[0]["IGST_RATE"].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 = grdValidations.Rows[]; GridViewRow row = GvServiceTaxMaster.Rows[id - 1]; //Fetch value of Name. HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField; //GridViewRow row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); //HiddenField HfTranDateGrid = (HiddenField)e.row.FindControl("HfTranDateGrid"); DataTable dt = EXCISE_RATEMASLogicLayer.GetAllIDWiseEXCISE_RATEMASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); TxtFromDate.Text = Convert.ToDateTime(dt.Rows[0]["FRDT"].ToString()).ToString("MM-dd-yyyy"); //dt.Rows[0]["FRDT"].ToString(); TxtToDate.Text = Convert.ToDateTime(dt.Rows[0]["TODT"].ToString()).ToString("MM-dd-yyyy"); //dt.Rows[0]["TODT"].ToString(); TxtTax1.Text = dt.Rows[0]["EX_DUTY_PER"].ToString(); TxtTitle1.Text = dt.Rows[0]["EX_DUTY_TITLE"].ToString(); TxtTax2.Text = dt.Rows[0]["EX_CESS_PER"].ToString(); TxtTitle2.Text = dt.Rows[0]["EX_CESS_TITLE"].ToString(); TxtTax3.Text = dt.Rows[0]["EX_SHCESS_PER"].ToString(); TxtTitle3.Text = dt.Rows[0]["EX_SHCESS_TITLE"].ToString(); TxtGST.Text = dt.Rows[0]["GST_RATE"].ToString(); TxtCGST.Text = dt.Rows[0]["CGST_RATE"].ToString(); TxtSGST.Text = dt.Rows[0]["SGST_RATE"].ToString(); TxtIGST.Text = dt.Rows[0]["IGST_RATE"].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 = grdValidations.Rows[]; GridViewRow row = GvServiceTaxMaster.Rows[id - 1]; //Fetch value of Name. HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField; //GridViewRow row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); //HiddenField HfTranDateGrid = (HiddenField)e.row.FindControl("HfTranDateGrid"); DataTable dt = EXCISE_RATEMASLogicLayer.GetAllIDWiseEXCISE_RATEMASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); TxtFromDate.Text = Convert.ToDateTime(dt.Rows[0]["FRDT"].ToString()).ToString(); //dt.Rows[0]["FRDT"].ToString(); TxtToDate.Text = Convert.ToDateTime(dt.Rows[0]["TODT"].ToString()).ToString(); //dt.Rows[0]["TODT"].ToString(); TxtTax1.Text = dt.Rows[0]["EX_DUTY_PER"].ToString(); TxtTitle1.Text = dt.Rows[0]["EX_DUTY_TITLE"].ToString(); TxtTax2.Text = dt.Rows[0]["EX_CESS_PER"].ToString(); TxtTitle2.Text = dt.Rows[0]["EX_CESS_TITLE"].ToString(); TxtTax3.Text = dt.Rows[0]["EX_SHCESS_PER"].ToString(); TxtTitle3.Text = dt.Rows[0]["EX_SHCESS_TITLE"].ToString(); TxtGST.Text = dt.Rows[0]["GST_RATE"].ToString(); TxtCGST.Text = dt.Rows[0]["CGST_RATE"].ToString(); TxtSGST.Text = dt.Rows[0]["SGST_RATE"].ToString(); TxtIGST.Text = dt.Rows[0]["IGST_RATE"].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 _ UPDATE VALUE // string TranDate = HfTranDate.Value; EXCISE_RATEMASLogicLayer insert = new EXCISE_RATEMASLogicLayer(); insert.TRAN_DATE = Convert.ToDateTime(HfTranDate.Value).ToString("MM-dd-yyyy"); insert.TRAN_NO = HfTranNo.Value; insert.FRDT = Convert.ToDateTime(TxtFromDate.Text.Trim()).ToString("MM-dd-yyyy"); //TxtFromDate.Text.Trim(); insert.TODT = Convert.ToDateTime(TxtToDate.Text.Trim()).ToString("MM-dd-yyyy"); //TxtToDate.Text.Trim(); if (TxtTax1.Text == string.Empty) { insert.EX_DUTY_PER = "0"; } else { insert.EX_DUTY_PER = TxtTax1.Text.Trim(); } insert.EX_DUTY_TITLE = TxtTitle1.Text.Trim().ToUpper(); if (TxtTax2.Text == string.Empty) { insert.EX_CESS_PER = "0"; } else { insert.EX_CESS_PER = TxtTax2.Text.Trim(); } insert.EX_CESS_TITLE = TxtTitle2.Text.Trim().ToUpper(); if (TxtTax3.Text == string.Empty) { insert.EX_SHCESS_PER = "0"; } else { insert.EX_SHCESS_PER = TxtTax3.Text.Trim(); } insert.EX_SHCESS_TITLE = TxtTitle3.Text.Trim().ToUpper(); if (TxtGST.Text == string.Empty) { insert.GST_RATE = "0"; } else { insert.GST_RATE = TxtGST.Text.Trim(); } if (TxtCGST.Text == string.Empty) { insert.CGST_RATE = "0"; } else { insert.CGST_RATE = TxtCGST.Text.Trim(); } if (TxtSGST.Text == string.Empty) { insert.SGST_RATE = "0"; } else { insert.SGST_RATE = TxtSGST.Text.Trim(); } if (TxtIGST.Text == string.Empty) { insert.IGST_RATE = "0"; } else { insert.IGST_RATE = TxtIGST.Text.Trim(); } 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 = EXCISE_RATEMASLogicLayer.InsertEXCISE_RATEMASDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "SERVICE TAX DETAIL ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "SERVICE TAX MASTER ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : SERVICE TAX DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } else { string str = EXCISE_RATEMASLogicLayer.UpdateEXCISE_RATEMASDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "SERVICE TAX DETAIL UPDATE SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "SERVICE TAX MASTER ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : SERVICE TAX DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } } catch (Exception) { throw; } }