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(); }