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;
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)
{
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;
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 btnUpload_Click(object sender, EventArgs e)
{
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;
}
else
{
if (!SecurityValidation.SizeUploadValidation(fupData))
{
lblStatusHeading.Text = "File Upload : Failed";
lblStatus.Text = "Please upload file less than 5MB";
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;
}
//check - file length
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}", username.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_ACTDCT_ACCNO, VAR_ACTDCT_VCID, VAR_ACTDCT_REASON, VAR_ACTDCT_LCOCODE,var_actdct_action,VAR_ACTDCT_FILENAME constant \"" + file_name + "\",VAR_ACTDCT_FILEUNIQUEID constant \"" + upload_id + "\")";
string uploadResult = helper.cDataUpload("D:\\DataUpload\\HathwayBulk\\" + username + "\\" + fupData.PostedFile.FileName,
"D:\\DataUpload\\HathwayBulk\\" + username + "\\HathwayBulkActDctCTL.txt",
"D:\\DataUpload\\HathwayBulk\\" + username + "\\HathwayBulkActDctLOG.log",
table_columns, "Upassdb", "UPASS", "cba", "aoup_lcopre_Bulk_act_dct_Raw", ""
);
if (uploadResult == "0")
{
callprocedureTemp();
}
else
{
if (uploadResult == "")
{
lblStatus.Text = "Error While Uploading...";
}
else
{
lblStatus.Text = uploadResult.ToString();
}
}
}
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)
{
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)
{
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 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);
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
//clearing
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;
}
}
//check - file length
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/HathwayAutoRenewal/{0}", username.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;
string table_columns = "( var_lcopre_ecs_accno, var_lcopre_ecs_vcid,var_lcopre_ecs_plan,var_lcopre_ecs_lcocode,var_lcopre_ecs_flag,DAT_ECS_VALIDUPTO)";
string uploadResult = helper.cDataUpload("D:\\DataUpload\\HathwayAutoRenewal\\" + username + "\\" + fupData.PostedFile.FileName,
"D:\\DataUpload\\HathwayAutoRenewal\\" + username + "\\HathwayAutoRenewalCTL.txt",
"D:\\DataUpload\\HathwayAutoRenewal\\" + username + "\\HathwayAutoRenewalLOG.log",
table_columns, "upassdb", "upass", "cba", "aoup_lcopre_ecs_raw", ""
);
if (uploadResult == "0")
{
callprocedureTemp();
}
else
{
if (uploadResult == "")
{
lblStatus.Text = "Error While Uploading...";
}
else
{
lblStatus.Text = uploadResult.ToString();
}
}
}
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 btnUpload_Click(object sender, EventArgs e)
{
if (ddlpin.SelectedItem.ToString() == "-- Select Zip Code --")
{
msgbox("Please Select Zip Code");
return;
}
if (ddlstreet.SelectedItem.ToString() == "-- Select Street --")
{
msgbox("Please Select Street");
return;
}
if (ddllocation.SelectedItem.ToString() == "-- Select Location --")
{
msgbox("Please Select Location");
return;
}
string pincodecode = "";
string areacode = "";
string streetcode = "";
string locationcode = "";
string buildingcode = "";
string pincode = "";
string area = "";
string street = "";
string location = "";
string building = "";
pincodecode = ddlpin.SelectedValue.ToString();
areacode = ddlarea.SelectedValue.ToString();
streetcode = ddlstreet.SelectedValue.ToString();
locationcode = ddllocation.SelectedValue.ToString();
buildingcode = ddlbuilding.SelectedValue.ToString();
pincode = ddlpin.SelectedItem.ToString();
area = ddlarea.SelectedItem.ToString();
street = ddlstreet.SelectedItem.ToString();
location = ddllocation.SelectedItem.ToString();
building = ddlbuilding.SelectedItem.ToString();
//clearing
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;
}
}
//check - file length
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/HathwayAutoRenewal/{0}", username.Trim());
//string filePath = directoryPath + "/" + fupData.PostedFile.FileName;
//try
//{
// if (!Directory.Exists(directoryPath))
// {
// Directory.CreateDirectory(directoryPath);
// }
// fupData.SaveAs(filePath);
//}
string directoryPath = string.Format(@"D:/DataUpload/Hathway/{0}", username.Trim());
//string directoryPath = string.Format(@"E:/DataUpload/Hathway/{0}", username.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();
Unique_id = username + "_" + cur_time + "_" + random.Next(1000, 9999);
ViewState["upload_id"] = Unique_id;
string table_columns = "( VAR_CUST_STB, VAR_CUST_VC,VAR_CUST_APPLICANTTITLE,VAR_CUST_APPLICANTFIRSTNM,VAR_CUST_APPLICANTMEDDILNM,VAR_CUST_APPLICANTLASTNM,";
table_columns += " VAR_CUST_MOBILENO,VAR_CUST_LANDLINE,VAR_CUST_EMAIL,VAR_CUST_FLATNO,VAR_CUST_ADDRESS1,VAR_CUST_CITY,var_cust_planname,VAR_CUST_ZIPCODE constant \"" + pincodecode + "\",VAR_CUST_AREA constant \"" + area + "\",";
table_columns += " VAR_CUST_AREACODE constant \"" + areacode + "\",VAR_CUST_STREET constant \"" + street + "\",VAR_CUST_LOCATION constant \"" + location + "\",VAR_CUST_BUILDING constant \"" + building + "\",VAR_CUST_UNIQUNO constant \"" + Unique_id + "\",VAR_CUST_LCOCODE constant \"" + username + "\",var_cust_state constant \"" + ViewState["State"] + "\")";
string uploadResult = helper.cDataUpload("D:\\DataUpload\\Hathway\\" + username + "\\" + fupData.PostedFile.FileName,
"D:\\DataUpload\\Hathway\\" + username + "\\HathwayBulkEcafCTL.txt",
"D:\\DataUpload\\Hathway\\" + username + "\\HathwayBulkEcafLOG.log",
table_columns, "UPASSDB", "UPASS", "cba", "aoup_crf_cust_bulk_Raw", ""
);
if (uploadResult == "0")
{
callprocedureTemp();
Response.Redirect("../Reports/frmMeddleBulkTransaction.aspx?uniqueid=" + Unique_id.Trim());
}
else
{
if (uploadResult == "")
{
lblStatus.Text = "Error While Uploading...";
}
else
{
lblStatus.Text = uploadResult.ToString();
}
}
}
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;
}
}
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 btnUpload_Click(object sender, EventArgs e)
{
//clearing
lblStatusHeading.Text = "";
lblStatus.Text = "";
// btnBeginTrans.Visible = false;
pnlErrData.Visible = false;
if (ViewState["Bulk"].ToString() == "C")
{
change.Visible = true;
}
else
{
Operation.Visible = true;
}
// pnlSummary.Visible = false;
DataTable temp = new DataTable();
rptErrData.DataSource = temp;
rptErrData.DataBind();
temp.Dispose();
string file_name = "";
//check - file selected
if (!fupData.HasFile)
{
lblStatusHeading.Text = "File Upload : Failed";
lblStatus.Text = "Select non-empty tab deliminated file first and try again";
return;
}
else
{
if (!SecurityValidation.SizeUploadValidation(fupData))
{
lblStatusHeading.Text = "File Upload : Failed";
lblStatus.Text = "Please upload file less than 5MB";
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;
}
//check - file length
if (fupData.PostedFile.ContentLength == 0)
{
lblStatusHeading.Text = "File Upload : Failed";
lblStatus.Text = "File does not have contents";
return;
}
if (Session["username"] != null)
{
username = ddlLco.SelectedValue;//Session["username"].ToString().Trim();
}
//check - directory and save file in diectory
string directoryPath = string.Format(@"D:/DataUpload/Hathway/{0}", username.Trim());
//string directoryPath = string.Format(@"E:/DataUpload/Hathway/{0}", username.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();
// btnBeginTrans.Visible = false;
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_lcopre_bulk_custid, var_lcopre_bulk_vcid, var_lcopre_bulk_lcocode, var_lcopre_bulk_planname, var_lcopre_bulk_action, var_lcopre_bulk_ecs_flag ,var_lcopre_bulk_insby constant \"" + username + "\", var_lcopre_bulk_useruniqueid constant \"" + upload_id + "\", dat_lcopre_bulk_date constant \"" + cur_timestamp + "\", var_lcopre_bulk_file constant \"" + file_name + "\",var_two_step_proc_flag constant \"" + "Y" + "\",var_lcopre_bulk_new_planname,var_lcopre_bulk_foc_1,var_lcopre_bulk_foc_2,var_lcopre_bulk_foc_3)";
string uploadResult = helper.cDataUpload("D:\\DataUpload\\Hathway\\" + username + "\\" + fupData.PostedFile.FileName,
"D:\\DataUpload\\Hathway\\" + username + "\\HathwayCTL.txt",
"D:\\DataUpload\\Hathway\\" + username + "\\HathwayLOG.log",
table_columns, "upassdb", "upass", "cba", "aoup_lcopre_bulk_upload_raw",
upload_id);
if (uploadResult == "0")
{
Response.Redirect("../Reports/frmMiddlePageBulkTransaction.aspx?uniqueid=" + upload_id);
// callprocedure();
}
else
{
if (uploadResult == "")
{
lblStatus.Text = "Error While Uploading...";
}
else
{
lblStatus.Text = uploadResult.ToString();
}
}
}
