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