///<summary>
///Returns new reqid (add 1 in old if in same month, otherwise send yymm0001)
///</summary>
public static string get_new_reqid()
{
string new_reqid = string.Empty;
ds_analytics.requestsDataTable rdt = Adapter.GetLastRequestId();
if (rdt.Rows.Count > 0)
{
string reqid_last = rdt[0]["reqid"].ToString(); //12110001
string old_reqno = reqid_last.Substring(4); //0001
string yearmonth_last = reqid_last.Substring(0, 4); //1211 (yymm)
string yearmonth_today = DateTime.Now.Year.ToString().Substring(2) + DateTime.Now.Month.ToString("00"); //yymm
if (yearmonth_today == yearmonth_last)
{
string new_reqno = (Convert.ToInt32(old_reqno) + 1).ToString("0000"); //0002
new_reqid = yearmonth_today + new_reqno;
}
else
{
new_reqid = yearmonth_today + "0001";
}
}
else
{
new_reqid = DateTime.Now.Year.ToString().Substring(2) + DateTime.Now.Month.ToString("00") + "0001";
}
return(new_reqid);
}
protected void Page_Init(object sender, EventArgs e)
{
Encryption64 e64 = new Encryption64();
reqid = e64.Decrypt(Request.QueryString.Get("reqid").Replace(" ", "+"));
ds_analytics.requestsDataTable req_dt = requests.getRequestbyReqid(reqid);
if (req_dt.Count > 0)
{
req_row = req_dt[0];
}
else
{
Response.Write("<script>alert('No request found .');</script>");
}
//create dynamic gv_test_sample in Page_Init while sending to lab
if (req_row.statusid == 3)
{
build_gv_ts_lab_selection();
if (!IsPostBack)
{
dt_test_sample_global = get_dt_ts_lab_selection();
bind_gv_ts_lab_selection(dt_test_sample_global);
}
else
{
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
((MenuItem)((Menu)Master.FindControl("Menu1")).FindItem("MIS")).Selected = true;
ViewState["SortOrder"] = " ASC";
ds_analytics.requestsDataTable req_dt = requests.getAllRequests();
gv_reqs.DataSource = req_dt;
gv_reqs.DataBind();
ViewState["dtStored"] = req_dt;
}
}
protected void Page_Init(object sender, EventArgs e)
{
Encryption64 e64 = new Encryption64();
reqid = e64.Decrypt(Request.QueryString.Get("reqid").Replace(" ", "+"));
ds_analytics.requestsDataTable req_dt = requests.getRequestbyReqid(reqid);
if (req_dt.Count > 0)
{
req_row = req_dt[0];
}
else
{
Response.Write("<script>alert('Error in request.');</script>");
}
}
protected void Page_Init(object sender, EventArgs e)
{
mode = Request.QueryString.Get("mode");
user = Request.QueryString.Get("user");
Encryption64 e64 = new Encryption64();
process_reqid = e64.Decrypt(Request.QueryString.Get("process_reqid").Replace(" ", "+"));
ds_analytics.requestsDataTable req_dt = requests.getRequestbyReqid(process_reqid);
process_req_row = req_dt[0];
userid = Session["userid"].ToString();
no_samples = Convert.ToInt32(e64.Decrypt(Request.QueryString.Get("nosample").Replace(" ", "+")));
no_tests = Convert.ToInt32(e64.Decrypt(Request.QueryString.Get("notest").Replace(" ", "+")));
no_samples_intab = int.Parse(System.Configuration.ConfigurationManager.AppSettings["no_samples_intab"].ToString());
if (!IsPostBack)
{
lbl_status.Text = other.getStatustext(1);
rtype = e64.Decrypt(Request.QueryString.Get("rtype").Replace(" ", "+"));
set_page_ddl();
bind_page_ddl();
set_page_samples();
bind_page_tests();
build_dt_test_sample();
build_gv_test_sample();
bind_gv_test_sample();
Page.Validate();
}
else
{
rtype = Request.Form[ddl_typerequest.UniqueID];
set_page_samples();
build_gv_test_sample();
Page.Validate();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Encryption64 e64 = new Encryption64();
reqid = e64.Decrypt(Request.QueryString.Get("reqid").Replace(" ", "+"));
ds_analytics.requestsDataTable req_dt = requests.getRequestbyReqid(reqid);
if (req_dt.Count > 0)
{
req_row = req_dt[0];
prj_row = projects.getProjectByPrjid(req_row.projectid)[0];
this.Title = prj_row.projectname + "_" + req_row.reqdate.ToString("yyyy_MM") + "_" + reqid + ".pdf";
if (!string.IsNullOrEmpty(Request.QueryString.Get("action")) && (Request.QueryString.Get("action").ToLower() == "pdf"))
{
strPdfFileName = this.Title;
isPDFrequest = true;
}
}
else
{
Response.Write("<script>alert('No request found.');</script>");
}
if (!IsPostBack)
{
bind_req_header();
bind_req_samples();
if (req_row.statusid > 5)
{
pnl_LabResults.Visible = true;
bind_lab_results();
}
bind_req_tests();
bind_test_samples();
}
if (!isPDFrequest)
{
// Auto Pop-up for print request
Page.ClientScript.RegisterStartupScript(this.GetType(), "Print", "javascript:window.print();", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Encryption64 e64 = new Encryption64();
if (!IsPostBack)
{
((MenuItem)((Menu)Master.FindControl("Menu1")).FindItem("Projects")).Selected = true;
ViewState["SortOrder"] = " ASC";
long prjid = Convert.ToInt64(e64.Decrypt(Request.QueryString.Get("prj").Replace(" ", "+")));
//Header Bound
ds_analytics.projectsRow prj_row = projects.getProjectByPrjid(prjid)[0];
lbl_name.Text = prj_row.projectname;
lbl_type.Text = prj_row.projecttype;
lbl_category.Text = prj_row.projectcategory;
lbl_brand.Text = prj_row.projectbrand;
if (!prj_row.IscreatedateNull())
{
lbl_start.Text = prj_row.createdate.ToString("dd/MM/yyyy");
}
if (!prj_row.IscompletiondateNull())
{
lbl_end.Text = prj_row.completiondate.ToString("dd/MM/yyyy");
}
if (!prj_row.IsbudgetNull())
{
lbl_budget.Text = Convert.ToString(prj_row.budget);
}
cb_active.Checked = prj_row.isactive;
//GridView
ds_analytics.requestsDataTable req_dt = requests.getAllRequestsByProjID(prjid);
gv_requests.DataSource = req_dt;
gv_requests.DataBind();
ViewState["dtStored"] = req_dt;
}
else
{
}
}
private void do_mail(string mode, string submitted_reqid)
{
ds_analytics.requestsDataTable req_dt = requests.getRequestbyReqid(submitted_reqid);
ds_analytics.requestsRow submitted_req_row = req_dt[0];
ds_analytics.m_usersRow requestor_row = m_users.getUserByUserid(submitted_req_row.reqfrom)[0];
string sub = "";
if (mode == "edit")
{
sub = "Analytics: Request " + submitted_req_row.reqid + " resubmitted by " + requestor_row.fullname;
}
else if (mode == "copy")
{
sub = "Analytics: New Request " + submitted_req_row.reqid + " raised by " + requestor_row.fullname;
}
string from;
if (requestor_row.email != "")
{
from = requestor_row.email;
}
else
{
from = "*****@*****.**";
}
WebClient wclient = new WebClient();
string url = HttpContext.Current.Request.Url.AbsoluteUri;
url = url.Replace("UI/users/process_request1.aspx", "Mailer/reqsubmit.htm");
string pagedata = wclient.DownloadString(url);
string body = pagedata;
//mail to receiver
ds_analytics.m_usersRow rec_row = m_users.getUserByUserid(ddl_lead.SelectedValue)[0];
if (rec_row != null && rec_row.email != "")
{
//1. Creating login page link
url = HttpContext.Current.Request.Url.AbsoluteUri;
int len = url.IndexOf("UI");
string base_url = url.Substring(0, len);
base_url = base_url + "Default.aspx?login="******"&redirect=";
//2. Creating request page link
url = HttpContext.Current.Request.Url.AbsoluteUri;
len = url.IndexOf("process_request1");
string redirect_url = url.Substring(0, len);
Encryption64 e64 = new Encryption64();
redirect_url = redirect_url + "reqaction.aspx?reqid=" + e64.Encrypt(submitted_req_row.reqid);
//3. Adding login + redirect link
string web_link = "<a href='" + base_url + redirect_url + "' target='_blank'>Open Request</a>";
body = body.Replace("!!~receiver_name~!!", rec_row.fullname);
body = body.Replace("!!~no_samples~!!", no_samples.ToString());
body = body.Replace("!!~requestor_name~!!", requestor_row.fullname);
body = body.Replace("!!~You can open the request at web_link~!!", "You can open the request at " + web_link);
string[] to = { rec_row.email };
string[] cc = new string[2];
string[] bcc = new string[2];
analyticsmail ana_mail = new analyticsmail();
ana_mail.sendmails(to, cc, bcc, from, sub, body, "");
}
}
protected void ddl_searchby_SelectedIndexChanged(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox1.Visible = false;
DropDownList1.Visible = false;
btn_search.Visible = false;
rfv1.Enabled = false;
DropDownList1.Items.Clear();
switch (ddl_searchby.SelectedValue)
{
case "reqid":
TextBox1.Visible = true;
rfv1.Enabled = true;
btn_search.Visible = true;
break;
case "projectid":
DropDownList1.Visible = true;
btn_search.Visible = true;
DropDownList1.DataSource = projects.getAllProjects();
DropDownList1.DataTextField = "projectname";
DropDownList1.DataValueField = "projectid";
DropDownList1.DataBind();
break;
case "reqtype":
DropDownList1.Visible = true;
btn_search.Visible = true;
DataTable dt_typerequests1 = other.getDropdownsbyType("typerequest");
DataTable dt_typerequests2 = other.getDropdownsbyType("typerequest-at");
foreach (DataRow dr in dt_typerequests2.Rows)
{
dt_typerequests1.ImportRow(dr);
}
DropDownList1.DataSource = dt_typerequests1;
DropDownList1.DataTextField = "value";
DropDownList1.DataValueField = "value";
DropDownList1.DataBind();
break;
case "reqfrom":
TextBox1.Visible = true;
rfv1.Enabled = true;
btn_search.Visible = true;
break;
case "responsible":
TextBox1.Visible = true;
rfv1.Enabled = true;
btn_search.Visible = true;
break;
case "statusid":
DropDownList1.Visible = true;
btn_search.Visible = true;
DropDownList1.DataSource = other.getAllStatus();
DropDownList1.DataTextField = "statustext";
DropDownList1.DataValueField = "statusid";
DropDownList1.DataBind();
break;
case "reqdate":
DropDownList1.Visible = true;
btn_search.Visible = true;
ListItem li1 = new ListItem("This Week");
ListItem li2 = new ListItem("Last Week");
ListItem li3 = new ListItem("This Month");
ListItem li4 = new ListItem("Last Month");
ListItem li5 = new ListItem("This Year");
ListItem li6 = new ListItem("Last Year");
DropDownList1.Items.Add(li1);
DropDownList1.Items.Add(li2);
DropDownList1.Items.Add(li3);
DropDownList1.Items.Add(li4);
DropDownList1.Items.Add(li5);
DropDownList1.Items.Add(li6);
break;
default:
ds_analytics.requestsDataTable req_dt = requests.getAllRequests();
gv_reqs.DataSource = req_dt;
gv_reqs.DataBind();
ViewState["dtStored"] = req_dt;
break;
}
}
protected void btn_search_Click(object sender, EventArgs e)
{
ds_analytics.requestsDataTable req_dt = null;
switch (ddl_searchby.SelectedValue)
{
case "reqid":
req_dt = requests.getRequestbyReqid(TextBox1.Text);
break;
case "projectid":
req_dt = requests.getAllRequestsByProjID(Convert.ToInt64(DropDownList1.SelectedValue));
break;
case "reqtype":
req_dt = requests.getAllRequestsByReqType(DropDownList1.SelectedItem.Text);
break;
case "reqfrom":
req_dt = requests.getAllRequestsByReqFromName(TextBox1.Text);
break;
case "responsible":
req_dt = requests.getAllRequestsByResponsibleName(TextBox1.Text);
break;
case "statusid":
req_dt = requests.getAllRequestsByStatusID(Convert.ToInt32(DropDownList1.SelectedValue));
break;
case "reqdate":
DateTime dt_now = DateTime.Now;
DateTime dt1 = new DateTime();
DateTime dt2 = new DateTime();
if (DropDownList1.SelectedItem.Text == "This Week")
{
int diff = DayOfWeek.Monday - dt_now.DayOfWeek;
dt1 = dt_now.AddDays(diff);
dt2 = dt_now.AddDays(diff + 6);
}
else if (DropDownList1.SelectedItem.Text == "Last Week")
{
int diff = DayOfWeek.Monday - dt_now.DayOfWeek;
diff -= 7;
dt1 = dt_now.AddDays(diff);
dt2 = dt_now.AddDays(diff + 6);
}
else if (DropDownList1.SelectedItem.Text == "This Month")
{
dt1 = dt_now.AddDays(-(dt_now.Day - 1));
dt2 = dt1.AddMonths(1);
dt2 = dt2.AddDays(-1);
}
else if (DropDownList1.SelectedItem.Text == "Last Month")
{
dt_now = dt_now.AddMonths(-1);
dt1 = dt_now.AddDays(-(dt_now.Day - 1));
dt2 = dt1.AddMonths(1);
dt2 = dt2.AddDays(-1);
}
else if (DropDownList1.SelectedItem.Text == "This Year")
{
dt1 = dt_now.AddDays(-(dt_now.DayOfYear - 1));
dt2 = dt1.AddYears(1);
dt2 = dt2.AddDays(-1);
}
else if (DropDownList1.SelectedItem.Text == "Last Year")
{
dt_now = dt_now.AddYears(-1);
dt1 = dt_now.AddDays(-(dt_now.DayOfYear - 1));
dt2 = dt1.AddYears(1);
dt2 = dt2.AddDays(-1);
}
req_dt = requests.getAllRequestsByReqDateFromTo(dt1, dt2);
break;
default:
break;
}
gv_reqs.DataSource = req_dt;
gv_reqs.DataBind();
ViewState["dtStored"] = req_dt;
}
///<summary>
///Get request statusid
///</summary>
public static int getStatusIDbyReqid(string reqid)
{
ds_analytics.requestsDataTable rdt = Adapter.GetRequestByReqid(reqid);
return(rdt[0].statusid);
}
