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 btn_add_Click(object sender, EventArgs e)
{
DataTable dt_user = m_users.getUserByUserid(tb_add_username.Text);
if (dt_user.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "callfunction", "alert('This ID already exist.');", true);
}
else
{
string msg = "Problem in adding user."; //msg contains the exception genrated by the function below.
bool user_added = m_users.AddUser(tb_add_username.Text, ref msg);
if (user_added)
{
//Rebind GridView
ds_analytics.m_usersDataTable users_dt = m_users.getAllUsers();
bind_gv_users(users_dt);
ViewState["dtStored"] = users_dt;
ClientScript.RegisterStartupScript(this.GetType(), "callfunction", "alert('User Added Successfully.');", true);
mpopup_1.Show();
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "callfunction", "alert('" + msg + "');", true);
}
}
}
protected void btn_search_Click(object sender, EventArgs e)
{
ds_analytics.m_usersDataTable users_dt = m_users.getAllUsersByName(tb_username_search.Text);
bind_gv_users(users_dt);
ViewState["dtStored"] = users_dt;
}
public static ds_analytics.m_usersDataTable getAllActiceReceivers()
{
ds_analytics.m_usersDataTable users_dt = Adapter.GetAllActiveReceivers();
if (users_dt.Rows.Count > 0)
{
DataRow[] dr_superuser = users_dt.Select("fullname='superuser'");
foreach (DataRow dr in dr_superuser)
{
dr.Delete();
}
}
return(users_dt);
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
((MenuItem)((Menu)Master.FindControl("Menu1")).FindItem("Users")).Selected = true;
ViewState["SortOrder"] = " ASC";
ds_analytics.m_usersDataTable users_dt = m_users.getAllUsers();
bind_gv_users(users_dt);
ViewState["dtStored"] = users_dt;
CreateTreeView();
}
else
{
}
}
protected void imgbtn_Delete_Click(object sender, ImageClickEventArgs e)
{
GridViewRow gv_row = (GridViewRow)((sender as ImageButton).NamingContainer);
string userid = Convert.ToString(gv_users.DataKeys[gv_row.RowIndex].Value);
int reqby = requests.getAllRequestsbyReqfrom(userid).Rows.Count;
int reqto = requests.getAllRequestsbyResponsible(userid).Rows.Count;
if (reqby == 0 && reqto == 0)
{
m_users.delete(userid);
ds_analytics.m_usersDataTable users_dt = m_users.getAllUsers();
bind_gv_users(users_dt);
ViewState["dtStored"] = users_dt;
ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('User deleted Successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('User cannot be deleted as some requests exists related to the user.');</script>");
}
}
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>");
}
}
