private void BindGridViewResults()
{
OdsResults.EnablePaging = true;
OdsResults.MaximumRowsParameterName = "maximumRows";
OdsResults.StartRowIndexParameterName = "startRowIndex";
OdsResults.TypeName = "SouthStarTitleBLL.BLL.UserBLL";
OdsResults.SelectMethod = "GetUsers";
OdsResults.SelectParameters.Add("sortExpression", SortExpression);
OdsResults.SelectCountMethod = "GetUsersCount";
UsersGridView.DataSourceID = OdsResults.ID;
UsersGridView.DataSource = OdsResults;
UsersGridView.DataBind();
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
UsersBLL user = new UsersBLL();
if (user.AddUser(AccountNameTextBox.Text, DisplayNameTextBox.Text, EmailTextBox.Text, Convert.ToInt32(DefaultViewDropDownList.SelectedValue), null, ActiveCheckBox.Checked, Convert.ToInt32(ManagerIDDropDownList.SelectedValue), Convert.ToInt32(SectionIDDropDownList.SelectedValue)))
{
InfoBarLabel.Text = "User Added!!";
UsersGridView.DataBind();
}
else
{
InfoBarLabel.Text = "Error: User not added.";
}
}
private void FillUsersGrid()
{
try
{
bool isadmin = false;
DataTable sa = VSWebBL.SecurityBL.UsersBL.Ins.GetIsAdmin1(Session["UserID"].ToString());
if (sa.Rows.Count > 0)
{
if (sa.Rows[0]["SuperAdmin"].ToString() == "Y")
{
isadmin = true;
}
}
if (isadmin)
{
UsersGridView.Columns["IsConsoleComm"].Visible = true;
UsersGridView.Columns["IsConsoleComm"].ShowInCustomizationForm = true;
}
else
{
UsersGridView.Columns[0].Visible = false;
UsersGridView.Columns[1].Visible = false;
UsersGridView.Columns[2].Visible = false;
}
UsersDataTable = new DataTable();
DataSet UsersDataSet = new DataSet();
UsersDataTable = VSWebBL.SecurityBL.UsersBL.Ins.GetAllData();
if (UsersDataTable.Rows.Count > 0)
{
DataTable dtcopy = UsersDataTable.Copy();
dtcopy.PrimaryKey = new DataColumn[] { dtcopy.Columns["ID"] };
Session["Users"] = dtcopy;
UsersGridView.DataSource = dtcopy;
UsersGridView.DataBind();
}
else
{
UsersGridView.DataSource = UsersDataTable;
//Session{Newname"]=UsersDataTable.rows[0].columns["LoginName"].text;
UsersGridView.DataBind();
}
}
catch (Exception ex)
{
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
protected void UserGridBind(object sender, EventArgs e)
{
BanUserH.Visible = true;
BanUser.Visible = true;
GeneralUsInfoHead.Visible = true;
GeneralUsInfo.Visible = true;
string username = Username.Text;
string email = Email.Text;
string country = Country.Text;
string languages = lang.Text;
DataTable listUsers = UserInfo.RetrieveUserTableByCredentials(username, email, country, languages);
UsersGridView.DataSource = listUsers;
UsersGridView.DataBind();
}
protected void ItemsGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
var gridView = (GridView)sender;
if (e.CommandName == "DeleteItem")
{
Membership.DeleteUser(e.CommandArgument.ToString());
UsersGridView.DataBind();
}
if (e.CommandName == "SelectItem")
{
// If event was atatched then...
RiseUserSelected(e);
}
}
protected void ActionUpdateUser_Click(object sender, EventArgs e)
{
if (UsersGridView.SelectedIndex >= 0)
{
MembershipUser Current = _MyUsers[(string)UsersGridView.SelectedValue];
Current.Email = EmailText.Text;
Current.Comment = CommentText.Text;
Current.IsApproved = IsApprovedCheck.Checked;
Membership.UpdateUser(Current);
// Refresh the grids view
UsersGridView.DataBind();
}
}
protected void btnAddPassword_Click(object sender, EventArgs e)
{
if (txtPassword.Text != txtConfirmPassword.Text)
{
lblPasswordCheck.Text = "Your password and confirmation password do not match.";
}
else
{
AddPasswordByUserId(UserId);
BindGridViewResults();
tblUserGrid.Visible = true;
tblUserForm.Visible = false;
UsersGridView.EditIndex = -1;
UsersGridView.DataBind();
}
}
protected void UserDetailsView_ItemInserted(object sender, EventArgs e)
{
DetailsView udv = (DetailsView)sender;
TextBox sp = (TextBox)udv.FindControl("SubscProducts");
//udv.ro
UsersGridView.DataBind();
//sindex = UsersGridView.Rows.Count;
// GridViewRow r = UsersGridView.Rows[sindex];
//UsersGridView.SelectedIndex = sindex;
// UsersGridView.SelectRow(sindex);
}
private void BindUserAccounts()
{
int totalRecords;
MembershipUserCollection allUsers = Membership.GetAllUsers(this.PageIndex, this.PageSize, out totalRecords);
if (UserRoles.SelectedIndex > 0)
{
allUsers = Membership.GetAllUsers();
}
MembershipUserCollection filteredUsers = new MembershipUserCollection();
if (UserRoles.SelectedIndex > 0)
{
string[] usersInRole = Roles.GetUsersInRole(UserRoles.SelectedValue);
foreach (MembershipUser user in allUsers)
{
foreach (string userInRole in usersInRole)
{
if (userInRole == user.UserName && user.IsApproved)
{
filteredUsers.Add(user);
break;
}
}
}
}
else
{
filteredUsers = allUsers;
}
bool visitingFirstPage = (this.PageIndex == 0);
lnkFirst.Enabled = !visitingFirstPage;
lnkPrev.Enabled = !visitingFirstPage;
int lastPageIndex = (totalRecords - 1) / this.PageSize;
bool visitingLastPage = (this.PageIndex >= lastPageIndex);
lnkNext.Enabled = !visitingLastPage;
lnkLast.Enabled = !visitingLastPage;
UsersGridView.DataSource = filteredUsers;
UsersGridView.DataBind();
}
protected void UsersGridView_Sorting(object sender, GridViewSortEventArgs e)
{
String sortParam = "[" + e.SortExpression + "]";
SortExpression = sortParam;
OdsResults.EnablePaging = true;
OdsResults.MaximumRowsParameterName = "maximumRows";
OdsResults.StartRowIndexParameterName = "startRowIndex";
OdsResults.TypeName = "SouthStarTitleBLL.BLL.UserBLL";
OdsResults.SelectMethod = "GetUsers";
OdsResults.SelectParameters.Add("sortExpression", SortExpression);
OdsResults.SelectCountMethod = "GetUsersCount";
UsersGridView.DataSourceID = OdsResults.ID;
UsersGridView.DataSource = OdsResults;
UsersGridView.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
ArrayList dnnUsersArrayList = UserController.GetUsers(PortalId);
if (dnnUsersArrayList.Count == 0)
{
ExportButton.Visible = false;
ExportTypeDropDown.Visible = false;
}
ArrayList stuffedUsers = new ArrayList();
DataTable output = new DataTable("ASA");
output.Columns.Add("DisplayName");
output.Columns.Add("Email");
output.Columns.Add("Roles");
output.Columns.Add("UserID");
foreach (UserInfo user in dnnUsersArrayList)
{
string roles = string.Join(",", user.Roles);
DataRow dr;
dr = output.NewRow();
dr["DisplayName"] = user.DisplayName;
dr["Email"] = user.Email;
dr["Roles"] = roles;
dr["UserID"] = user.UserID;
output.Rows.Add(dr);
}
UsersGridView.DataSource = output;
if (!IsPostBack)
{
UsersGridView.DataBind();
}
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
private void BindUserAccounts()
{
MembershipUserCollection allUsers = Membership.GetAllUsers();
MembershipUserCollection filteredUsers = new MembershipUserCollection();
bool isOnline = true;
foreach (MembershipUser user in allUsers)
{
if (user.IsOnline == isOnline)
{
filteredUsers.Add(user);
}
}
UsersGridView.DataSource = filteredUsers;
UsersGridView.DataBind();
}
// create datasource for user gridview
private void BindUserAccounts()
{
int totalRecords;
MembershipUserCollection allUsers = Membership.GetAllUsers(this.PageIndex, this.PageSize, out totalRecords);
MembershipUserCollection filteredUsers = new MembershipUserCollection();
if (UserRoles.SelectedIndex > 0)
{
string[] usersInRole = Roles.GetUsersInRole(UserRoles.SelectedValue);
foreach (MembershipUser user in allUsers)
{
foreach (string userInRole in usersInRole)
{
if (userInRole == user.UserName)
{
filteredUsers.Add(user);
// Break out of the inner foreach loop to avoid unneeded checking.
break;
}
}
}
}
else
{
filteredUsers = allUsers;
}
// Enable/disable the pager buttons based on which page we're on
bool visitingFirstPage = (this.PageIndex == 0);
lnkFirst.Enabled = !visitingFirstPage;
lnkPrev.Enabled = !visitingFirstPage;
int lastPageIndex = (totalRecords - 1) / this.PageSize;
bool visitingLastPage = (this.PageIndex >= lastPageIndex);
lnkNext.Enabled = !visitingLastPage;
lnkLast.Enabled = !visitingLastPage;
UsersGridView.DataSource = filteredUsers;
UsersGridView.DataBind();
}
private void BindUserAccounts()
{
List <SueetieDownload> _sueetieDownloads = SueetieDownloadList();
UsersGridView.DataSource = _sueetieDownloads.Skip(this.PageIndex * this.PageSize).Take(this.PageSize);
UsersGridView.DataBind();
int totalRecords = _sueetieDownloads.Count;
bool visitingFirstPage = (this.PageIndex == 0);
lnkFirst.Enabled = !visitingFirstPage;
lnkPrev.Enabled = !visitingFirstPage;
int lastPageIndex = (totalRecords - 1) / this.PageSize;
bool visitingLastPage = (this.PageIndex >= lastPageIndex);
lnkNext.Enabled = !visitingLastPage;
lnkLast.Enabled = !visitingLastPage;
}
// create datasource for user gridview
private void BindUserAccounts()
{
int totalRecords;
UsersGridView.DataSource = Membership.GetAllUsers(this.PageIndex, this.PageSize, out totalRecords);
UsersGridView.DataBind();
// Enable/disable the pager buttons based on which page we're on
bool visitingFirstPage = (this.PageIndex == 0);
lnkFirst.Enabled = !visitingFirstPage;
lnkPrev.Enabled = !visitingFirstPage;
int lastPageIndex = (totalRecords - 1) / this.PageSize;
bool visitingLastPage = (this.PageIndex >= lastPageIndex);
lnkNext.Enabled = !visitingLastPage;
lnkLast.Enabled = !visitingLastPage;
}
// create datasource for user gridview
private void BindUserAccounts()
{
int totalRecords;
MembershipUserCollection allUsers = Membership.GetAllUsers(this.PageIndex, this.PageSize, out totalRecords);
MembershipUserCollection filteredUsers = new MembershipUserCollection();
// create boolean for dropdown control list
bool isActive;
if (active.SelectedValue == "Active Accounts")
{
isActive = true;
}
else
{
isActive = false;
}
// create boolean Values for dropdown list
foreach (MembershipUser user in allUsers)
{
if (user.IsApproved == isActive)
{
filteredUsers.Add(user);
}
}
// Enable/disable the pager buttons based on which page we're on
bool visitingFirstPage = (this.PageIndex == 0);
lnkFirst.Enabled = !visitingFirstPage;
lnkPrev.Enabled = !visitingFirstPage;
int lastPageIndex = (totalRecords - 1) / this.PageSize;
bool visitingLastPage = (this.PageIndex >= lastPageIndex);
lnkNext.Enabled = !visitingLastPage;
lnkLast.Enabled = !visitingLastPage;
UsersGridView.DataSource = filteredUsers;
UsersGridView.DataBind();
}
protected void UsersGridView_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable dt = (DataTable)ViewState["dirState"];
if (dt.Rows.Count > 0)
{
if (Convert.ToString(ViewState["sortdr"]) == "Asc")
{
dt.DefaultView.Sort = e.SortExpression;
ViewState["sortdr"] = "Desc";
}
else
{
dt.DefaultView.Sort = e.SortExpression;
ViewState["sortdr"] = "Asc";
}
UsersGridView.DataSource = dt;
UsersGridView.DataBind();
}
}
private void BindUserAccounts()
{
List <SiteLogEntry> siteLog = SiteLogEntryList();
UsersGridView.DataSource = siteLog.Skip(this.PageIndex * this.PageSize).Take(this.PageSize);
UsersGridView.DataBind();
int totalRecords = siteLog.Count;
// Enable/disable the pager buttons based on which page we're on
bool visitingFirstPage = (this.PageIndex == 0);
lnkFirst.Enabled = !visitingFirstPage;
lnkPrev.Enabled = !visitingFirstPage;
int lastPageIndex = (totalRecords - 1) / this.PageSize;
bool visitingLastPage = (this.PageIndex >= lastPageIndex);
lnkNext.Enabled = !visitingLastPage;
lnkLast.Enabled = !visitingLastPage;
}
private void BindUsersGridView()
{
//if (String.Empty.Equals(FilterUsersTextBox.Text.Trim()))
//{
// UsersGridView.DataSource = Membership.GetAllUsers();
//}
//else
//{
// List<MembershipUser> filteredUsers = new List<MembershipUser>();
// string filterText = FilterUsersTextBox.Text.Trim();
// foreach (MembershipUser user in Membership.GetAllUsers())
// {
// if (user.UserName.Contains(filterText) ||
// user.Email.Contains(filterText))
// {
// filteredUsers.Add(user);
// }
// }
// UsersGridView.DataSource = filteredUsers;
//}
UsersGridView.DataBind();
}
private void FillUsersGridfromSession()
{
try
{
UsersDataTable = new DataTable();
if (Session["Users"] != null && Session["Users"] != "")
{
UsersDataTable = (DataTable)Session["Users"];
}
if (UsersDataTable.Rows.Count > 0)
{
UsersGridView.DataSource = UsersDataTable;
UsersGridView.DataBind();
}
}
catch (Exception ex)
{
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
private void BindUsersGridView()
{
if (String.Empty.Equals(FilterUsersTextBox.Text.Trim()))
{
UsersGridView.DataSource = Membership.GetAllUsers();
}
else
{
List <MembershipUser> filteredUsers = new List <MembershipUser>();
string filterText = FilterUsersTextBox.Text.Trim();
foreach (MembershipUser user in Membership.GetAllUsers())
{
if (user.UserName.Contains(filterText) ||
user.Email.Contains(filterText))
{
filteredUsers.Add(user);
}
}
UsersGridView.DataSource = filteredUsers;
}
UsersGridView.DataBind();
}
private void BindAllUsers(bool reloadAllUsers)
{
MembershipUserCollection allUsers = null;
if (reloadAllUsers)
{
allUsers = Membership.GetAllUsers();
}
string searchText = "";
if (!string.IsNullOrEmpty(UsersGridView.Attributes["SearchText"]))
{
searchText = UsersGridView.Attributes["SearchText"];
}
bool searchByEmail = false;
if (!string.IsNullOrEmpty(UsersGridView.Attributes["SearchByEmail"]))
{
searchByEmail = bool.Parse(UsersGridView.Attributes["SearchByEmail"]);
}
if (searchText.Length > 0)
{
if (searchByEmail)
{
allUsers = Membership.FindUsersByEmail(searchText);
}
else
{
allUsers = Membership.FindUsersByName(searchText);
}
}
else
{
allUsers = allRegisteredUsers;
}
UsersGridView.DataSource = allUsers;
UsersGridView.DataBind();
}
protected void UsersearchTextBox_TextChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PharmacyConnectionString"].ConnectionString);
conn.Open();
{
if (UsersearchTextBox.Text == " ")
{
PopulateGridView();
}
else
{
SqlCommand command = new SqlCommand("searchusers", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@name", UsersearchTextBox.Text);
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dt);
UsersGridView.DataSource = dt;
UsersGridView.DataBind();
}
}
}
private void BindUserAccounts()
{
UsersGridView.DataSource = SueetieUsers.GetInactiveUserList();
UsersGridView.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
PopulateRoleList(Session["userID"].ToString());
InfoBarLabel.Text = String.Empty;
UsersGridView.DataBind();
}
private void BindUserAccounts()
{
UsersGridView.DataSource = SueetieUsers.GetUnapprovedUserList();
UsersGridView.DataBind();
}
private void LoadUsersData()
{
if (UsersTable == null)
{
UsersTable = new DataTable("Users");
UsersTable.Columns.Add("Id", typeof(string));
UsersTable.Columns.Add("UserName", typeof(string));
UsersTable.Columns.Add("Email", typeof(string));
UsersTable.Columns.Add("PhoneNumber", typeof(string));
DataColumn[] keys = new DataColumn[] { UsersTable.Columns[0] };
UsersTable.PrimaryKey = keys;
}
else
{
UsersTable.Rows.Clear();
}
var context = new ApplicationDbContext();
var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
var users = userManager.Users;
foreach (var user in users)
{
var row = UsersTable.NewRow();
row["Id"] = user.Id;
row["UserName"] = user.UserName;
row["Email"] = user.Email;
row["PhoneNumber"] = user.PhoneNumber;
UsersTable.Rows.Add(row);
UsersTable.AcceptChanges();
}
UsersGridView.DataSource = UsersTable;
UsersGridView.DataBind();
MUsersGridView.DataSource = UsersTable;
MUsersGridView.DataBind();
if (RolesTable == null)
{
RolesTable = new DataTable("Roles");
RolesTable.Columns.Add("Id", typeof(string));
RolesTable.Columns.Add("Name", typeof(string));
RolesTable.PrimaryKey = new DataColumn[] { RolesTable.Columns["Id"] };
}
else
{
RolesTable.Rows.Clear();
}
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
var roles = roleManager.Roles;
foreach (var role in roles)
{
var row = RolesTable.NewRow();
row["Id"] = role.Id;
row["Name"] = role.Name;
RolesTable.Rows.Add(row);
RolesTable.AcceptChanges();
}
RolesGridView.DataSource = RolesTable;
RolesGridView.DataBind();
MRolesGridView.DataSource = RolesTable;
MRolesGridView.DataBind();
if (UserInRoles == null)
{
UserInRoles = new DataTable("UserInRoles");
UserInRoles.Columns.Add("Id", typeof(string));
UserInRoles.Columns.Add("Name", typeof(string));
UserInRoles.PrimaryKey = new DataColumn[] { UserInRoles.Columns["Id"] };
}
MUserInRolesGridView.DataSource = UserInRoles;
}
/// <summary>
/// Handles the SelectedIndexChanged event of the OperatorRadioButtonList control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void OperatorRadioButtonList_SelectedIndexChanged(object sender, EventArgs e)
{
if (OperatorRadioButtonList.SelectedValue == "archive")
{
Session["StartIndex"] = 0;
LotusDataContext db = new LotusDataContext(Data.ConnectionManager());
var source2 = (from b in db.bookings
join p in db.pages on b.page_id equals p.page_id
where (b.status != "NEW")
orderby b.id descending
select new
{
ID = b.id,
User = b.user_name,
Service = p.title,
Date = b.submited_date.ToString(),
Status = b.status
}).Distinct();
ArchivesGridView.DataSource = source2.Skip(0).Take(20);
ArchivesGridView.DataBind();
List <ListItem> items = new List <ListItem>();
items.Add(new ListItem("All", "All"));
foreach (MembershipUser user in Membership.GetAllUsers())
{
items.Add(new ListItem(user.UserName, user.UserName));
}
UsersDropDownList.DataSource = items;
UsersDropDownList.DataBind();
SearchResultsLabel.Text = "";
ResultsGridView.Visible = false;
UsersGridView.Visible = false;
ArchivesPanel.Visible = true;
AcceptedButton.Visible = false;
DeclineButton.Visible = false;
UserDetailsView.Visible = false;
ChatButton.Visible = false;
}
if (OperatorRadioButtonList.SelectedValue == "active")
{
ArchivesPanel.Visible = false;
UsersGridView.Visible = false;
ChatLogDataList.Visible = false;
ResultsGridView.Visible = true;
AcceptedButton.Visible = true;
DeclineButton.Visible = true;
ChatLogButton.Visible = false;
UserDetailsView.Visible = false;
}
if (OperatorRadioButtonList.SelectedValue == "users")
{
UsersGridView.DataSource = Membership.GetAllUsers();
UsersGridView.DataBind();
ResultsGridView.Visible = false;
ArchivesPanel.Visible = false;
UsersGridView.Visible = true;
UserDetailsView.Visible = false;
}
}
private void BindUserAccounts()
{
UsersGridView.DataSource = SueetieTaskScheduler.Instance().Tasks;
UsersGridView.DataBind();
}
protected void NewUserDetailsView_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
{
// Refresh the GridView to display the new record
UsersGridView.DataBind();
}
