private void bind_page_ddl()
{
//Default Selection of dropdown as per old request
ddl_project.SelectedValue = process_req_row.projectid.ToString();
ds_analytics.projectsRow prj_row = projects.getProjectByPrjid(process_req_row.projectid)[0];
lbl_prj_type.Text = prj_row.projecttype;
lbl_prj_category.Text = prj_row.projectcategory;
lbl_prj_brand.Text = prj_row.projectbrand;
ddl_typeanalysis.SelectedValue = process_req_row.analysistype;
if (mode == "edit")
{
new_reqid = process_reqid;
lbl_requestid.Text = new_reqid;
btn_submit.Text = "Resubmit";
btn_submit.ToolTip = "Submit request changes";
}
else if (mode == "copy")
{
//new_reqid = requests.get_new_reqid();
lbl_requestid.Text = "Request Copied";
lbl_requestid.ToolTip = "New Request No. will be assigned on Submit";
btn_submit.Text = "Submit Request";
btn_submit.ToolTip = "Submit new request using copied request";
}
ddl_lead.SelectedValue = process_req_row.responsible;
ddl_typerequest.SelectedValue = rtype; // due to change in reqtype postback//
tb_addinfo.Text = process_req_row.req_cmnt;
}
protected void ddl_project_SelectedIndexChanged(object sender, EventArgs e)
{
long prj_id = Convert.ToInt64(ddl_project.SelectedValue);
ds_analytics.projectsRow prj_row = projects.getProjectByPrjid(prj_id)[0];
lbl_prj_type.Text = prj_row.projecttype;
lbl_prj_category.Text = prj_row.projectcategory;
lbl_prj_brand.Text = prj_row.projectbrand;
}
protected void bind_project_fields()
{
long prj_id = Convert.ToInt64(ddl_project.SelectedValue);
ds_analytics.projectsRow prj_row = projects.getProjectByPrjid(prj_id)[0];
lbl_prj_type.Text = prj_row.projecttype;
lbl_prj_category.Text = prj_row.projectcategory;
lbl_prj_brand.Text = prj_row.projectbrand;
Page.Validate();
}
public static int insert(ds_analytics.projectsRow prj_row)
{
return(Adapter.Insert(prj_row.projectname,
prj_row.projecttype,
prj_row.projectcategory,
prj_row.projectbrand,
prj_row.budget,
prj_row.createdate,
prj_row.completiondate,
prj_row.isactive));
}
protected void imgbtn_Edit_Click(object sender, ImageClickEventArgs e)
{
GridViewRow gv_row = (GridViewRow)((sender as ImageButton).NamingContainer);
long prjid = Convert.ToInt64(gv_projects.DataKeys[gv_row.RowIndex].Value);
ds_analytics.projectsDataTable thisprj_dt = projects.getProjectByPrjid(prjid);
if (thisprj_dt.Rows.Count > 0)
{
ds_analytics.projectsRow prj_row = thisprj_dt[0];
tb_prj_name.Text = prj_row.projectname;
ddl_prj_type.SelectedValue = prj_row.projecttype;
ddl_prj_category.SelectedValue = prj_row.projectcategory;
ddl_prj_brand.SelectedValue = prj_row.projectbrand;
if (prj_row.IscreatedateNull())
{
tb_prj_start.Text = "";
}
else
{
tb_prj_start.Text = prj_row.createdate.ToString("dd/MM/yyyy");
}
if (prj_row.IscompletiondateNull())
{
tb_prj_end.Text = "";
}
else
{
tb_prj_end.Text = prj_row.completiondate.ToString("dd/MM/yyyy");
}
if (prj_row.IsbudgetNull())
{
tb_prj_budget.Text = "";
}
else
{
tb_prj_budget.Text = Convert.ToString(prj_row.budget);
}
cb_isactive.Checked = prj_row.isactive;
ViewState["prj_row"] = prj_row;
btn_add.Visible = false;
btn_update.Visible = true;
btn_cancel.Visible = true;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('Error in reading project details.');</script>");
}
}
protected void btn_add_Click(object sender, EventArgs e)
{
try
{
ds_analytics.projectsDataTable prj_dt = new ds_analytics.projectsDataTable();
ds_analytics.projectsRow prj_row = prj_dt.NewprojectsRow();
prj_row.projectname = tb_prj_name.Text;
prj_row.projecttype = ddl_prj_type.SelectedItem.Text;
prj_row.projectcategory = ddl_prj_category.SelectedItem.Text;
prj_row.projectbrand = ddl_prj_brand.SelectedItem.Text;
if (tb_prj_start.Text == "")
{
prj_row.SetcreatedateNull();
}
else
{
prj_row.createdate = Convert.ToDateTime(tb_prj_start.Text);
}
if (tb_prj_end.Text == "")
{
prj_row.SetcompletiondateNull();
}
else
{
prj_row.completiondate = Convert.ToDateTime(tb_prj_end.Text).AddHours(23).AddMinutes(59).AddSeconds(59);
}
if (tb_prj_budget.Text == "")
{
prj_row.SetbudgetNull();
}
else
{
prj_row.budget = Convert.ToDouble(tb_prj_budget.Text);
}
prj_row.isactive = cb_isactive.Checked;
projects.insert(prj_row);
string url = "projects.aspx";
ClientScript.RegisterStartupScript(this.GetType(), "callfunction", "alert('Record Added Successfully.');window.location.href = '" + url + "';", true);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('Error in adding record.');</script>");
}
}
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 btn_update_Click(object sender, EventArgs e)
{
ds_analytics.projectsRow prj_row = ((ds_analytics.projectsRow)(ViewState["prj_row"]));
prj_row.projectname = tb_prj_name.Text;
prj_row.projecttype = ddl_prj_type.SelectedItem.Text;
prj_row.projectcategory = ddl_prj_category.SelectedItem.Text;
prj_row.projectbrand = ddl_prj_brand.SelectedItem.Text;
if (tb_prj_start.Text == "")
{
prj_row.SetcreatedateNull();
}
else
{
prj_row.createdate = Convert.ToDateTime(tb_prj_start.Text);
}
if (tb_prj_end.Text == "")
{
prj_row.SetcompletiondateNull();
}
else
{
prj_row.completiondate = Convert.ToDateTime(tb_prj_end.Text).AddHours(23).AddMinutes(59).AddSeconds(59);
}
if (tb_prj_budget.Text == "")
{
prj_row.SetbudgetNull();
}
else
{
prj_row.budget = Convert.ToDouble(tb_prj_budget.Text);
}
prj_row.isactive = cb_isactive.Checked;
projects.update(prj_row);
ds_analytics.projectsDataTable prj_dt = projects.getAllProjects();
gv_projects.DataSource = prj_dt;
gv_projects.DataBind();
ViewState["dtStored"] = prj_dt;
Reset();
}
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 bind_req_header()
{
Encryption64 e64 = new Encryption64();
hl_print_request.NavigateUrl = "~/UI/users/print_request.aspx?reqid=" + e64.Encrypt(reqid);
hl_pdf_request.NavigateUrl = "~/UI/users/print_request.aspx?reqid=" + e64.Encrypt(reqid) + "&action=pdf";
//setting labels and InfoBox
lbl_requestor.Text = "(Request by- " + m_users.getFullnameByuserid(req_row.reqfrom) + ")";
ds_analytics.projectsRow prj_row = projects.getProjectByPrjid(req_row.projectid)[0];
lbl_project.Text = prj_row.projectname;
lbl_prj_type.Text = prj_row.projecttype;
lbl_prj_category.Text = prj_row.projectcategory;
lbl_prj_brand.Text = prj_row.projectbrand;
lbl_typeanalysis.Text = req_row.analysistype;
lbl_requestid.Text = req_row.reqid;
lbl_lead.Text = m_users.getFullnameByuserid(req_row.responsible);
lbl_typerequest.Text = req_row.reqtype;
lbl_status.Text = other.getStatustext(req_row.statusid);
tb_addinfo.Text = req_row.req_cmnt;
}
public static int update(ds_analytics.projectsRow prj_row)
{
return(Adapter.Update(prj_row));
}
public static string getProjectNameByProjectID(long projectid)
{
ds_analytics.projectsDataTable prj_dt = getProjectByPrjid(projectid);
ds_analytics.projectsRow prj_row = prj_dt[0];
return(prj_row.projectname);
}
