private void AddUserButton_Click(System.Object sender,
System.EventArgs e)
{
Database db;
User usr;
try
{
db = (Database)DatabasesComboBox.SelectedItem;
// Create the user object
usr = new User(db, UserNameTextBox.Text);
usr.Login = LoginsComboBox.Text;
usr.Create();
ShowUsers();
// Select the user we just created and make sure it's viewable
ListViewItem UsersListViewItem = UsersListView.
FindItemWithText(UserNameTextBox.Text);
UsersListViewItem.Selected = true;
UsersListViewItem.EnsureVisible();
}
catch (SmoException ex)
{
ExceptionMessageBox emb = new ExceptionMessageBox(ex);
emb.Show(this);
}
}
private void Searching(object sender, TextChangedEventArgs e)
{
if (searchBar.Text == "")
{
Foter.IsVisible = true;
}
else
{
Foter.IsVisible = false;
}
var container = BindingContext as UsersListViewModel;
UsersListView.BeginRefresh();
if (string.IsNullOrWhiteSpace(e.NewTextValue))
{
UsersListView.ItemsSource = container.Users;
}
else
{
UsersListView.ItemsSource = container.Users.Where(i => (i.FirstName.ToLower() + " " + i.LastName.ToLower()).Contains(e.NewTextValue.ToLower()));
}
UsersListView.EndRefresh();
}
protected void SortButton_Click(object sender, EventArgs e)
{
sortingString = SortList.SelectedValue;
sortingDir = SortDirectionList.SelectedValue == "DESC"
? SortDirection.Descending
: SortDirection.Ascending;
UsersListView.Sort(sortingString, sortingDir);
}
protected void RemoveButton_Click(object sender, EventArgs e)
{
var db = new ApplicationDbContext();
foreach (var item in UserStateTransitionListView.Items)
{
var chk = item.FindControl("chkSelectOneUser") as CheckBox;
if (chk.Checked)
{
var ustID = (long)UserStateTransitionListView.DataKeys[item.DisplayIndex].Value;
var ust = db.UserStateTransitions.Single(u => u.UserStateTransitionID == ustID);
db.UserStateTransitions.Remove(ust);
}
}
if (db.ChangeTracker.HasChanges())
{
db.SaveChanges();
UserStateTransitionListView.DataBind();
UsersListView.DataBind();
}
}
private void SetupControls()
{
this.mnuUsers.Items[0].Text = Resources.Texts.edit;
this.mnuUsers.Items[1].Text = Resources.Texts.delete;
this.mnuUsers.Items[2].Text = Resources.Texts.disable;
this.mnuUsers.Items[0].Image = DomainModel.Application.ResourceManager.GetImage("pencil");
this.mnuUsers.Items[1].Image = DomainModel.Application.ResourceManager.GetImage("delete");
this.mnuUsers.Items[2].Image = DomainModel.Application.ResourceManager.GetImage("closed_lock");
EnableButtons(false);
this.lsvUsers = new UsersListView();
this.lsvUsers.ContextMenuStrip = this.mnuUsers;
this.tlpMain.Controls.Add(this.lsvUsers, 0, 1);
this.lsvUsers.MouseUp += new MouseEventHandler(lsvUsers_MouseUp);
this.lsvUsers.SelectedIndexChanged += new EventHandler(lsvUsers_SelectedIndexChanged);
this.btnAddUser.Click += new EventHandler(btnAddUser_Click);
this.btnDeleteUser.Click += new EventHandler(btnDeleteUser_Click);
this.btnEditUser.Click += new EventHandler(btnEditUser_Click);
this.btnEnableUser.Click += new EventHandler(btnEnableUser_Click);
}
protected void AddButton_Click(object sender, EventArgs e)
{
var db = new ApplicationDbContext();
foreach (var item in UsersListView.Items)
{
var chk = item.FindControl("chkSelectOneUser") as CheckBox;
if (chk.Checked)
{
var ust = new UserStateTransition();
ust.UserID = UsersListView.DataKeys[item.DisplayIndex].Value.ToString();
ust.WorkflowStateTransitionID = long.Parse(Request.QueryString["WorkflowStateTransitionID"]);
db.UserStateTransitions.Add(ust);
//string dii = UsersListView.DataKeys[item.DataItemIndex].Value.ToString();
}
}
if (db.ChangeTracker.HasChanges())
{
db.SaveChanges();
UserStateTransitionListView.DataBind();
UsersListView.DataBind();
}
}
