protected void btnDelete_Click(object sender, EventArgs e) { try { #region DELETE if (HfBCode.Value != string.Empty) { string str = BROKER_MASLogicLayer.DeleteBROKERDetailsByID(HfBCode.Value); 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:Person Master Not Deleted"; lblmsg.ForeColor = Color.Red; } clear(); FillGrid(Session["COMP_CODE"].ToString()); UserRights(); } #endregion } catch (Exception) { throw; } }
protected void TxtPersonName_TextChanged(object sender, EventArgs e) { try { DataTable DtBrokerName = new DataTable(); // DtBrokerName = BROKER_MASLogicLayer.GetAllBROKERDetialsWiseComapnyAndBranch(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE"].ToString()); DtBrokerName = BROKER_MASLogicLayer.GetAllBROKER_MASDetialsCompanyWiseFor_DDL(Session["COMP_CODE"].ToString()); if (TxtPersonName.Text != string.Empty) { DataView Dv = new DataView(DtBrokerName); Dv.RowFilter = "BNAME='" + TxtPersonName.Text.Trim() + "'"; DataTable DtView = Dv.ToTable(); if (DtView.Rows.Count > 0) { HfBCODE.Value = DtView.Rows[0]["BCODE"].ToString(); } else { HfBCODE.Value = null; } } } catch (Exception) { throw; } }
public void FillGrid(string CompCode) { try { // HfCompCode.Value = Session["COMP_CODE"].ToString(); DataTable Dt = new DataTable(); Dt = BROKER_MASLogicLayer.GetAllBROKERDetials(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(); } GvPersonMaster.DataSource = Dv.ToTable(); GvPersonMaster.DataBind(); DtSearch = Dv.ToTable(); } catch (Exception) { throw; } }
protected void GvPersonMaster_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Deletea") { #region DELETE clear(); DataTable dt = BROKER_MASLogicLayer.GetAllIDWiseBROKERDetials(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfBCode.Value = dt.Rows[0]["BCODE"].ToString(); TxtPersonName.Text = dt.Rows[0]["BNAME"].ToString(); TxtAddress1.Text = dt.Rows[0]["BADD"].ToString(); TxtPhoneO.Text = dt.Rows[0]["PHONE_O"].ToString(); TxtPhoneM.Text = dt.Rows[0]["PHONE_M"].ToString(); HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); FillDdlBranch(); DdlBranch.SelectedValue = dt.Rows[0]["BRANCH_CODE"].ToString(); DdlActive.SelectedValue = dt.Rows[0]["ACTIVE"].ToString(); } btnSave.Visible = false; btnDelete.Visible = true; Btncalldel.Visible = true; BtncallUpd.Visible = false; ControllerDisable(); #endregion } if (e.CommandName == "Edita") { #region EDIT clear(); DataTable dt = BROKER_MASLogicLayer.GetAllIDWiseBROKERDetials(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfBCode.Value = dt.Rows[0]["BCODE"].ToString(); TxtPersonName.Text = dt.Rows[0]["BNAME"].ToString(); TxtAddress1.Text = dt.Rows[0]["BADD"].ToString(); TxtPhoneO.Text = dt.Rows[0]["PHONE_O"].ToString(); TxtPhoneM.Text = dt.Rows[0]["PHONE_M"].ToString(); HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); FillDdlBranch(); DdlBranch.SelectedValue = dt.Rows[0]["BRANCH_CODE"].ToString(); DdlActive.SelectedValue = dt.Rows[0]["ACTIVE"].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(); DataTable dt = BROKER_MASLogicLayer.GetAllIDWiseBROKERDetials(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfBCode.Value = dt.Rows[0]["BCODE"].ToString(); TxtPersonName.Text = dt.Rows[0]["BNAME"].ToString(); TxtAddress1.Text = dt.Rows[0]["BADD"].ToString(); TxtPhoneO.Text = dt.Rows[0]["PHONE_O"].ToString(); TxtPhoneM.Text = dt.Rows[0]["PHONE_M"].ToString(); HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); FillDdlBranch(); DdlBranch.SelectedValue = dt.Rows[0]["BRANCH_CODE"].ToString(); DdlActive.SelectedValue = dt.Rows[0]["ACTIVE"].ToString(); #endregion } ControllerDisable(); btnSave.Visible = false; Btncalldel.Visible = false; BtncallUpd.Visible = false; UserRights(); } } catch (Exception ex) { lblmsg.Text = ex.Message.ToString(); } }
protected void BtncallUpd_Click(object sender, EventArgs e) { try { if (BtncallUpd.Text == "UPDATE") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true); } else { HfCompCode.Value = Session["COMP_CODE"].ToString(); BROKER_MASLogicLayer insert = new BROKER_MASLogicLayer(); insert.COMP_CODE = HfCompCode.Value; insert.BRANCH_CODE = DdlBranch.SelectedValue.Trim().ToUpper(); insert.BCODE = HfBCode.Value.Trim(); insert.BNAME = TxtPersonName.Text.Trim().ToUpper(); insert.BADD = TxtAddress1.Text.Trim().ToUpper(); insert.BADD2 = ""; insert.BADD3 = ""; insert.PHONE_O = TxtPhoneO.Text.Trim().ToUpper(); insert.PHONE_M = TxtPhoneM.Text.Trim().ToUpper(); insert.ACODE = "0"; insert.PER = "0"; insert.ACTIVE = DdlActive.SelectedValue.Trim().ToUpper(); 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 = BROKER_MASLogicLayer.InsertBROKERDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "PERSON 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 = "PERSON CODE ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : PERSON DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } } } catch (Exception) { throw; } }
protected void btnSave_Click(object sender, EventArgs e) { try { #region INSERT _ UPDATE VALUE HfCompCode.Value = Session["COMP_CODE"].ToString(); BROKER_MASLogicLayer insert = new BROKER_MASLogicLayer(); insert.COMP_CODE = HfCompCode.Value; insert.BRANCH_CODE = DdlBranch.SelectedValue.Trim().ToUpper(); insert.BCODE = HfBCode.Value.Trim(); insert.BNAME = TxtPersonName.Text.Trim().ToUpper(); insert.BADD = TxtAddress1.Text.Trim().ToUpper(); insert.BADD2 = ""; insert.BADD3 = ""; insert.PHONE_O = TxtPhoneO.Text.Trim().ToUpper(); insert.PHONE_M = TxtPhoneM.Text.Trim().ToUpper(); insert.ACODE = "0"; insert.PER = "0"; insert.ACTIVE = DdlActive.SelectedValue.Trim().ToUpper(); 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 = BROKER_MASLogicLayer.InsertBROKERDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "PERSON 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 = "PERSON CODE ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : CONTACT DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } else { string str = BROKER_MASLogicLayer.UpdateBROKERDetails(insert); if (str.Contains("successfully")) { lblmsg.Text = "PERSON DETAIL UPDATE SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(Session["COMP_CODE"].ToString()); UserRights(); } else if (str.Contains("Already")) { lblmsg.Text = "PERSON CODE ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : PERSON DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } } catch (Exception) { throw; } }