protected void loadbasicplan() { string username = Session["username"].ToString(); string where_str = ""; DataSet ds; if (chkaddmap.Checked) { where_str = " where num_plan_cityid='" + ddladdcity.SelectedValue.ToString() + "' and var_plan_plantype='B'"; ds = Cls_Helper.Comboupdate(" aoup_lcopre_lcoplan_def " + where_str + " group by num_plan_plantypeid,var_plan_name ORDER BY var_plan_name", "num_plan_plantypeid", "var_plan_name"); ddladdplan.DataSource = ds; ddladdplan.DataTextField = "var_plan_name"; ddladdplan.DataValueField = "num_plan_plantypeid"; ddladdplan.DataBind(); ddladdplan.Dispose(); } else { where_str = " where num_plan_cityid='" + ddladdcity.SelectedValue.ToString() + "' and var_plan_plantype in('AD','GAD','RAD')"; ds = Cls_Helper.Comboupdate(" aoup_lcopre_lcoplan_def " + where_str + " group by var_plan_name ORDER BY var_plan_name", "0", "var_plan_name"); ddladdplan.DataSource = ds; ddladdplan.DataTextField = "var_plan_name"; ddladdplan.DataValueField = "var_plan_name"; ddladdplan.DataBind(); ddladdplan.Dispose(); } }
protected void loadState() { DataSet dsStates = Cls_Helper.Comboupdate("AOUP_LCOPRE_STATE_DEF", "NUM_STATE_ID", "VAR_STATE_NAME"); ddlState.DataSource = dsStates; ddlState.DataTextField = "VAR_STATE_NAME"; ddlState.DataValueField = "NUM_STATE_ID"; ddlState.DataBind(); ddlState.Items.Insert(0, new ListItem("-- Select State --", "")); }
protected void loadLCOState() { DataSet dsStates = Cls_Helper.Comboupdate("AOUP_LCOPRE_STATE_DEF WHERE VAR_PLAN_COMPANYCODE='HWP' and num_state_id='" + ViewState["state"].ToString() + "' ORDER BY VAR_STATE_NAME", "NUM_STATE_ID", "VAR_STATE_NAME"); ddlState.DataSource = dsStates; ddlState.DataTextField = "VAR_STATE_NAME"; ddlState.DataValueField = "NUM_STATE_ID"; ddlState.DataBind(); dsStates.Dispose(); }
protected void loadCity() { DataSet dsStates = Cls_Helper.Comboupdate(" aoup_lcopre_city_def WHERE var_city_companycode='HWP' and var_city_name='" + ViewState["city"].ToString() + "' order by var_city_name asc", "num_city_id", "var_city_name"); ddlCity.DataSource = dsStates; ddlCity.DataTextField = "var_city_name"; ddlCity.DataValueField = "num_city_id"; ddlCity.DataBind(); ddlCity.Dispose(); //ddlCity.Items.Insert(0, new ListItem("Select City", "0")); }
protected void loadState() { DataSet dsStates = Cls_Helper.Comboupdate(" AOUP_LCOPRE_STATE_DEF WHERE VAR_PLAN_COMPANYCODE='HWP' and var_state_name='" + ViewState["state"].ToString() + "' order by VAR_STATE_NAME asc", "NUM_STATE_ID", "VAR_STATE_NAME"); ddlState.DataSource = dsStates; ddlState.DataTextField = "VAR_STATE_NAME"; ddlState.DataValueField = "NUM_STATE_ID"; ddlState.DataBind(); dsStates.Dispose(); // ddlState.Items.Insert(0, new ListItem("Select State", "0")); }
protected void loadCity() { string where_str = " WHERE num_city_stateid='" + ViewState["stateid"].ToString() + "'"; DataSet ds = Cls_Helper.Comboupdate("aoup_lcopre_city_def " + where_str + " ORDER BY var_city_name asc", "num_city_id", "var_city_name"); ddlCity.DataSource = ds; ddlCity.DataTextField = "var_city_name"; ddlCity.DataValueField = "num_city_id"; ddlCity.DataBind(); ddlCity.Items.Insert(0, new ListItem("All", "")); }
protected void loadState() { DataSet dsStates = Cls_Helper.Comboupdate("AOUP_LCOPRE_STATE_DEF WHERE VAR_PLAN_COMPANYCODE='HWP' ORDER BY VAR_STATE_NAME", "NUM_STATE_ID", "VAR_STATE_NAME"); ddlState.DataSource = dsStates; ddlState.DataTextField = "VAR_STATE_NAME"; ddlState.DataValueField = "NUM_STATE_ID"; ddlState.DataBind(); dsStates.Dispose(); ddlState.Items.Insert(0, new ListItem("Select State", "0")); }
protected void loadLCOcity() { string where_str = " WHERE var_city_companycode='HWP' AND num_city_id='" + ViewState["city"].ToString() + "'"; DataSet ds = Cls_Helper.Comboupdate(" aoup_lcopre_city_def " + where_str + " ORDER BY var_city_name", "num_city_id", "var_city_name"); ddlCity.DataSource = ds; ddlCity.DataTextField = "var_city_name"; ddlCity.DataValueField = "num_city_id"; ddlCity.DataBind(); ddlCity.Dispose(); }
protected void btnSearch_Click(object sender, EventArgs e) { if (txtLCOSearch.Text.Trim() != "") { lblmsg.Text = ""; string customerId = Request.Form[hfCustomerId.UniqueID]; string customerName = Request.Form[txtLCOSearch.UniqueID]; Cls_BLL_TransHwayLcoPayment obj = new Cls_BLL_TransHwayLcoPayment(); string cat_id = ""; string oper_id = ""; string logged_in_user = ""; if (HttpContext.Current.Session["category"] != null && HttpContext.Current.Session["operator_id"] != null) { cat_id = HttpContext.Current.Session["category"].ToString(); oper_id = HttpContext.Current.Session["operator_id"].ToString(); logged_in_user = HttpContext.Current.Session["username"].ToString(); } string[] responceStr = obj.GetLcoCashpaymentDetails(logged_in_user, txtLCOSearch.Text.Trim(), cat_id, oper_id); if (responceStr.Length != 0) { lblLcoCode.Text = responceStr[0].Trim(); lblLcoName.Text = responceStr[1].Trim(); lblLcoAddr.Text = responceStr[2].Trim(); lblLcoMobno.Text = responceStr[3].Trim(); lblLcoEmail.Text = responceStr[4].Trim(); lblLcoAmt.Text = responceStr[5].Trim(); lblLcoPaymode.Text = (responceStr[6].Trim() == "C") ? "Cash" : ((responceStr[6].Trim() == "Q") ? "Cheque" : ((responceStr[6].Trim() == "DD") ? "Demand Draft" : ((responceStr[6].Trim() == "N") ? "NEFT" : ""))); //(responceStr[6].Trim() == "C") ? "Cash" : ((responceStr[6].Trim() == "Q") ? "Cheque" : ""); ViewState["ReceiptNo"] = responceStr[7].Trim(); DataSet ds = Cls_Helper.Comboupdate("aoup_reasons_def", "num_reason_id", "var_reason_name"); ddlReason.DataSource = ds; ddlReason.DataTextField = "var_reason_name"; ddlReason.DataValueField = "num_reason_id"; ddlReason.DataBind(); ds.Dispose(); ddlReason.Items.Insert(0, "Select Reason"); divdet.Visible = true; } else { msgbox("Invalid Receipt", txtLCOSearch); reset(); return; } } else { msgbox("Please Enter Receipt No.", txtLCOSearch); return; } }
protected void loadaddcity() { string catid = Convert.ToString(Session["category"]); string username = Session["username"].ToString(); string where_str = " WHERE q.var_city_companycode='HWP' and a.num_usermst_cityid = q.num_city_id"; if (catid == "3") { where_str += " AND a.var_usermst_username ='******'"; } DataSet ds = Cls_Helper.Comboupdate(" aoup_lcopre_user_det a, aoup_lcopre_city_def q " + where_str + " group by q.num_city_id,q.var_city_name ORDER BY q.var_city_name", "num_city_id", "var_city_name"); ddladdcity.DataSource = ds; ddladdcity.DataTextField = "var_city_name"; ddladdcity.DataValueField = "num_city_id"; ddladdcity.DataBind(); ddladdcity.Dispose(); }
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) { string state_id = ddlState.SelectedValue.ToString(); if (state_id != "0") { string where_str = " WHERE var_city_companycode='HWP' AND num_city_stateid= " + state_id; DataSet ds = Cls_Helper.Comboupdate(" aoup_lcopre_city_def " + where_str + " ORDER BY var_city_name", "num_city_id", "var_city_name"); ddlCity.DataSource = ds; ddlCity.DataTextField = "var_city_name"; ddlCity.DataValueField = "num_city_id"; ddlCity.DataBind(); ddlCity.Dispose(); } else { ddlCity.Items.Clear(); } ddlCity.Items.Insert(0, new ListItem("Select City", "0")); }
protected void btnSearch_Click(object sender, EventArgs e) { string customerId = Request.Form[hfCustomerId.UniqueID]; string customerName = Request.Form[txtUSERSearch.UniqueID]; if (txtUSERSearch.Text.Trim() != "0") { Cls_BLL_TransHwayLcoPayment obj = new Cls_BLL_TransHwayLcoPayment(); string[] responseStr = obj.getLcodetails(username, txtUSERSearch.Text, RadSearchby.SelectedValue, operid, catid); if (responseStr.Length != 0) { lblCustNo.Text = responseStr[0].Trim(); lblCustName.Text = responseStr[1].Trim(); lblCustAddr.Text = responseStr[2].Trim(); lblmobno.Text = responseStr[3].Trim(); lblEmail.Text = responseStr[4].Trim(); DataSet ds = Cls_Helper.Comboupdate("aoup_bank_def", "num_bank_id", "var_bank_name"); ddlBankName.DataSource = ds; ddlBankName.DataTextField = "var_bank_name"; ddlBankName.DataValueField = "num_bank_id"; ddlBankName.DataBind(); ds.Dispose(); ddlBankName.Items.Insert(0, "Select Bankname"); divdet.Visible = true; } else { msgbox("No Such LCO Found", txtUSERSearch); return; } } else { msgbox("Please Select LCO by code or name", txtUSERSearch); return; } }
//static string type; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["operator_id"] != null) { Session["RightsKey"] = null; rbtnsearch.SelectedIndex = 0; operid = Convert.ToString(Session["operator_id"]); username = Convert.ToString(Session["username"]); catid = Convert.ToString(Session["category"]); reset(); DataSet ds = Cls_Helper.Comboupdate("aoup_bank_def order by var_bank_name asc ", "num_bank_id", "var_bank_name"); ddlBankName.DataSource = ds; ddlBankName.DataTextField = "var_bank_name"; ddlBankName.DataValueField = "num_bank_id"; ddlBankName.DataBind(); ds.Dispose(); ddlBankName.Items.Insert(0, "Select Bankname"); //if (rbtnsearch.SelectedValue == "0") //{ // type = "0"; //} //else //{ // type = "1"; //} } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); } txtChequeBounceDate.Attributes.Add("readonly", "readonly"); } // btnSubmit.Attributes.Add("onclick", "javascript:return dovalid1()"); }
protected void btnSearch_Click(object sender, EventArgs e) { if (rbtnsearch.SelectedValue.ToString() == "1") { if (ddlBankName.SelectedIndex == 0) { msgbox("Please Select Bank Name", ddlBankName); return; } } if (txtLCOSearch.Text.Trim() != "") { string customerId = Request.Form[hfCustomerId.UniqueID]; string customerName = Request.Form[txtLCOSearch.UniqueID]; Cls_BLL_TransHwayLcoPayment obj = new Cls_BLL_TransHwayLcoPayment(); // string[] responseStr = obj.getLcodetails(username, txtLCOSearch.Text.Trim(), RadSearchby.SelectedValue, operid); string loggedInUser = ""; string operator_id = ""; string search_type = ""; if (Session["username"] != null && Session["operator_id"] != null) { loggedInUser = Session["username"].ToString(); operator_id = Session["operator_id"].ToString(); } if (rbtnsearch.SelectedValue == "0") { search_type = "0"; } else { search_type = "1"; } string[] responceStr = obj.GetLcopaymentDetails(loggedInUser, txtLCOSearch.Text.Trim(), catid, operator_id, search_type, ddlBankName.SelectedValue.ToString()); if (responceStr.Length != 0) { lblLcoCode.Text = responceStr[0].Trim(); lblLcoName.Text = responceStr[1].Trim(); lblLcoAddr.Text = responceStr[2].Trim(); lblLcoMobno.Text = responceStr[3].Trim(); lblLcoEmail.Text = responceStr[4].Trim(); lblLcoAmt.Text = responceStr[5].Trim(); lblLcoPaymode.Text = (responceStr[6].Trim() == "C") ? "Cash" : ((responceStr[6].Trim() == "Q") ? "Cheque" : ((responceStr[6].Trim() == "DD") ? "Demand Draft" : ((responceStr[6].Trim() == "N") ? "NEFT" : ""))); lblLcoBank.Text = responceStr[7].Trim(); lblLcoBranch.Text = responceStr[8].Trim(); lblChequeNo.Text = responceStr[9].Trim(); lblChequeDate.Text = responceStr[10].Trim(); ViewState["ReceiptNo"] = responceStr[11].Trim(); DataSet ds = Cls_Helper.Comboupdate("aoup_reasons_def", "num_reason_id", "var_reason_name"); ddlReason.DataSource = ds; ddlReason.DataTextField = "var_reason_name"; ddlReason.DataValueField = "num_reason_id"; ddlReason.DataBind(); ds.Dispose(); ddlReason.Items.Insert(0, "Select Reason"); divdet.Visible = true; DetailsAccordion.SelectedIndex = -1; } else { if (rbtnsearch.SelectedValue.ToString() == "0") { msgbox("Invalid Receipt", txtLCOSearch); return; } else { msgbox("Invalid Cheque/DD No.", txtLCOSearch); return; } } } else { if (rbtnsearch.SelectedValue.ToString() == "0") { msgbox("Please Enter Receipt No.", txtLCOSearch); return; } else if (rbtnsearch.SelectedValue.ToString() == "1") { msgbox("Please Enter Cheque No.", txtLCOSearch); return; } } }