protected void btnSubmit_Click(object sender, EventArgs e) { try { lbSearchMsg.Text = ""; string Unique_id = ""; if (txtUniqueid.Text == "" && ViewState["uniqueid"] == null && Convert.ToString(ViewState["uniqueid"]) == "") { lblerrormsg.Text = "Please Eneter unique Id...."; return; } else { if (txtUniqueid.Text != "") { string valid = SecurityValidation.chkData("T", txtUniqueid.Text); Unique_id = (valid == "") ? txtUniqueid.Text.Trim().ToString() : ""; // Unique_id = txtUniqueid.Text.Trim().ToString(); } else if (ViewState["uniqueid"].ToString() != "") { Unique_id = ViewState["uniqueid"].ToString(); } } SearchbindData(Unique_id); } catch (Exception ex) { Response.Redirect("../errorPage.aspx"); } }
private Hashtable getLedgerParamsData() { string from = txtFrom.Text; string to = txtTo.Text; string search_type = RadSearchby.SelectedValue.ToString(); Session["fromdt"] = txtFrom.Text; Session["todt"] = txtTo.Text; string txtsearch = ""; if (txtsearchpara.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtsearchpara.Text); if (valid == "") { txtsearch = txtsearchpara.Text.ToString().Trim(); } // txtsearch = txtsearchpara.Text.ToString().Trim(); } Session["txtsearch"] = txtsearch.ToString().Trim(); Hashtable htSearchParams = new Hashtable(); htSearchParams.Add("from", from); htSearchParams.Add("to", to); htSearchParams.Add("search", search_type); //added by Rushali htSearchParams.Add("txtsearch", txtsearch); //added by Rushali return(htSearchParams); }
protected void btnSubmit_Click(object sender, EventArgs e) { string blusername = SecurityValidation.chkData("N", txtSearch.Text + "" + txtMobileNo.Text); if (blusername.Length > 0) { msgboxstr(blusername); return; } blusername = SecurityValidation.chkData("T", txtRemark.Text); if (blusername.Length > 0) { msgboxstr(blusername); return; } lblPostInvBalance.Text = Convert.ToString(Convert.ToDouble(lblInvBalance.Text) - Convert.ToDouble(txtAmount.Text)); lblLCOBalance.Text = txtLCOBanalce.Text; lblInventoryBalance.Text = lblInvBalance.Text; lblMovingAmount.Text = txtAmount.Text; lblRemark.Text = txtRemark.Text; if (ValidatePage()) { popupModifyConfirm.Show(); } }
private Hashtable getLedgerParamsData() { string from = txtFrom.Text; string to = txtTo.Text; Session["fromdt"] = txtFrom.Text; Session["todt"] = txtTo.Text; Hashtable htSearchParams = new Hashtable(); htSearchParams.Add("from", from); htSearchParams.Add("to", to); if (txtaccvc.Text.ToString().Trim() != "") { if (rodserch.SelectedValue == "ACC" && txtaccvc.Text.Length < 11) { string valid = SecurityValidation.chkData("N", txtaccvc.Text); if (valid == "") { htSearchParams.Add("accvc", rodserch.SelectedValue); htSearchParams.Add("accvctxt", txtaccvc.Text.Trim()); } else { lblSearchMsg.Text = valid.ToString(); } } else if (rodserch.SelectedValue == "VC") { string valid = SecurityValidation.chkData("T", txtaccvc.Text); if (valid == "") { htSearchParams.Add("accvc", rodserch.SelectedValue); htSearchParams.Add("accvctxt", txtaccvc.Text.Trim()); } else { lblSearchMsg.Text = valid.ToString(); } } } //if (txtaccvc.Text.Trim() != "") //{ // htSearchParams.Add("accvc", rodserch.SelectedValue); // htSearchParams.Add("accvctxt", txtaccvc.Text.Trim()); //} return(htSearchParams); }
private Hashtable getParamsData() { string from = txtFrom.Text; string to = txtTo.Text; Session["fromdt"] = txtFrom.Text; Session["todt"] = txtTo.Text; Hashtable htSearchParams = new Hashtable(); htSearchParams.Add("from", from); htSearchParams.Add("to", to); htSearchParams.Add("State", ddlState.SelectedItem.ToString()); if (ddlState.SelectedValue != "0") { htSearchParams.Add("City", ddlCity.SelectedItem.ToString()); } else { htSearchParams.Add("City", "0"); } htSearchParams.Add("JV", ddlJV.SelectedValue); if (txtLCOCode.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtLCOCode.Text); if (valid == "") { htSearchParams.Add("LCOCode", txtLCOCode.Text); return(htSearchParams); } else { lblSearchMsg.Text = valid.ToString(); return(null); } } else { htSearchParams.Add("LCOCode", ""); return(htSearchParams); } //htSearchParams.Add("LCOCode", txtLCOCode.Text); //return htSearchParams; }
protected void btnSubmit_Click(object sender, EventArgs e) { string blusername = SecurityValidation.chkData("N", txtvcid.Text); if (blusername.Length > 0) { lblSearchMsg.Text = blusername; return; } binddata(); rbALL.Checked = true; }
protected void btnSubmit_Click(object sender, EventArgs e) { string blusername = SecurityValidation.chkData("N", txtCashAmt.Text); if (blusername.Length > 0) { msgbox(blusername, lblCustNo); return; } blusername = SecurityValidation.chkData("T", txtRemark.Text); if (blusername.Length > 0) { msgbox(blusername, lblCustNo); return; } if (ViewState["Allowcitrus"].ToString() == "Y") { if (rdoBill.Checked == false && rdcitrus.Checked == false) { msgbox("Please Select Gateway", lblCustNo); return; } } lblmsg.Text = ""; Cls_Data_Auth auth = new Cls_Data_Auth(); string Ip = auth.GetIPAddress(HttpContext.Current.Request); if (lblCustNo.Text.Trim() == "") { msgbox("Please Select LCO", lblCustNo); return; } else if (txtCashAmt.Text.Trim() == "") { msgbox("Please Enter Amount", txtCashAmt); return; } try { if (Convert.ToInt64(txtCashAmt.Text.Trim()) > Convert.ToInt64(HdnMaxamount.Value)) { msgbox("Please Enter Amount less than or Equal to " + HdnMaxamount.Value, txtCashAmt); return; } } catch { } if (txtRemark.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtRemark.Text); if (valid != "") { lblmsg.Text = valid.ToString(); return; } } btnSubmit.Visible = false; Hashtable ht = new Hashtable(); string loggedInUser; if (Session["username"] != null) { if (Convert.ToString(Session["category"]) == "3") { loggedInUser = Session["username"].ToString(); } else { loggedInUser = ddllco.SelectedValue; //Session["username"].ToString(); } } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } String PaymentFlag = "BD"; if (ViewState["Allowcitrus"].ToString() == "Y") { Tr2.Visible = true; if (rdoBill.Checked == true) { PaymentFlag = "BD"; } else { PaymentFlag = "CT"; } } else { Tr2.Visible = false; PaymentFlag = "BD"; } ht.Add("User", loggedInUser); ht.Add("CustCode", loggedInUser); ht.Add("Amount", Convert.ToInt32(txtCashAmt.Text.Trim())); ht.Add("PayMode", "O"); ht.Add("chequeddno", "N/A"); ht.Add("CheckDate", DateTime.MinValue); ht.Add("BankName", "*"); ht.Add("Branch", "*"); ht.Add("Remark", txtRemark.Text.Trim()); ht.Add("ReceiptNo", "*"); ht.Add("IP", Ip); ht.Add("user_id", Session["user_id"]); ht.Add("user_brmpoid", Session["user_brmpoid"]); ht.Add("operator_id", Session["operator_id"]); ht.Add("category", Session["category"]); ht.Add("name", Session["name"]); ht.Add("last_login", Session["last_login"]); ht.Add("login_flag", Session["login_flag"]); string sessionId = "(S(" + Session.SessionID.ToString() + "))"; ht.Add("Session", sessionId); ht.Add("Identifier", PaymentFlag); ht.Add("CrLimittype", "INV"); Cls_BLL_TransHwayLcoPayment obj = new Cls_BLL_TransHwayLcoPayment(); // string response = obj.LcoPayment(ht); //reset(); string response = ""; Hashtable transreceipt = obj.InverntryOnlinePaymentTransID(ht); int TransID = Convert.ToInt32(transreceipt["Transid"]); //int TransID = obj.LcoOnlinePaymentTransID(ht); if (TransID != 0) { PrjUpassDAL.Helper.Cls_Validation bojValidation = new PrjUpassDAL.Helper.Cls_Validation(); string strTransCode = "HATH";// bojValidation.lcoTransCode(loggedInUser); if (strTransCode.Length > 0) { int TranAmt = Convert.ToInt32(txtCashAmt.Text.Trim()); string RetrnUrl = "http://124.153.73.21/HwayLCOSMSUAT/Transaction/TransHwayInventryOnlinePayRes.aspx"; //string RetrnUrl = "http//124.153.73.21/HwayLCOSMSUAT/Transaction/TransHwayInventryOnlinePayRes.aspx"; // string RetrnUrl = "http://localhost:11772/Transaction/TransHwayInventryOnlinePayRes.aspx"; if (PaymentFlag == "BD") { Response.Redirect("http://124.153.73.21/UbillDesk/Request.aspx?CompanyCode=10001&TransNo=" + TransID + "&Amount=" + TranAmt + "&ReturnURL=" + RetrnUrl + "&AdditionalInfo2=" + strTransCode + "&AdditionalInfo3=" + loggedInUser + "&AdditionalInfo4=" + Convert.ToString(transreceipt["receipt"])); } else { Response.Redirect("http://hathwayconnect.com/UbillDesk/Request.aspx?CompanyCode=20002&TransNo=" + TransID + "&Amount=" + TranAmt + "&ReturnURL=" + RetrnUrl + "&AdditionalInfo2=" + strTransCode + "&AdditionalInfo3=" + loggedInUser + "&AdditionalInfo4=" + Convert.ToString(transreceipt["receipt"])); } } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string from = txtFrom.Text; string to = txtTo.Text; // lblResultCount.Text = ""; Label1.Text = ""; lblSearchMsg.Text = ""; DateTime fromDt; DateTime toDt; if (!String.IsNullOrEmpty(from) && !String.IsNullOrEmpty(to)) { fromDt = new DateTime(); toDt = new DateTime(); fromDt = DateTime.ParseExact(from, "dd-MMM-yyyy", null); toDt = DateTime.ParseExact(to, "dd-MMM-yyyy", null); if (toDt.CompareTo(fromDt) < 0) { lblSearchMsg.Text = "To date must be later than From date"; // grdAddPlantopup.Visible = false; lblSearchMsg.ForeColor = System.Drawing.Color.Red; return; } else if (Convert.ToDateTime(txtFrom.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return; } else if (Convert.ToDateTime(txtTo.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return; } else { lblSearchMsg.Text = ""; // grdAddPlantopup.Visible = true; } } Hashtable htCrf = getCrfParams(); string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } cls_business_rptEcafCust obj = new cls_business_rptEcafCust(); DataTable dt = new DataTable(); Hashtable htResponse; if (chkdt.Checked == true) { htResponse = obj.getCrfdata(username, htCrf); } else if (chkVC.Checked == true) { if (txtVCid.Text == "" || txtVCid.Text == null) { Label1.Text = "VC Id Can't Be Blank"; return; } else { string valid = SecurityValidation.chkData("T", txtVCid.Text); if (valid == "") { htResponse = obj.getCrfVC(username, txtVCid.Text.Trim()); } else { Label1.Text = valid.ToString(); return; } } // htResponse = obj.getCrfVC(username, txtVCid.Text.Trim()); } else { Label1.Text = "Please search by any one of the choice!!"; return; } if (htResponse["data"] != null) { dt = (DataTable)htResponse["data"]; } string strParams = htResponse["ParamStr"].ToString(); if (!String.IsNullOrEmpty(strParams)) { // lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'>Top-up Parameters : </b>" + strParams); lblSearchMsg.Text = Server.HtmlDecode("<b style='color:#094791;'></b>" + strParams); } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } else if (dt.Rows.Count == 0) { Label1.Text = "No Data Found"; divData.Visible = false; } else { xDGr.DataSource = dt; xDGr.DataBind(); divData.Visible = true; dIVtOTgRIDD.Visible = true; dIvGridReport.Visible = false; } }
protected void btnSubmit_Click(object sender, EventArgs e) { string from = txtFrom.Text; string to = txtTo.Text; DateTime fromDt; DateTime toDt; //if (RadSearchby.Items[1].Selected == true ||(txtsearchpara.Text == "")) //{ // Response.Write("<script type=\"text/javascript\">alert('Please Enter VC No.');</script>"); // return; //} if (!String.IsNullOrEmpty(from) && !String.IsNullOrEmpty(to)) { fromDt = new DateTime(); toDt = new DateTime(); fromDt = DateTime.ParseExact(from, "dd-MMM-yyyy", null); toDt = DateTime.ParseExact(to, "dd-MMM-yyyy", null); if (toDt.CompareTo(fromDt) < 0) { lblSearchMsg.Text = "To date must be later than From date"; grdAddPlanSearch.Visible = false; btnAll.Visible = false; lblSearchMsg.ForeColor = System.Drawing.Color.Red; return; } else if (Convert.ToDateTime(txtFrom.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return; } else if (Convert.ToDateTime(txtTo.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return; } else { lblSearchMsg.Text = ""; grdAddPlanSearch.Visible = true; btnAll.Visible = true; } } Hashtable htAddPlanParams = getAddPlanParamsData(); string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } string search_type = RadSearchby.SelectedValue.ToString(); Session["search"] = search_type.ToString().Trim(); string txtsearch = ""; if (txtsearchpara.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtsearchpara.Text); if (valid == "") { txtsearch = txtsearchpara.Text.ToString().Trim(); } else { lblSearchMsg.Text = valid.ToString(); btnAll.Visible = false; return; } } Session["txtsearch"] = txtsearch.ToString().Trim(); if (catid == "3") { Session["lcoid"] = operator_id.ToString(); Session["lconame"] = "All"; Session["showall"] = "1"; Response.Redirect("../Reports/rptAddPlanTransUSER_JV.aspx");//?lcoid=" + operator_id.ToString());// + "'" + "lcoid=" + operator_id.ToString()); } if (catid == "11") { Session["msoid"] = operator_id.ToString(); Session["msoname"] = "All"; Session["showall"] = "1"; Response.Redirect("../Reports/rptAddPlanTransLCO_JV.aspx"); } if (catid == "2") { Session["msoid"] = operator_id.ToString(); Session["msoname"] = "All"; Session["showall"] = "1"; Response.Redirect("../Reports/rptAddPlanTransLCO_JV.aspx"); } if (catid != "0" && catid != "10") { Cls_Business_RptAddPlan_JV objTran = new Cls_Business_RptAddPlan_JV(); Hashtable htResponse = objTran.GetTransationsMSO(htAddPlanParams, username, catid, operator_id); DataTable dt = null; if (htResponse["htResponse"] != null) { dt = (DataTable)htResponse["htResponse"]; } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } //showing parameters string strParams = htResponse["ParamStr"].ToString(); if (!String.IsNullOrEmpty(strParams)) { // lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'>Transaction Parameters : </b>" + strParams); lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'> </b>" + strParams); } if (dt.Rows.Count == 0) { grdAddPlanSearch.Visible = false; btnAll.Visible = false; lblSearchMsg.Text = "No data found"; btn_genExl.Visible = false; } else { btn_genExl.Visible = true; grdAddPlanSearch.Visible = true; btnAll.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_trans"] = dt; grdAddPlanSearch.DataSource = dt; grdAddPlanSearch.DataBind(); htResponse["htResponse"] = null; dt.Dispose(); } } else if (catid == "0" || catid == "10") { ExportExcel(from, to); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (Session["username"] != null || Session["operator_id"] != null) { string username = Convert.ToString(Session["username"]); string catid = Convert.ToString(Session["category"]); string operator_id = Convert.ToString(Session["operator_id"]); Hashtable ht = new Hashtable(); /*string code = lblLCOCode.Text; * ht["code"] = code;*/ string lcoid2 = ViewState["lcoid2"].ToString(); ht["lcoid2"] = lcoid2; string userlevel = ""; if (catid == "3") { userlevel = "E"; } else { userlevel = "M"; } ht["userlevel"] = userlevel; if (txtUserId.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtUserId.Text); if (valid == "") { ht["userid12"] = txtUserId.Text; } else { lblResponseMsg.Text = valid + " at Login ID"; return; } } if (txtFirstName.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtFirstName.Text); if (valid == "") { ht["fname"] = txtFirstName.Text; } else { lblResponseMsg.Text = valid + " at First Name"; return; } } if (txtMidName.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtMidName.Text); if (valid == "") { ht["mname"] = txtMidName.Text; } else { lblResponseMsg.Text = valid + " at Middle Name"; return; } } if (txtLastName.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtLastName.Text); if (valid == "") { ht["lname"] = txtLastName.Text; } else { lblResponseMsg.Text = valid + " at Last Name"; return; } } if (txtMobile.Text.Length > 0) { string valid = SecurityValidation.chkData("N", txtMobile.Text); if (valid == "") { ht["mobileno"] = txtMobile.Text; } else { lblResponseMsg.Text = valid + " at Mobile"; return; } } if (txtEmail.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtEmail.Text); if (valid == "") { ht["email"] = txtEmail.Text; } else { lblResponseMsg.Text = valid + " at Email"; return; } } //string userid1 = txtUserId.Text; //ht["userid12"] = userid1; string userowner = ""; ht["userowner"] = userowner; //string fname = txtFirstName.Text; //ht["fname"] = fname; //string mname = txtMidName.Text; //ht["mname"] = mname; //string lname = txtLastName.Text; //ht["lname"] = lname; string jv = "0"; string direct = "0"; jv = txtJvNo.Text; direct = txtDirectNo.Text; ht["jv"] = jv; ht["direct"] = direct; string brmpoid = txtBrmId.Text; ht["brmpoid"] = brmpoid; string accno = txtAccNO.Text; ht["accno"] = accno; string addr = txtAddress.Text; ht["addr"] = addr; string state = ddlState.SelectedValue.ToString(); if (catid != "3") { if (state == "0") { lblResponseMsg.Text = "Select State"; return; } } ht["state"] = state; string city = ddlCity.SelectedValue.ToString(); if (catid != "3") { if (city == "0") { lblResponseMsg.Text = "Select City"; return; } } ht["city"] = city; string pincode = txtPincode.Text; ht["pincode"] = pincode; //string mobileno = txtMobile.Text; //ht["mobileno"] = mobileno; //string email = txtEmail.Text; //ht["email"] = email; if (ViewState["userid1"] != null) { ht["userid1"] = Convert.ToString(ViewState["userid1"]); } else { ht["userid1"] = "0"; } /*if (ViewState["lcoid"] != null) * { * ht["lcoid"] = Convert.ToString(ViewState["lcoid"]); * } * else * { * ht["lcoid"] = "0"; * }*/ if (ViewState["flag"] != null) { ht["flag"] = Convert.ToString(ViewState["flag"]); } else { ht["flag"] = "0"; } Cls_Business_MstLCOPreUDefine obj = new Cls_Business_MstLCOPreUDefine(); string compcode = ""; if (Session["username"] != null) { username = Convert.ToString(Session["username"]); compcode = Convert.ToString(Session["opr_code"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); } ht["compcode"] = "HWP";//compcode; string response = obj.setUserData(username, ht); reset(); if (response == "ex_occured") { //exception occured Response.Redirect("~/ErrorPage.aspx"); return; } else { lblResponseMsg.Text = response; } } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); } }
protected void binddata() { string search_type = RadSearchby.SelectedValue.ToString(); try { string strCon = ConfigurationSettings.AppSettings["conString"].ToString().Trim(); OracleConnection con = new OracleConnection(strCon); string str = ""; str = "select * from view_lcopre_custmast_rpt a "; string valid = ""; if (search_type == "0" && txtsearchpara.Text.Length < 11) { valid = SecurityValidation.chkData("N", txtsearchpara.Text); if (valid == "") { str += " where a.account_no= '" + txtsearchpara.Text.ToString() + "'"; } else { lblSearchMsg.Text = valid.ToString(); } } else if (search_type == "1") { valid = SecurityValidation.chkData("T", txtsearchpara.Text); if (valid == "") { str += " where a.vc= '" + txtsearchpara.Text.ToString() + "'"; } else { lblSearchMsg.Text = valid.ToString(); } } else if (search_type == "2") { valid = SecurityValidation.chkData("T", txtsearchpara.Text); if (valid == "") { str += " where a.lco_code= '" + txtsearchpara.Text.ToString() + "'"; } else { lblSearchMsg.Text = valid.ToString(); } } DataTable DtObj = new DataTable(); OracleCommand Cmd = new OracleCommand(str, con); OracleDataAdapter DaObj = new OracleDataAdapter(Cmd); DaObj.Fill(DtObj); if (search_type != "2") { if (DtObj.Rows.Count == 0) { btnGenerateExcel.Visible = false; grdtransdet.Visible = false; lblSearchMsg.Text = "No data found"; } else { btnGenerateExcel.Visible = true; grdtransdet.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_Details"] = DtObj; grdtransdet.DataSource = DtObj; grdtransdet.DataBind(); ScriptManager.RegisterStartupScript(Page, this.GetType(), "Key", "<script>MakeStaticHeader('" + grdtransdet.ClientID + "', 400, 1200 , 46 ,false); </script>", false); DivRoot.Style.Add("display", "block"); } } else { } } catch (Exception ex) { Response.Write("Error : " + ex.Message.Trim()); return; } }
protected void btnSearch_Click(object sender, EventArgs e) { string blusername = SecurityValidation.chkData("N", txtaccno.Text); if (blusername.Length > 0) { lblmessage.Text = blusername; return; } lblbillno.Visible = true; Label2.Visible = true; ddlbillno.Visible = true; btnpdf.Visible = true; string acc_no = txtaccno.Text.ToString().Trim(); string url = sendcommandforErrorDetails(acc_no); // string url = @"{""BillDetails"":[{""billID"":""HW_BMP-100001989"",""billDate"":""01-Sep-2015""},{""billID"":""HW_BMP-100002089"",""billDate"":""01-Nov-2015""},{""billID"":""HW_BMP-100003089"",""billDate"":""16-Dec-2015""}]}"; var queryString = url.Remove(0, 16); queryString = queryString.Substring(0, queryString.Length - 2); var temp = queryString.Replace("\"", string.Empty); string[] array = temp.Split('}'); string str = "";; List <string> values = new List <string>(); ddlbillno.Items.Clear(); for (int i = 0; i <= array.Length - 1; i++) { if (array[i] != "") { string strsubchar = array[i].Substring(0, 2); if (strsubchar == "{b") { str = array[i].Replace("{billID:", ""); str = str.Replace("billDate:", ""); str = str.Replace(",", "("); str = str + ")"; } else if (strsubchar == ",{") { str = array[i].Replace(",{billID:", ""); str = str.Replace("billDate:", ""); str = str.Replace(",", "("); str = str + ")"; } values.Add(str); } } ddlbillno.DataSource = values; ddlbillno.DataBind(); ddlbillno.Items.Insert(0, "Select Billno"); //List<string> values = new List<string>(); //List<string> values1 = new List<string>(); //foreach (string a in array) //{ // foreach (string b in array) // { // string s = "HW_BMP"; // string ori = a.Remove(0, 8); // string q = "billDate"; // string date1 = b.Substring(9, 11); // if (ori.Contains(s)) // { // string value = ori+ "(" + date1 + ")"; // values.Add(value); // } // } //} // ddlbillno.DataSource = values; //ddlbillno.DataBind(); }
protected void btnUpload_Click(object sender, EventArgs e) { if (rblMode.SelectedValue == "0") { if (txtAccountNo.Text.Length > 0) { string valid = SecurityValidation.chkData("N", txtAccountNo.Text); if (valid == "") { String IPAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (IPAddress == null) { IPAddress = Request.ServerVariables["REMOTE_ADDR"]; } string IPAdd = Convert.ToString(IPAddress); Cls_Business_UserAccountMap obj = new Cls_Business_UserAccountMap(); string pro_output = obj.UserAccountMap(Session["username"].ToString().Trim(), IPAdd, ddlLco.SelectedValue, txtAccountNo.Text, rblAction.SelectedValue.ToString(), "S"); if (pro_output.Split('#')[0] == "9999") { lblStatusHeading.Text = "Successful"; lblStatus.Text = ""; } else { lblStatusHeading.Text = pro_output.Split('#')[1].ToString();// "File Upload : Failed"; } txtAccountNo.Text = ""; ddlLco.SelectedIndex = 0; rblAction.SelectedValue = "Y"; } else { lblStatusHeading.Text = valid.ToString(); return; } } } else { lblStatusHeading.Text = ""; lblStatus.Text = ""; DataTable temp = new DataTable(); temp.Dispose(); string file_name = ""; if (!fupData.HasFile) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Select non-empty tab deliminated file first and try again"; return; } //check - file extension if (fupData.PostedFile.ContentType != "text/plain") { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Only tab deliminated text(.txt) files are allowed"; return; } else { if (!SecurityValidation.SizeUploadValidation(fupData)) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Please upload file less than 5MB"; return; } } if (fupData.PostedFile.ContentLength == 0) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "File does not have contents"; return; } //check - directory and save file in diectory string directoryPath = string.Format(@"D:/DataUpload/HathwayBulk/{0}", Session["username"].ToString().Trim()); string filePath = directoryPath + "/" + fupData.PostedFile.FileName; try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } fupData.SaveAs(filePath); } catch (Exception ex) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = ex.Message.ToString(); return; } Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); file_name = fupData.PostedFile.FileName; Random random = new Random(); upload_id = username + "_" + cur_time + "_" + random.Next(1000, 9999); ViewState["upload_id"] = upload_id; string table_columns = "( var_user_acc_username, var_user_acc_accountno, Var_user_acc_activeflag)"; string uploadResult = helper.cDataUpload("D:\\DataUpload\\HathwayBulk\\" + Session["username"].ToString().Trim() + "\\" + fupData.PostedFile.FileName, "D:\\DataUpload\\HathwayBulk\\" + Session["username"].ToString().Trim() + "\\HathwayUserAccMappingCTL.txt", "D:\\DataUpload\\HathwayBulk\\" + Session["username"].ToString().Trim() + "\\HathwayUserAccMappingLOG.log", table_columns, "Upassdb", "UPASS", "cba", "AOUP_LCOPRE_USER_ACC_MAP_raw", "" ); if (uploadResult == "0") { callprocedureTemp(); } else { if (uploadResult == "") { lblStatus.Text = "Error While Uploading..."; lblStatus.Visible = true; } else { lblStatus.Text = uploadResult.ToString(); lblStatus.Visible = true; } } } }
private DataTable getData() { try { string search_type = RadSearchby.SelectedValue.ToString(); string strCon = ConfigurationSettings.AppSettings["conString"].ToString().Trim(); string from = txtFrom.Text; string to = txtTo.Text; DateTime fromDt; DateTime toDt; if (!String.IsNullOrEmpty(from) && !String.IsNullOrEmpty(to)) { fromDt = new DateTime(); toDt = new DateTime(); fromDt = DateTime.ParseExact(from, "dd-MMM-yyyy", null); toDt = DateTime.ParseExact(to, "dd-MMM-yyyy", null); if (toDt.CompareTo(fromDt) < 0) { lblSearchMsg.Text = "To date must be later than From date"; lblSearchMsg.ForeColor = System.Drawing.Color.Red; return(null); } else if (Convert.ToDateTime(txtFrom.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return(null); } else if (Convert.ToDateTime(txtTo.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return(null); } OracleConnection con = new OracleConnection(strCon); string str = ""; str = "select " + hdnslctcolumns.Value + " from view_lcopre_notification_sent a where 0=0 "; str += @" and a.""Lco Code""= '" + ddlLco.SelectedValue + "' "; if (txtsearchpara.Text.Length > 0) { if (search_type == "0" && txtsearchpara.Text.Length < 11) { string valid = SecurityValidation.chkData("N", txtsearchpara.Text); if (valid == "") { str += @" and a.""Account No""= '" + txtsearchpara.Text + "' "; } else { lblSearchMsg.Text = valid.ToString(); return(null); } // str += @" and a.""Account No""= '" + txtsearchpara.Text + "' "; } else if (search_type == "1") { string valid = SecurityValidation.chkData("T", txtsearchpara.Text); if (valid == "") { str += @" and a.""VC/MAC Id""= '" + txtsearchpara.Text + "'"; } else { lblSearchMsg.Text = valid.ToString(); return(null); } // str += @" and a.""VC/MAC Id""= '" + txtsearchpara.Text + "'"; } } str += " and trunc(a.INSDT) >= '" + from + "' and trunc(a.INSDT) <= '" + to + "'"; if (ddlType.SelectedValue != "0") { str += @" and a.""Type""='" + ddlType.SelectedValue + "'"; } if (ddlLco.SelectedValue != "0") { str += @" and upper(a.""Lco Code"")= upper('" + ddlLco.SelectedValue.ToString().Trim() + "') "; } DataTable DtObj = new DataTable(); OracleCommand Cmd = new OracleCommand(str, con); OracleDataAdapter DaObj = new OracleDataAdapter(Cmd); DaObj.Fill(DtObj); return(DtObj); } return(null); } catch (Exception ex) { return(null); } }
private DataTable binddata() { btnGenerateExcel.Visible = false; string search_type = RadSearchby.SelectedValue.ToString(); string from = txtFrom.Text; string to = txtTo.Text; DateTime fromDt; DateTime toDt; if (!String.IsNullOrEmpty(from) && !String.IsNullOrEmpty(to)) { fromDt = new DateTime(); toDt = new DateTime(); fromDt = DateTime.ParseExact(from, "dd-MMM-yyyy", null); toDt = DateTime.ParseExact(to, "dd-MMM-yyyy", null); if (toDt.CompareTo(fromDt) < 0) { lblSearchMsg.Text = "To date must be later than From date"; grdAddPlantopup.Visible = false; lblSearchMsg.ForeColor = System.Drawing.Color.Red; return(null); } else if (Convert.ToDateTime(txtFrom.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return(null); } else if (Convert.ToDateTime(txtTo.Text.ToString()) > DateTime.Now.Date) { lblSearchMsg.Text = "You can not select date greater than current date!"; return(null); } else { lblSearchMsg.Text = ""; grdAddPlantopup.Visible = true; } } Hashtable htTopupParams = getTopupParamsData(); string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return(null); } string ConStr = ConfigurationSettings.AppSettings["ConString"].ToString().Trim(); OracleConnection ConObj = new OracleConnection(ConStr); DataTable DtObj = new DataTable(); string StrQry = @"SELECT a.""ACCOUNT NO"", a.vcid, a.""CUSTOMER NAME"", a.""NOTIFICATION TYPE"", a.message, a.frequency,"; StrQry += @"a.duration, a.position, case when a.action='I' then 'Include' else 'Exclude' end Action, a.""INSERTED BY"",REFERENCEID, "; StrQry += @"a.""INSERTED DATE"" FROM view_lcopre_notification_rpt a where "; StrQry += " trunc(a.dt) >= '" + from + "' and trunc(a.dt) <= '" + to + "'"; if (ddlType.SelectedValue != "0") { StrQry += @" and a.""NOTIFICATION TYPE""='" + ddlType.SelectedValue + "'"; } if (ddlLco.SelectedValue != "0") { StrQry += @" and a.""INSERTED BY""='" + ddlLco.SelectedValue.ToString().Trim() + "'"; } if (txtsearchpara.Text.ToString().Trim() != "") { if (search_type == "0" && txtsearchpara.Text.Length < 11) { string valid = SecurityValidation.chkData("N", txtsearchpara.Text); if (valid == "") { StrQry += @" and a.""ACCOUNT NO""= '" + txtsearchpara.Text.ToString() + "'"; } else { lblSearchMsg.Text = valid.ToString(); return(null); } } else if (search_type == "1") { string valid = SecurityValidation.chkData("T", txtsearchpara.Text); if (valid == "") { StrQry += @" and a.VCID= '" + txtsearchpara.Text.ToString() + "'"; } else { lblSearchMsg.Text = valid.ToString(); return(null); } } } OracleCommand Cmd = new OracleCommand(StrQry, ConObj); OracleDataAdapter DaObj = new OracleDataAdapter(Cmd); DaObj.Fill(DtObj); if (DtObj.Rows.Count == 0) { grdAddPlantopup.Visible = false; lblSearchMsg.Text = "No data found"; } else { grdAddPlantopup.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_trans"] = DtObj; grdAddPlantopup.DataSource = DtObj; grdAddPlantopup.DataBind(); btnGenerateExcel.Visible = true; return(DtObj); } return(null); }
protected void btnSearch_Click(object sender, EventArgs e) { if (txtsearchpara.Text.Length > 0) { string valid = SecurityValidation.chkData("N", txtsearchpara.Text); if (valid == "") { string from = txtFrom.Text; string to = txtTo.Text; DateTime fromDt; DateTime toDt; if (!String.IsNullOrEmpty(from) && !String.IsNullOrEmpty(to)) { fromDt = new DateTime(); toDt = new DateTime(); fromDt = DateTime.ParseExact(from, "dd-MMM-yyyy", null); toDt = DateTime.ParseExact(to, "dd-MMM-yyyy", null); // DateTime fromDt; // DateTime toDt; Double dateDiff = 0; if (!String.IsNullOrEmpty(from) && !String.IsNullOrEmpty(to)) { fromDt = new DateTime(); toDt = new DateTime(); fromDt = DateTime.ParseExact(from, "dd-MMM-yyyy", null); toDt = DateTime.ParseExact(to, "dd-MMM-yyyy", null); dateDiff = (toDt - fromDt).TotalDays; } if (toDt.CompareTo(fromDt) < 0) { lblmsg.Text = "To date must be later than From date"; GridCompList.Visible = false; lblmsg.ForeColor = System.Drawing.Color.Red; return; } else if (Convert.ToDateTime(txtFrom.Text.ToString()) > DateTime.Now.Date) { lblmsg.Text = "You can not select date greater than current date!"; return; } else if (Convert.ToDateTime(txtTo.Text.ToString()) > DateTime.Now.Date) { lblmsg.Text = "You can not select date greater than current date!"; return; } else { lblmsg.Text = ""; } } BindGrid(); } else { lblmsg.Text = valid; return; } } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (txtname.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtname.Text); if (valid != "") { lblmsg.Text = valid + " at Name"; return; } } if (txtaddress.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtaddress.Text); if (valid != "") { lblmsg.Text = valid + " at Address"; return; } } if (txtmobno.Text.Length > 0) { string valid = SecurityValidation.chkData("N", txtmobno.Text); if (valid != "") { lblmsg.Text = valid + " at Mobile Number"; return; } } if (txtemailid.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtemailid.Text); if (valid != "") { lblmsg.Text = valid + " at EmailID"; return; } } if (txtcompanyname.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtcompanyname.Text); if (valid != "") { lblmsg.Text = valid + " at Company Name"; return; } } if (txtAlternateno.Text.Length > 0) { string valid = SecurityValidation.chkData("N", txtAlternateno.Text); if (valid != "") { lblmsg.Text = valid + " at Alternate Number"; return; } } if (txtcomplaint.Text.Length > 0) { string valid = SecurityValidation.chkData("T", txtcomplaint.Text); if (valid != "") { lblmsg.Text = valid + " at Complaint"; return; } } string expresion; if (txtemailid.Text == "" || txtemailid.Text == null) { //MessageAlert("Please Enter Proper Customer Email", ""); txtemailid.Focus(); return; } else { expresion = "\\w+([-+.']\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*"; if (Regex.IsMatch(txtemailid.Text, expresion)) { if (Regex.Replace(txtemailid.Text, expresion, string.Empty).Length == 0) { // ch.Email = txtemailid.Text.Trim(); } else { //MessageAlert("Enter valid email", ""); txtemailid.Focus(); return; } } else { //MessageAlert("Enter valid email", ""); txtemailid.Focus(); return; } } if (txtcomplaint.Text != "" && txtcomplaint.Text.Trim() != "") { if (txtcomplaint.Text.Length > 300) { // MessageAlert("Complaint Should Not Be Grather Than 300 Character", ""); txtcomplaint.Focus(); return; } else { //ch.Complaint = TxtComplaint.Text; } } else { //MessageAlert("Please Enter Complaint", ""); txtcomplaint.Focus(); return; } if (ddlcomplainttype.SelectedValue == "0" || ddlcomplainttype.SelectedValue == "") { //MessageAlert("Please Select Complaint Source", ""); ddlcomplainttype.Focus(); return; } else { // ch.ComplaintSource = ddlcomplainttype.SelectedValue.ToString(); } Hashtable ht = new Hashtable(); ht.Add("in_UserId", Session["username"].ToString()); ht.Add("in_CompltMasID", "1"); ht.Add("in_ComplNo", "1"); ht.Add("in_CmpltID", "1"); ht.Add("in_DeptID", "1"); ht.Add("in_AuthorizeUserId", "0"); ht.Add("in_ComplTypeid", ddlcomplainttype.SelectedValue); ht.Add("in_ComplSubTyp", "0"); ht.Add("in_CustomeNM", txtname.Text); ht.Add("in_CustCntNo", txtmobno.Text); ht.Add("in_Complaint", txtcomplaint.Text); ht.Add("in_CurrentStst", "PA"); ht.Add("in_cmplRegDate", DateTime.Now); ht.Add("in_CmplRefId", "0"); ht.Add("in_ComEntryType", "W"); ht.Add("in_SmsCmplID", "0"); ht.Add("in_Mode", "1"); ht.Add("in_Address", txtaddress.Text); ht.Add("in_ComplaintSource", "HC"); ht.Add("in_Email", txtemailid.Text); ht.Add("in_Location", ""); ht.Add("in_lcocode", Session["username"].ToString()); //if (RadSearchby.SelectedValue != "0") //{ // ht.Add("in_cust_account_no", txtAccCustomer.Text); // ht.Add("in_complnt_flag", "C"); //} //else //{ ht.Add("in_cust_account_no", ""); ht.Add("in_complnt_flag", "S"); //} ht.Add("in_callername", ""); ht.Add("in_callerno", ""); ht.Add("in_companyName", txtcompanyname.Text); ht.Add("in_Alternateno", txtAlternateno.Text); Cls_Business_mstComplaintRegistration obj = new Cls_Business_mstComplaintRegistration(); string strresponse = obj.InsertComplaint(ht, Session["username"].ToString()); string[] str = strresponse.Split('$'); if (str[0] != "9999") { lblmsg.Text = str[1]; } else { lblmsg.Text = str[1]; } clear(); }
protected void btnSearch_Click(object sender, EventArgs e) { string blusername = SecurityValidation.chkData("N", txtSearch.Text + "" + txtMobileNo.Text + "" + txtLCOBanalce.Text); if (blusername.Length > 0) { msgboxstr(blusername); return; } blusername = SecurityValidation.chkData("T", txtRemark.Text); if (blusername.Length > 0) { msgboxstr(blusername); return; } lblmsg11.Text = ""; divdet.Visible = false; btnSubmit.Visible = true; txtSearch.Text = Session["username"].ToString(); if (txtSearch.Text.Trim() != "") { Cls_BLL_NEWSTB obj = new Cls_BLL_NEWSTB(); string operator_id = ""; operator_id = Convert.ToString(Session["operator_id"]); string[] responseStr = obj.getLcodetails(Session["username"].ToString(), Session["username"].ToString(), "0", operator_id, "3"); if (responseStr.Length != 0) { lblCustNo.Text = responseStr[0].Trim(); Session["lcoCodeR"] = lblCustNo.Text.Trim(); lblCustName.Text = responseStr[1].Trim(); lblCustAddr.Text = responseStr[2].Trim(); lblmobno.Text = responseStr[3].Trim(); txtMobileNo.Text = responseStr[3].Trim(); lblEmail.Text = responseStr[4].Trim(); lblInvBalance.Text = responseStr[5].Trim(); txtLCOBanalce.Text = responseStr[6].Trim(); divdet.Visible = true; LCOAccordion.Visible = true; LCOAccordion.SelectedIndex = 0; Label32.Text = "LCO Details"; Label4.Text = "LCO Details"; Label1.Text = "LCO Code"; } else { msgboxstr("No Such LCO Found"); LCOAccordion.Visible = false; return; } } else { msgboxstr("Please Enter Code "); LCOAccordion.Visible = false; return; } }