protected void Page_Load(object sender, EventArgs e)
{
if (Session["userid"] == null)
{
Response.Redirect("~/Default.aspx");
}
if (!IsPostBack)
{
string userid = Session["userid"].ToString();
ds_analytics.m_usersRow user_row = m_users.getUserByUserid(userid)[0];
lbl_user.Text = user_row.fullname;
lbl_time.Text = user_row.lastlogintime.ToString("dd/MM/yyyy HH:mm");
//Set Role/ModuleList DropDown
ArrayList arr_mod = m_users.getModulesByUserid(userid);
ddl_moduleList.DataSource = arr_mod;
ddl_moduleList.DataBind();
ddl_moduleList.SelectedValue = "Requests";
//Setting display of Role Dropdown
if (arr_mod.Count == 1)
{
ddl_moduleList.Visible = false;
}
//SetPage According to User Access Rights
setPageByRights(userid);
}
else
{
}
}
protected void imgbtn_Edit_Click(object sender, ImageClickEventArgs e)
{
GridViewRow gv_row = (GridViewRow)((sender as ImageButton).NamingContainer);
string userid = Convert.ToString(gv_users.DataKeys[gv_row.RowIndex].Value);
ds_analytics.m_usersDataTable thisuser_dt = m_users.getUserByUserid(userid);
if (thisuser_dt.Rows.Count > 0)
{
ds_analytics.m_usersRow user_row = thisuser_dt[0];
lbl_userid.Text = user_row.userid;
if (user_row.IsfullnameNull())
{
tb_username.Text = "";
}
else
{
tb_username.Text = user_row.fullname;
}
if (user_row.IsemailNull())
{
tb_email.Text = "";
}
else
{
tb_email.Text = user_row.email;
}
if (user_row.IsmblnoNull())
{
tb_mblno.Text = "";
}
else
{
tb_mblno.Text = user_row.mblno;
}
cb_isactive.Checked = user_row.isactive;
foreach (TreeNode node_parent in TreeView1.Nodes)
{
foreach (TreeNode node_child in node_parent.ChildNodes)
{
node_child.Checked = false;
}
}
DataTable dt_rights = m_users.getAccessRightsByUserid(user_row.userid);
foreach (DataRow dr in dt_rights.Rows)
{
TreeView1.FindNode(dr["module_key"].ToString() + TreeView1.PathSeparator + dr["submodule_key"].ToString()).Checked = true;
}
ViewState["user_row"] = user_row;
btn_update.Visible = true;
btn_cancel.Visible = true;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('Error in reading user details.');</script>");
}
}
protected void mail_to_lab(long labid)
{
string sub = "GSK: Samples for tests at your lab";
string from;
ds_analytics.m_usersRow receiver_row = m_users.getUserByUserid(req_row.responsible)[0];
if (receiver_row.email != "")
{
from = receiver_row.email;
}
else
{
from = "*****@*****.**";
}
WebClient wclient = new WebClient();
string url = HttpContext.Current.Request.Url.AbsoluteUri;
url = url.Replace("UI/users/reqaction.aspx", "Mailer/reqlab.htm");
string pagedata = wclient.DownloadString(url);
string body = pagedata;
string[] to = new string[2];
string[] cc = new string[2];
string[] bcc = new string[2];
//mail to lab
ds_analytics.m_labsRow lab_row = m_labs.getLabByLabid(labid)[0];
if (!lab_row.Isemail1Null() || !lab_row.Isemail2Null())
{
if (!lab_row.Isemail1Null() && !lab_row.Isemail2Null())
{
//notnull && notnull
body = body.Replace("!!~lab_manager~!!", lab_row.contact_person);
to[0] = lab_row.email1;
cc[0] = lab_row.email2;
}
else if (!lab_row.Isemail1Null() && lab_row.Isemail2Null())
{
//notnull && null
body = body.Replace("!!~lab_manager~!!", lab_row.contact_person);
to[0] = lab_row.email1;
}
else if (lab_row.Isemail1Null() && !lab_row.Isemail2Null())
{
//null && notnull
body = body.Replace("!!~lab_manager~!!", lab_row.key_acc_person);
to[0] = lab_row.email2;
}
analyticsmail ana_mail = new analyticsmail();
ana_mail.sendmails(to, cc, bcc, from, sub, body, "");
}
}
private void do_mail(string req_status)
{
string sub = "Analytics: Your Request " + req_row.reqid + " has been " + req_status;
string from;
ds_analytics.m_usersRow receiver_row = m_users.getUserByUserid(req_row.responsible)[0];
if (receiver_row.email != "")
{
from = receiver_row.email;
}
else
{
from = "*****@*****.**";
}
WebClient wclient = new WebClient();
string url = HttpContext.Current.Request.Url.AbsoluteUri;
url = url.Replace("UI/users/reqaction.aspx", "Mailer/reqapprove.htm");
string pagedata = wclient.DownloadString(url);
string body = pagedata;
//mail to requestor
ds_analytics.m_usersRow requestor_row = m_users.getUserByUserid(req_row.reqfrom)[0];
if (requestor_row != null && requestor_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("reqaction");
string redirect_url = url.Substring(0, len);
Encryption64 e64 = new Encryption64();
redirect_url = redirect_url + "reqaction_byme.aspx?reqid=" + e64.Encrypt(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("!!~requestor_name~!!", requestor_row.fullname);
body = body.Replace("!!~req_no~!!", req_row.reqid);
body = body.Replace("!!~req_decision~!!", req_status);
body = body.Replace("!!~receiver_name~!!", receiver_row.fullname);
body = body.Replace("!!~You can open the request at web_link~!!", "You can open the request at " + web_link);
string[] to = { requestor_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 lb_logout_Click(object sender, EventArgs e)
{
string userid = Session["userid"].ToString();
ds_analytics.m_usersRow user_row = m_users.getUserByUserid(userid)[0];
user_row.isloggedin = false;
user_row.lastlogintime = DateTime.Now;
m_users.update(user_row);
Session.Abandon();
Session.RemoveAll();
Session.Clear();
Response.Redirect("~/Default.aspx?logout");
}
protected void btn_update_Click(object sender, EventArgs e)
{
ds_analytics.m_usersRow users_row = ((ds_analytics.m_usersRow)(ViewState["user_row"]));
//1 User Update
users_row.fullname = tb_username.Text;
if (tb_email.Text == "")
{
users_row.SetemailNull();
}
else
{
users_row.email = tb_email.Text;
}
if (tb_mblno.Text == "")
{
users_row.SetmblnoNull();
}
else
{
users_row.mblno = tb_mblno.Text;
}
users_row.isactive = cb_isactive.Checked;
m_users.update(users_row);
//2 User_Rights Update
m_users_rights.delete(users_row.userid);
foreach (TreeNode node_parent in TreeView1.Nodes)
{
foreach (TreeNode node_child in node_parent.ChildNodes)
{
if (node_child.Checked == true)
{
m_users_rights.insert(users_row.userid, Convert.ToInt32(node_child.Value));
}
}
}
//Rebind GridView
ds_analytics.m_usersDataTable users_dt = m_users.getAllUsers();
bind_gv_users(users_dt);
ViewState["dtStored"] = users_dt;
//Reset Fields
Reset();
ClientScript.RegisterStartupScript(this.GetType(), "callfunction", "alert('User Updated.');", true);
}
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, "");
}
}
public static int update(ds_analytics.m_usersRow user_row)
{
return(Adapter.Update(user_row));
}
protected void btn_Login_Click(object sender, EventArgs e)
{
string errorText = string.Empty;
string login_id = Request.QueryString.Get("login");
string redirect = Request.QueryString.Get("redirect");
if (txtbx_uid.Text == "superuser")
{
DataTable dt_superuser = other.getDropdownsbyType("superuser");
if (dt_superuser.Rows.Count > 0)
{
if (dt_superuser.Rows[0]["value"].ToString() == txtbx_pass.Text)
{
Session["userid"] = txtbx_uid.Text;
if (redirect == "" || redirect == null)
{
//user has came to this page directly, not through mail
Response.Redirect("~/UI/admin/home.aspx");
}
else
{
//user has came to this page through mail
if (login_id == txtbx_uid.Text)
{
Response.Redirect(redirect);
}
else
{
//mail receiver is different from the person doing login
errorText = "Link not intended for you.";
}
}
}
else
{
errorText = "Wrong UserID or Password";
}
}
else
{
errorText = "Wrong UserID or Password";
}
}
else if (m_users.authenticate(txtbx_uid.Text, txtbx_pass.Text))
{
ds_analytics.m_usersDataTable user_dt = m_users.getUserByUserid(txtbx_uid.Text);
if (user_dt.Rows.Count > 0)
{
ds_analytics.m_usersRow user_row = user_dt[0];
if (user_row.isactive == true)
{
user_row.isloggedin = true;
m_users.update(user_row);
Session["userid"] = txtbx_uid.Text;
if (m_users.getModulesByUserid(txtbx_uid.Text).Contains("Requests"))
{
if (redirect == "" || redirect == null)
{
Response.Redirect("~/UI/users/home.aspx");
}
else
{
if (login_id == txtbx_uid.Text)
{
Response.Redirect(redirect);
}
else
{
errorText = "Link not intended for you.";
}
}
}
else if (m_users.getModulesByUserid(txtbx_uid.Text).Contains("Admin"))
{
if (redirect == "" || redirect == null)
{
Response.Redirect("~/UI/admin/home.aspx");
}
else
{
if (login_id == txtbx_uid.Text)
{
Response.Redirect(redirect);
}
else
{
errorText = "Link not intended for you.";
}
}
}
else
{
errorText = "Problem in login as the access rights are not properly defined.";
}
}
else
{
errorText = "User has been made inactive.";
}
}
else
{
errorText = "Wrong UserID or Password";
}
}
else
{
errorText = "Wrong UserID or Password";
}
if (errorText != string.Empty)
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('" + errorText + "');</script>");
}
}
private void load_sender()
{
ds_analytics.m_usersRow user_row = m_users.getUserByUserid(userid)[0];
lbl_sender.Text = user_row.fullname + "</br>" + "Analytical Sciences," + "</br>" + "Mob: " + user_row.mblno + "</br>" + "Email: " + user_row.email;
}
private void do_mail()
{
ds_analytics.m_usersRow req_row = m_users.getUserByUserid(userid)[0];
string sub = "Analytics: New Request " + reqid + " raised by " + req_row.fullname;
string from;
if (req_row.email != "")
{
from = req_row.email;
}
else
{
from = "*****@*****.**";
}
WebClient wclient = new WebClient();
string url = HttpContext.Current.Request.Url.AbsoluteUri;
url = url.Replace("UI/users/request2.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("request2");
string redirect_url = url.Substring(0, len);
Encryption64 e64 = new Encryption64();
redirect_url = redirect_url + "reqaction.aspx?reqid=" + e64.Encrypt(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~!!", req_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, "");
}
//mail to Backup-ID
body = pagedata;
DataTable dt_bke = other.getDropdownsbyType("backupemail");
if (dt_bke.Rows.Count > 0)
{
DataTable dt_bkn = other.getDropdownsbyType("backupname");
string backupname = "";
if (dt_bkn.Rows.Count > 0)
{
backupname = dt_bkn.Rows[0]["value"].ToString();
}
body = body.Replace("!!~receiver_name~!!", backupname);
body = body.Replace("!!~no_samples~!!", no_samples.ToString());
body = body.Replace("!!~requestor_name~!!", req_row.fullname);
body = body.Replace("!!~You can open the request at web_link~!!", "");
string[] to = { dt_bke.Rows[0]["value"].ToString() };
string[] cc = new string[2];
string[] bcc = new string[2];
analyticsmail ana_mail = new analyticsmail();
ana_mail.sendmails(to, cc, bcc, from, sub, body, "");
}
}
