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