void DeleteUser() { if (MessageBox.Show("Czy na pewno chcesz usunąć wskazane pozycje?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { try { var sqlString = UserSQL.DeleteUser(); var RecordCount = 0; var sqlParamWithValue = new HashSet <Tuple <string, object> >(); foreach (User U in olvUser.CheckedObjects) { sqlParamWithValue.Add(new Tuple <string, object>("@Login", U.Login)); } using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); RecordCount = dbs.RemoveManyRecordsAsync(sqlString, sqlParamWithValue).Result; } RefreshData(); MessageBox.Show($"{RecordCount} rekordów zostało usuniętych.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void cmdAddNew_Click(object sender, EventArgs e) { using (var dlg = new frmUser(UserSQL.SelectSomeUsers(UserSession.User.Settings.SchoolID.ToString()))) { dlg.cmdClose.Text = "Anuluj"; dlg.cmdSave.Enabled = false; dlg.cmdSave.Visible = true; if (dlg.ShowDialog() == DialogResult.OK) { var TeacherList = new List <Teacher>(); foreach (User U in dlg.olvUser.CheckedObjects) { TeacherList.Add(new Teacher { Login = U.Login, Role = U.Role, Status = U.Status, FirstName = U.FirstName, LastName = U.LastName }); } if (TeacherList.Count == 0) { return; } var Rec = AddSchoolTeacher(TeacherList); if (Rec > 0) { GetData(olvSubject); MessageBox.Show("Dodano rekordów: " + Rec.ToString(), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Ups! Coś poszło nie tak.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }
public int UpdatePassword() { using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(dbs.UpdateRecordAsync(UserSQL.ChangePassword(), CreateUpdateParams()).Result); } }
private void ZarzadzanieUzytkownikamitoolStripMenuItem_Click(object sender, EventArgs e) { var frm = new frmUser(UserSQL.SelectAllUsers()); SetFormProperties(frm); ZarzadzanieUzytkownikamitoolStripMenuItem.Enabled = false; frm.TheEnd += (s, ex) => ZarzadzanieUzytkownikamitoolStripMenuItem.Enabled = true; frm.Show(); }
async Task <long> AddUser() { try { using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.AddRecordAsync(UserSQL.InsertUser(), CreateInsertParams())); } } catch (Exception) { throw; } }
private static async Task <long> LogUserEnterAttempt(string userName, byte status) { try { using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.AddRecordAsync(UserSQL.LogIn(), CreateInsertParams(userName, status))); } } catch (Exception) { throw; } }
public static async Task <IEnumerable <AppUser> > GetUsers() { try { using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.FetchRecordSetAsync(UserSQL.SelectUsers(), UserModel)); } } catch (Exception) { throw; } }
private static async Task LogUserExit(long IdEvent) { try { using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); await dbs.UpdateRecordAsync(UserSQL.LogOut(), new Tuple <string, object>("@IdRecord", IdEvent)); } } catch (Exception) { throw; } }
int AddUser(List <User> usr) { try { var count = 0; var sqlString = UserSQL.InsertUser(); var sqlParamWithValue = new HashSet <IDictionary <string, object> >(); foreach (var U in usr) { var plainPwd = StringHelper.RandomizePassword(); var SaltedPasswordHash = Enigma.HashHelper.CreatePassword(plainPwd); U.Password = Convert.ToBase64String(SaltedPasswordHash); sqlParamWithValue.Add(new Dictionary <string, object> { { "@Login", U.Login }, { "@LastName", U.LastName }, { "@FirstName", U.FirstName }, { "@Password", U.Password }, { "@Role", U.Role }, { "@Status", U.Status }, { "@Sex", U.Sex }, { "@Email", U.Email }, { "@Owner", UserSession.User.Login }, { "@User", UserSession.User.Login }, { "@IP", AppSession.HostIP }, }); U.Password = plainPwd; UsersToPrint.Add(U); } using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); count = dbs.AddManyRecordsAsync(sqlString, sqlParamWithValue).Result.RecordCount; } if (count > 0) { PrintAccountInfo(); } return(count); } catch (Exception ex) { MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return(-1); } }
private void Form1_Load(object sender, EventArgs e) { DataTable dt = UserSQL.getAllUser(); if (dt != null) { this.dataGridView1.Rows.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { this.dataGridView1.Rows.Add(i + 1, dt.Rows[i]["UserName"], dt.Rows[i]["UserRole"], "删除"); this.dataGridView1.Rows[i].Tag = dt.Rows[i]; } } this.dataGridView1.ClearSelection(); }
private void ReFresh() { this.dataGridView1.Rows.Clear(); DataTable dt = UserSQL.getAllUser(); if (dt != null) { this.dataGridView1.Rows.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { this.dataGridView1.Rows.Add(i + 1, dt.Rows[i]["UserName"], dt.Rows[i]["UserRole"], "删除"); this.dataGridView1.Rows[i].Tag = dt.Rows[i]; } } this.dataGridView1.ClearSelection(); }
internal static bool CheckLoginExist(string Login) { //int UserCount = 0; try { using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); int.TryParse(dbs.FetchSingleValueAsync(UserSQL.CountUser(Login)).Result, out int userCount); return(userCount == 0); } } catch (Exception) { throw; } //using (var cmd = new MySql.Data.MySqlClient.MySqlCommand() { CommandText = UserSQL.CountUser(Login), Connection = AppSession.Conn }) //{ // int.TryParse(cmd.ExecuteScalar().ToString(), out UserCount); // return UserCount == 0; //} }
private async Task <int> UpdateUserAsync(dlgUser dlg, string login) { User.UserRole R = User.UserRole.Rodzic; // = (User.UserRole)Enum.Parse(typeof(User.UserRole), dlg.cbRola.SelectedValue.ToString()); Enum.TryParse(dlg.cbRola.SelectedValue.ToString(), out R); var sqlParamWithValue = new Dictionary <string, object>() { { "@Login", login }, { "@Nazwisko", dlg.txtNazwisko.Text.Trim() }, { "@Imie", dlg.txtImie.Text.Trim() }, { "@Rola", R }, { "@Email", dlg.txtEmail.Text.Trim() }, { "@Status", dlg.chkStatus.Checked }, { "@Sex", dlg.chkSex.Checked }, { "@User", UserSession.User.Login }, { "@IP", AppSession.HostIP } }; using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.UpdateRecordAsync(UserSQL.UpdateUser(), sqlParamWithValue)); } }