private void DeleteUser_Click(object sender, RoutedEventArgs e)
{
if (UserList.SelectedItems.Count > 1)
{
foreach (var item in UserList.SelectedItems)
{
try
{
db.TableUsers.Remove((TableUsers)item);
db.SaveChanges();
}
catch (Exception) {}
}
}
else
{
TableUsers user = (TableUsers)UserList.SelectedItem;
try
{
db.TableUsers.Remove(user);
db.SaveChanges();
}
catch (Exception) {}
}
UserList.ItemsSource = db.TableUsers.ToList();
}
public DbManager()
{
this.tableIngredients = new TableIngredients();
this.tableProducts = new TableProducts();
this.tablePurchases = new TablePurchases();
this.tableUsers = new TableUsers();
}
/// <summary>
/// Method that called on Clicking Export to Excel
/// </summary>
/// <param name="sender">Event Source</param>
/// <param name="eventArgument">Event Data</param>
protected void ImageButtonXLS_Click(object sender, ImageClickEventArgs eventArgument)
{
actionButton = "Export";
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=Users.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stirngWriter = new System.IO.StringWriter(CultureInfo.InvariantCulture);
System.Web.UI.HtmlTextWriter htmlWriter = new HtmlTextWriter(stirngWriter);
GetUsers();
TableUsers.BorderWidth = 1;
TableUsers.RenderControl(htmlWriter);
Response.Write(stirngWriter.ToString());
Response.End();
}
private void ButtonAddUser_Click(object sender, RoutedEventArgs e)
{
TableUsers newUser = new TableUsers();
newUser.lName = lName.Text;
newUser.Login = Login.Text;
newUser.Password = Password.Password;
newUser.CityId = 0;
TableCity city = (TableCity)CityId.SelectedItem;
if (city != null)
{
newUser.CityId = city.CityId;
}
if (string.IsNullOrEmpty(newUser.lName) || string.IsNullOrEmpty(newUser.Login))
{
ErrMessage.Content = "Заполните обязательные поля";
ErrMessage.Foreground = new SolidColorBrush(Colors.Red);
}
else
{
try
{
db.TableUsers.Add(newUser);
db.SaveChanges();
ErrMessage.Content = "Пользователь добавлен!";
ErrMessage.Foreground = new SolidColorBrush(Colors.Green);
ErrMessage.FontWeight = FontWeights.Bold;
}
catch (Exception ex)
{
ErrMessage.Content = "Пользователь не добавлен: " + ex.Message;
ErrMessage.Foreground = new SolidColorBrush(Colors.Red);
ErrMessage.FontWeight = FontWeights.Bold;
}
}
}
private DbManager()
{
TableCards = new TableCards();
TableUsers = new TableUsers();
}
