//txbEmail_TextChanged private void txbEmail_TextChanged(object sender, TextChangedEventArgs e) { if (flag_zero_load == true) { try { EC_tb_User ec_tb_user = GetUser(); HandleControl(); imgEmail.Visibility = System.Windows.Visibility.Visible; if (bus_tb_user.UpdateUser(ec_tb_user, StaticClass.GeneralClass.flag_database_type_general) == 1) { imgEmail.Source = ok_bitmapimage; } else { imgEmail.Source = failed_bitmapimage; } } catch (Exception ex) { Pages.Notification page = new Pages.Notification(); page.tblNotification.Text = ex.Message; page.ShowDialog(); } } }
//InSertAllUser private int InSertAllUser(DataTable tb_user) { int result = 0; foreach (DataRow datarow in tb_user.Rows) { if (datarow[0].ToString() != "") { EC_tb_User ec_tb_user = new EC_tb_User(); ec_tb_user.ID = Convert.ToInt32(datarow[0].ToString()); ec_tb_user.Name = datarow[1].ToString(); ec_tb_user.Email = datarow[2].ToString(); ec_tb_user.Address = datarow[3].ToString(); ec_tb_user.Password = datarow[4].ToString(); ec_tb_user.Question = datarow[5].ToString(); ec_tb_user.Answer = datarow[6].ToString(); if (bus_tb_user.InsertUser(ec_tb_user, StaticClass.GeneralClass.flag_database_type_general) == 1) { result++; } } } return(result); }
//GetUser private EC_tb_User GetUser() { EC_tb_User ec_tb_user = new EC_tb_User(); ec_tb_user.ID = Convert.ToInt32(tblID.Text.Trim().ToString()); ec_tb_user.Name = StaticClass.GeneralClass.HandlingSpecialCharacter(tblUserName.Text.Trim().ToString()); ec_tb_user.Email = StaticClass.GeneralClass.HandlingSpecialCharacter(txbEmail.Text.Trim().ToString()); ec_tb_user.Address = StaticClass.GeneralClass.HandlingSpecialCharacter(txbAddress.Text.Trim().ToString()); ec_tb_user.Password = StaticClass.GeneralClass.HandlingSpecialCharacter(StaticClass.GeneralClass.password_user_general); ec_tb_user.Question = StaticClass.GeneralClass.HandlingSpecialCharacter(txbQuestion.Text.Trim().ToLower()); ec_tb_user.Answer = StaticClass.GeneralClass.HandlingSpecialCharacter(txbAnswer.Text.Trim().ToLower()); return(ec_tb_user); }
//btnChange_Click private void btnChange_Click(object sender, RoutedEventArgs e) { try { if (pwbNewPassword.Password.Trim() == "") { tblNotification.Text = FindResource("new_password_null").ToString(); pwbNewPassword.Focus(); return; } if (pwbNewPassword.Password.Trim().Length < 3) { tblNotification.Text = FindResource("password_short").ToString(); pwbNewPassword.Focus(); return; } if (pwbConfirmPassword.Password.Trim() == "") { tblNotification.Text = FindResource("confirm_password_null").ToString(); pwbConfirmPassword.Focus(); return; } if (pwbNewPassword.Password.Trim() != pwbConfirmPassword.Password.Trim().ToString()) { tblNotification.Text = FindResource("new_password_confirm_password_incorrect").ToString(); pwbNewPassword.Focus(); return; } else { EC_tb_User ec_tb_user = new EC_tb_User(); ec_tb_user.ID = 1; ec_tb_user.Password = StaticClass.GeneralClass.MD5Hash(pwbNewPassword.Password.Trim()); if (bus_tb_user.UpdatePasswordUser(ec_tb_user, StaticClass.GeneralClass.flag_database_type_general) == 1) { BBCodeBlock bbcodeblock = new BBCodeBlock(); bbcodeblock.LinkNavigator.Navigate(new Uri(@"/Pages/Home/Login.xaml", UriKind.Relative), this); } } } catch (Exception ex) { tblNotification.Text = ex.Message; } }
//update password user public int UpdatePasswordUser(EC_tb_User ec_tb_use, bool data_type) { string sql = ""; if (!data_type) { sql = "UPDATE [tb_User] SET [Password] = '" + ec_tb_use.Password + "' WHERE [ID] = " + ec_tb_use.ID; } else { sql = "UPDATE [tb_User] SET [Password] = N'" + ec_tb_use.Password + "' WHERE [ID] = " + ec_tb_use.ID; } return(ConnectionDB.ExecuteNonQuery(sql)); }
//update User non password public int UpdateUserNonPassword(EC_tb_User ec_tb_use, bool data_type) { string sql = ""; if (!data_type) { sql = "UPDATE [tb_User] SET [Name] ='" + ec_tb_use.Name + "', [Email] = '" + ec_tb_use.Email + "', [Address] = '" + ec_tb_use.Address + "', [Question] ='" + ec_tb_use.Question + "',[Answer] ='" + ec_tb_use.Answer + "' WHERE [ID]=" + ec_tb_use.ID; } else { sql = "UPDATE [tb_User] SET [Name] = N'" + ec_tb_use.Name + "', [Email] = N'" + ec_tb_use.Email + "', [Address] = N'" + ec_tb_use.Address + "', [Question] = N'" + ec_tb_use.Question + "', [Answer] = N'" + ec_tb_use.Answer + "' WHERE [ID] = " + ec_tb_use.ID; } return(ConnectionDB.ExecuteNonQuery(sql)); }
//insert User public int InsertUser(EC_tb_User ec_tb_use, bool data_type) { string sql = ""; if (!data_type) { sql = "INSERT INTO [tb_User] ([Name],[Email],[Address],[Password],[Question],[Answer]) VALUES('" + ec_tb_use.Name + "','" + ec_tb_use.Email + "','" + ec_tb_use.Address + "','" + ec_tb_use.Password + "','" + ec_tb_use.Question + "','" + ec_tb_use.Answer + "')"; } else { sql = "INSERT INTO [tb_User] ([Name],[Email],[Address],[Password],[Question],[Answer]) VALUES(N'" + ec_tb_use.Name + "', N'" + ec_tb_use.Email + "', N'" + ec_tb_use.Address + "', N'" + ec_tb_use.Password + "', N'" + ec_tb_use.Question + "', N'" + ec_tb_use.Answer + "')"; } return(ConnectionDB.ExecuteNonQuery(sql)); }
//delete User public int DeleteUser(EC_tb_User ec_tb_use) { string sql = "DELETE FROM [tb_User] WHERE [ID]=" + ec_tb_use.ID; return(ConnectionDB.ExecuteNonQuery(sql)); }
public bool Kiemtrauser(EC_tb_User user) { string sql = "select count(*) from tb_User where Username ='******' and Password = '******'"; return(cn.KiemtraUsername(sql)); }
//btnOK_Click private void btnOK_Click(object sender, RoutedEventArgs e) { try { EC_tb_User ec_tb_user = new EC_tb_User(); ec_tb_user.ID = Convert.ToInt32(tblID.Text.Trim().ToString()); ec_tb_user.Name = StaticClass.GeneralClass.HandlingSpecialCharacter(tblName.Text.Trim().ToString()); ec_tb_user.Email = StaticClass.GeneralClass.HandlingSpecialCharacter(txbEmail.Text.Trim().ToString()); ec_tb_user.Address = StaticClass.GeneralClass.HandlingSpecialCharacter(txbAddress.Text.Trim().ToString()); ec_tb_user.Question = StaticClass.GeneralClass.HandlingSpecialCharacter(txbQuestion.Text.Trim().ToString()); ec_tb_user.Answer = StaticClass.GeneralClass.HandlingSpecialCharacter(txbAnswer.Text.Trim().ToString()); if (pwbPassword.Password.Trim() == "" && pwbConfirmPassword.Password.Trim() != "") { tblNotification.Text = FindResource("password_null").ToString(); pwbConfirmPassword.Focus(); return; } if (pwbPassword.Password != "" && pwbConfirmPassword.Password == "") { tblNotification.Text = FindResource("confirm_password_null").ToString(); pwbPassword.Focus(); return; } if (pwbPassword.Password.Trim() != "" && pwbConfirmPassword.Password.Trim() != "") { if (pwbPassword.Password != pwbConfirmPassword.Password) { tblNotification.Text = FindResource("new_password_confirm_password_incorrect").ToString(); pwbConfirmPassword.Focus(); return; } else { ec_tb_user.Password = StaticClass.GeneralClass.MD5Hash(pwbPassword.Password.Trim().ToString()); if (bus_tb_user.UpdateUser(ec_tb_user, StaticClass.GeneralClass.flag_database_type_general) == 1) { if (btnedit_delegate != null) { btnedit_delegate(); this.Close(); } } else { ec_tb_user.Password = ""; } } } else { if (bus_tb_user.UpdateUserNonPassword(ec_tb_user, StaticClass.GeneralClass.flag_database_type_general) == 1) { if (btnedit_delegate != null) { btnedit_delegate(); this.Close(); } } } } catch (Exception ex) { tblNotification.Text = ex.Message; } }
//btnOK_Click private void btnOK_Click(object sender, RoutedEventArgs e) { try { if (pwbCurrentPassword.Password.Trim() == "") { tblNotification.Text = FindResource("current_password_null").ToString(); pwbCurrentPassword.Focus(); return; } if (pwbNewPassword.Password.Trim() == "") { tblNotification.Text = FindResource("new_password_null").ToString(); pwbNewPassword.Focus(); return; } if (pwbNewPassword.Password.Trim().Length < 3) { tblNotification.Text = FindResource("password_short").ToString(); pwbNewPassword.Focus(); return; } if (pwbConfirmPassword.Password.Trim() == "") { tblNotification.Text = FindResource("confirm_password_null").ToString(); pwbConfirmPassword.Focus(); return; } else { if (StaticClass.GeneralClass.MD5Hash(pwbCurrentPassword.Password.Trim().ToString()) != StaticClass.GeneralClass.password_user_general) { tblNotification.Text = FindResource("current_password_incorrect").ToString(); pwbCurrentPassword.Focus(); return; } if (StaticClass.GeneralClass.MD5Hash(pwbNewPassword.Password.Trim().ToString()) != StaticClass.GeneralClass.MD5Hash(pwbConfirmPassword.Password.Trim().ToString())) { tblNotification.Text = FindResource("new_password_confirm_password_incorrect").ToString(); pwbConfirmPassword.Focus(); return; } else { EC_tb_User ec_tb_user = new EC_tb_User(); ec_tb_user.ID = StaticClass.GeneralClass.id_user_general; ec_tb_user.Password = StaticClass.GeneralClass.MD5Hash(pwbNewPassword.Password.Trim().ToString()); if (bus_tb_user.UpdatePasswordUser(ec_tb_user, StaticClass.GeneralClass.flag_database_type_general) == 1) { StaticClass.GeneralClass.password_user_general = ec_tb_user.Password; //return account page BBCodeBlock bbcodeblock = new BBCodeBlock(); bbcodeblock.LinkNavigator.Navigate(new Uri("/Pages/Setting/Account.xaml", UriKind.Relative), this); } } } } catch (Exception ex) { Pages.Notification page = new Pages.Notification(); page.tblNotification.Text = ex.Message; page.ShowDialog(); } }
private void GetUser() { if (thread_content != null && thread_content.ThreadState == ThreadState.Running) { } else { thread_content = new Thread(() => { try { this.grContent.Dispatcher.Invoke((Action)(() => { dtgUser.ItemsSource = null; this.dtgUser.Visibility = System.Windows.Visibility.Hidden; })); this.mpr.Dispatcher.Invoke((Action)(() => { this.mpr.Visibility = System.Windows.Visibility.Visible; this.mpr.IsActive = true; })); tb_user.Clear(); list_ec_tb_user.Clear(); tb_user = bus_tb_user.GetUser(""); foreach (DataRow datarow in tb_user.Rows) { EC_tb_User ec_tb_user = new EC_tb_User(); ec_tb_user.ID = Convert.ToInt32(datarow["ID"].ToString()); ec_tb_user.Name = datarow["Name"].ToString(); ec_tb_user.Email = datarow["Email"].ToString(); ec_tb_user.Address = datarow["Address"].ToString(); ec_tb_user.Password = datarow["Password"].ToString(); ec_tb_user.Question = datarow["Question"].ToString(); ec_tb_user.Answer = datarow["Answer"].ToString(); ec_tb_user.EditImage = @"pack://application:,,,/Resources/edit.png"; list_ec_tb_user.Add(ec_tb_user); } this.tblTotal.Dispatcher.Invoke((Action)(() => { tblTotal.Text = FindResource("total").ToString() + "(" + list_ec_tb_user.Count.ToString() + ")"; })); this.dtgUser.Dispatcher.Invoke((Action)(() => { dtgUser.ItemsSource = list_ec_tb_user; })); Thread.Sleep(500); this.mpr.Dispatcher.Invoke((Action)(() => { this.mpr.Visibility = System.Windows.Visibility.Hidden; this.mpr.IsActive = false; })); this.grContent.Dispatcher.Invoke((Action)(() => { this.dtgUser.Visibility = System.Windows.Visibility.Visible; })); } catch (Exception ex) { this.Dispatcher.Invoke((Action)(() => { ModernDialog md = new ModernDialog(); md.CloseButton.Content = FindResource("close").ToString(); md.Title = FindResource("notification").ToString(); md.Content = ex.Message; md.ShowDialog(); })); } }); thread_content.Start(); } }
//delete User public int DeleteUser(EC_tb_User ec_tb_use) { return(sql_tb_use.DeleteUser(ec_tb_use)); }
//update password user public int UpdatePasswordUser(EC_tb_User ec_tb_use, bool data_type) { return(sql_tb_use.UpdatePasswordUser(ec_tb_use, data_type)); }
//inser User public int InsertUser(EC_tb_User ec_tb_use, bool data_type) { return(sql_tb_use.InsertUser(ec_tb_use, data_type)); }