private void PageDataRefresh()
{
string uEmail = txtEmail.Text.ToString();
string uPhone = txtPhoneNumber.Text.ToString();
string uUsername = txtUserName.Text.ToString();
string rRoleID = txtRoleID.Text.ToString();
string rName = txtName.Text.ToString();
UsersAndRolesTableAdapter userRolesAdapter = new UsersAndRolesTableAdapter();
LvUserList.DataSource = userRolesAdapter.GetUsersRolesByParameters(uEmail, uPhone, uUsername, rRoleID, rName);
LvUserList.DataBind();
}
protected void FvUserView_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
// Code versions of all controls
TextBox Email_txt = (TextBox)FvUserView.FindControl("txtEmail");
TextBox PhoneNumber_txt = (TextBox)FvUserView.FindControl("txtPhoneNumber");
TextBox UserName_txt = (TextBox)FvUserView.FindControl("txtUserName");
CheckBoxList Roles_cbl = (CheckBoxList)FvUserView.FindControl("CblRoles");
string email = Email_txt.Text;
string phoneNumber = PhoneNumber_txt.Text;
string userName = UserName_txt.Text;
UsersAndRolesTableAdapter userAdapter = new UsersAndRolesTableAdapter();
try
{
string originalID = Request.QueryString["id"].ToString();
// Conduct Update
userAdapter.UpdateRecord(email, phoneNumber, userName, originalID);
// Update CheckBoxList on all items.
foreach (ListItem item in Roles_cbl.Items)
{
if (item.Selected)
{
userAdapter.InsertUserRoleLink(originalID, item.Value);
}
else
{
userAdapter.DeleteUserRoleLink(originalID, item.Value);
}
}
//Response.Write("<script LANGUAGE='JavaScript' >alert('Record Edited')</script>");
ClientScript.RegisterStartupScript(GetType(), "text", "AlertTimeout();", true);
// Return to Read Only mode
FvUserView.ChangeMode(FormViewMode.ReadOnly);
PageDataRefresh();
}
catch (System.Exception ex)
{
Response.Write("<script LANGUAGE='JavaScript' >alert('An ERROR (" + ex.Message + ") occurred connecting to the database.')</script>");
}
}
private void PageDataRefresh()
{
string uID = Request.QueryString["id"];
if (uID == null || uID == "0")
{
Response.Redirect("~/Admin/RegisterUser.aspx");
}
/* *********** Configure DAL *********** */
UsersAndRolesTableAdapter userAdapter = new UsersAndRolesTableAdapter();
FvUserView.DataSource = userAdapter.GetUserByID(uID);
FvUserView.DataBind();
CheckBoxList Roles_cbl = (CheckBoxList)FvUserView.FindControl("CblRoles");
RolesTableAdapter roleAdapter = new RolesTableAdapter();
Roles_cbl.DataSource = roleAdapter.GetData();
Roles_cbl.DataValueField = "RoleID";
Roles_cbl.DataTextField = "Name";
Roles_cbl.DataBind();
UserRolesTableAdapter userRolesAdapter = new UserRolesTableAdapter();
int RoleCount = (int)userRolesAdapter.CountRolesByUserID(uID);
if (RoleCount > 0)
{
DataTable Roles = userRolesAdapter.GetUserRolesByID(uID).CopyToDataTable();
foreach (DataRow row in Roles.Rows)
{
for (int i = 0; i < Roles_cbl.Items.Count; i++)
{
if (Roles.Rows[Roles.Rows.IndexOf(row)]["Name"].ToString() == Roles_cbl.Items[i].Text.ToString())
{
Roles_cbl.Items[i].Selected = true;
}
}
}
}
}
/* *************************************
* ****** DDL Refresh Subroutines *******
* ************************************* */
private void DdlUserRefresh(string UserValue = "", int UserIndex = 0)
{
UsersAndRolesTableAdapter userAdapter = new UsersAndRolesTableAdapter();
DropDownList ddlUser = (DropDownList)FvDriverView.FindControl("ddlUser");
ddlUser.DataSource = userAdapter.GetUsersNotDrivers(UserValue);
ddlUser.DataValueField = "UserID";
ddlUser.DataTextField = "UserName";
if (UserValue == "" || UserValue == null)
{
ddlUser.SelectedIndex = UserIndex;
}
else
{
ddlUser.SelectedValue = UserValue;
}
ddlUser.DataBind();
}
