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