protected void fillCombo() { string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { catid = Convert.ToString(Session["category"]); if (catid == "11") { username = ddllco.SelectedValue.Split('$')[0].ToString(); // Session["username"].ToString(); } else { username = Session["username"].ToString(); } operator_id = Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } Hashtable htAddPlanParams = getLedgerParamsData(); string type = ""; if (rbALL.Checked) { type = "ALL"; } else if (rbAD.Checked) { type = "AD"; } else if (rbAL.Checked) { type = "AL"; } else if (rbB.Checked) { type = "B"; } Cls_BLL_TransHwayBulkRenewal objTran = new Cls_BLL_TransHwayBulkRenewal(); DataTable ds = objTran.FillPlanCombo(htAddPlanParams, username, operator_id, catid, type, username); ddlPlanname.DataSource = ds; ddlPlanname.DataTextField = "plan_name"; ddlPlanname.DataValueField = "plan_name"; ddlPlanname.DataBind(); ds.Dispose(); ddlPlanname.Items.Insert(0, "ALL"); }
public void proceedRenewals() { string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { catid = Convert.ToString(Session["category"]); if (catid == "11") { Session["lco_username"] = ddllco.SelectedValue.Split('$')[1].ToString(); username = ddllco.SelectedValue.Split('$')[0].ToString();// Session["username"].ToString(); } else { Session["lco_username"] = Convert.ToString(Session["operator_id"]); username = Session["username"].ToString(); } operator_id = Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } string file_name = ""; string upload_id = ""; 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"); string cur_time_filename_part = DateTime.Now.ToString("dd-MMM-yyyy_hhmmss"); Random random = new Random(); upload_id = username + "_" + cur_time + "_" + random.Next(1000, 9999); file_name = "Renew_" + username + "_" + cur_time_filename_part; StringBuilder sb = new StringBuilder(); if (((CheckBox)grdExpiry.HeaderRow.FindControl("cbAllrenew")).Checked) { //--------------------------------------------------------------- string plan_type = ""; if (rbAD.Checked) { plan_type = "AD"; } else if (rbAL.Checked) { plan_type = "AL"; } else if (rbHSP.Checked) { plan_type = "HSP"; } else if (rbB.Checked) { plan_type = "B"; } else { plan_type = "ALL"; } string vcid = ""; if (chkVCID.Checked == true) { vcid = txtvcid.Text; } string plan_name = ddlPlanname.SelectedValue.ToString(); //--------------------------------------------------------------- try { Cls_BLL_TransHwayBulkRenewal objrenew = new Cls_BLL_TransHwayBulkRenewal(); string returnval = objrenew.GetBulkRenewData(username, upload_id, file_name, txtFrom.Text, txtTo.Text, plan_name, plan_type, vcid); if (returnval.Split('$')[0] == "9999") { Session["upload_id"] = upload_id; // Response.Redirect("../Transaction/TransHwayBulkRenewConf.aspx"); Response.Redirect("../Reports/rptBulkTransactionProc.aspx?uniqueid=" + upload_id); } else { lblSearchMsg.Text = returnval.Split('$')[1]; return; } } catch (Exception ex) { FileLogText1(ex.ToString(), "proceedRenewals", "", "", ""); } //validated_data_arr = validated_data.Split('#'); } else { int cnt = 0; string autorenwflag = ""; foreach (GridViewRow item in grdExpiry.Rows) { if (item.RowType == DataControlRowType.DataRow && (item.Cells[10].FindControl("cbRenew") as CheckBox).Checked) { //if (item.RowType == DataControlRowType.DataRow && (item.Cells[11].FindControl("cbAutoRenew") as CheckBox).Checked) //CheckBox childchks = item.Cells[10].FindControl("cbRenew") as CheckBox; CheckBox childchk = item.Cells[11].FindControl("cbAutoRenew") as CheckBox; childchk.Attributes.Add("onclick", "Check_CbAuto(this);"); if (item.RowType == DataControlRowType.DataRow && (item.Cells[11].FindControl("cbAutoRenew") as CheckBox).Checked) { autorenwflag = "Y"; } else if (HidChRenewalValue.Value == "N") { autorenwflag = "N"; } string str = "Insert into aoup_lcopre_bulk_temp values (seq_lcopre_bulk_temp.nextval,'" + item.Cells[1].Text + "', '" + ((LinkButton)item.FindControl("LBvc")).Text + "', " + " '" + item.Cells[6].Text + "','" + item.Cells[8].Text + "','R','" + username + "','" + upload_id + "','" + cur_timestamp + "','" + ((HiddenField)item.FindControl("hdnBrmpoid")).Value + "','','',SYSDATE,'N','" + file_name + "','N','" + autorenwflag + "' ,'Y','N','" + username + "','','','','','1','')"; cnt++; Cls_Helper obj = new Cls_Helper(); int returnval = obj.insertQry(str); } } if (cnt == 0) { string msg = "<script type=\"text/javascript\">alert(\"Please Select Atleast One Plan To Renew\");</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "msg", msg); return; } Session["upload_id"] = upload_id; string strs = "Insert into aoup_lcopre_bulk_temp_summary values ('" + upload_id + "','" + username + "', " + cnt + ", " + 0 + "," + 0 + ",'" + username + "',SYSDATE,'" + file_name + "')"; Cls_Helper objk = new Cls_Helper(); int returnvals = objk.insertQry(strs); if (returnvals >= 1) { Response.Redirect("../Reports/rptBulkTransactionProc.aspx?uniqueid=" + upload_id); } else { return; } } }
protected void binddata() { string from = txtFrom.Text; string to = txtTo.Text; DateTime boundry_start = DateTime.Now.Date; DateTime boundry_end = DateTime.Now.Date.AddDays(15); string date_err_msg = "Please select From and To dates between the range of '" + boundry_start.Day + "-" + boundry_start.Month + "-" + boundry_start.Year + "' " + "& '" + boundry_end.Day + "-" + boundry_end.Month + "-" + boundry_end.Year + "'"; 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"; // grdExpiry.Visible = false; // lblSearchMsg.ForeColor = System.Drawing.Color.Red; // return; // } // else if (Convert.ToDateTime(txtFrom.Text.ToString()) < DateTime.Now.Date) // { // lblSearchMsg.Text = date_err_msg;//"You can not select From date earlier than 15 days from current date!"; // return; // } // else if (Convert.ToDateTime(txtFrom.Text.ToString()) > DateTime.Now.Date.AddDays(15)) // { // lblSearchMsg.Text = date_err_msg;//"You can not select From date later than 15 days from current date!"; // return; // } // else if (Convert.ToDateTime(txtTo.Text.ToString()) < DateTime.Now.Date) // { // lblSearchMsg.Text = date_err_msg;// "You can not select To date earlier than 15 days from current date!"; // return; // } // else if (Convert.ToDateTime(txtTo.Text.ToString()) > DateTime.Now.Date.AddDays(15)) // { // lblSearchMsg.Text = date_err_msg;// "You can not select To date later than 15 days from current date!"; // return; // } // else // { // lblSearchMsg.Text = ""; // grdExpiry.Visible = true; // } // } //comment by vivek 20150627 Hashtable htAddPlanParams = getLedgerParamsData(); string type = ""; if (rbALL.Checked) { type = "ALL"; } else if (rbAD.Checked) { type = "AD"; } else if (rbHSP.Checked) { type = "HSP"; } else if (rbAL.Checked) { type = "AL"; } else if (rbB.Checked) { type = "B"; } string planname = ""; if (ddlPlanname.SelectedIndex == 0) { planname = "ALL"; } else { planname = ddlPlanname.SelectedValue.ToString(); } string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { // Session["username"].ToString(); catid = Convert.ToString(Session["category"]); if (catid == "11") { operator_id = ddllco.SelectedValue.Split('$')[1].ToString();// Convert.ToString(Session["operator_id"]); username = ddllco.SelectedValue.Split('$')[0].ToString(); } else { username = Session["username"].ToString(); operator_id = Convert.ToString(Session["operator_id"]); } } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } DataTable dt = new DataTable(); //if (catid == "3") //{ Cls_BLL_TransHwayBulkRenewal objTran = new Cls_BLL_TransHwayBulkRenewal(); dt = objTran.GetExpDetails(htAddPlanParams, username, operator_id, catid, type, planname); //} //else //{ // lblSearchMsg.Text = "unauthorize user"; //} if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'></b><b>Details From : </b>" + from + "<b> To : </b>" + to); if (dt.Rows.Count == 0) { //btnGenerateExcel.Visible = false; btnProceed.Visible = false; grdExpiry.Visible = false; lblSearchMsg.Text = "No data found"; } else { //btnGenerateExcel.Visible = true; grdExpiry.Visible = true; btnProceed.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_trans"] = dt; grdExpiry.DataSource = dt; grdExpiry.DataBind(); } }