private void SavePassword() { SqlCommand cmd = new SqlCommand("UPDATE dbo.tblUserAccounts SET UserPassword=@Pass where UserID=@ID"); cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@ID", userid); cmd.Parameters.AddWithValue("@Pass", ClsEncrypt_Decrypt_String.Encrypt(tbPassword.Password.Trim())); SqlHelper.ExecuteNonQuery(ClsConfig.Cantier_LotCardLabelConnectionString, cmd); MessageBox.Show("Record successfully updated"); this.Close(); }
private void TbPassword_KeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Return) { if (!string.IsNullOrEmpty(tbPassword.Password)) { SqlCommand cmdUser = new SqlCommand("select * from dbo.tblUserAccounts where userid = @id"); cmdUser.CommandType = CommandType.Text; cmdUser.Parameters.AddWithValue("@id", _userid); dt3.Clear(); dt3 = SqlHelper.ExecuteDataReader(ClsConfig.OnlineSystemsLoginConnectionString, cmdUser); if (dt3.Rows.Count > 0) { if (!string.IsNullOrEmpty(dt3.Rows[0]["ReprintLotCardPassword"].ToString().Trim())) { if (tbPassword.Password == ClsEncrypt_Decrypt_String.Decrypt(dt3.Rows[0]["ReprintLotCardPassword"].ToString().Trim())) { string[] filePaths = Directory.GetFiles(@"C:\Users\Public\Pictures\"); foreach (string filePath in filePaths) { File.Delete(filePath); } GC.Collect(); GC.WaitForPendingFinalizers(); if (_reportType == "Normal") { if (_cust_acronym == "EPPI") { ShowEPPI(); } else if (_cust_acronym == "CBMP") { ShowCanon(); } else if (_cust_acronym == "FDTP") { ShowFujitsu(); } else if (_cust_acronym == "TRC") { ShowTRC(); } else if (_cust_acronym == "SubCon") { ShowSubCon(); } else { ShowOtherCustomer(); } } else if (_reportType == "Replacement") { if (_cust_acronym == "EPPI") { ShowEPPI_Replacement(); } else if (_cust_acronym == "CBMP") { ShowCanon_Replacement(); } else if (_cust_acronym == "FDTP") { ShowFujitsu_Replacement(); } else if (_cust_acronym == "TRC") { ShowTRC_Replacement(); } else { ShowOtherCustomer_Replacement(); } } else { if (_cust_acronym == "EPPI") { ShowEPPI_Sample(); } else if (_cust_acronym == "CBMP") { ShowCanon_Sample(); } else if (_cust_acronym == "FDTP") { ShowFujitsu_Sample(); } else if (_cust_acronym == "TRC") { ShowTRC_Sample(); } else { ShowOtherCustomer_Sample(); } } this.Close(); } else { MessageBox.Show("Access Denied"); } } else { MessageBox.Show("Access Denied"); } } } } }
private void Userpass_KeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Return) { SqlCommand cmd = new SqlCommand("select * from dbo.tblUserAccounts where " + "Username = '******' and UserPassword = '******' "); cmd.CommandType = CommandType.Text; if (SqlHelper.ExecuteDataReader(ClsConfig.OnlineSystemsLoginConnectionString, cmd).Rows.Count > 0) { foreach (DataRow dr in SqlHelper.ExecuteDataReader(ClsConfig.OnlineSystemsLoginConnectionString, cmd).Rows) { //if (Convert.ToBoolean(dr[8]) == true) //{ MainForm frm = new MainForm(); frm._deptcode = dr[5].ToString().Trim(); frm._sectcode = dr[6].ToString().Trim(); frm._userid = Convert.ToInt32(dr[0]); frm._fullname = dr[3].ToString(); frm.Height = frmSize_Height; frm.Width = frmSize_Width; frm.WindowState = WindowState.Normal; frm.ResizeMode = ResizeMode.CanResize; this.Hide(); frm.Show(); //} //else //{ // MessageBox.Show("Access Denied"); //} } } else { MessageBox.Show("Access Denied"); } } }
private void Signin_Click(object sender, RoutedEventArgs e) { SqlCommand cmd = new SqlCommand("select * from dbo.tblUserAccounts where " + "Username = '******' and UserPassword = '******' "); cmd.CommandType = CommandType.Text; if (SqlHelper.ExecuteDataReader(ClsConfig.OnlineSystemsLoginConnectionString, cmd).Rows.Count > 0) { foreach (DataRow dr in SqlHelper.ExecuteDataReader(ClsConfig.OnlineSystemsLoginConnectionString, cmd).Rows) { //if (Convert.ToBoolean(dr[8]) == true) //{ MainForm frm = new MainForm(); frm._deptcode = dr[5].ToString().Trim(); frm._sectcode = dr[6].ToString().Trim(); frm._userid = Convert.ToInt32(dr[0]); frm.Height = frmSize_Height; frm._fullname = dr[3].ToString(); frm.Width = frmSize_Width; frm.WindowState = WindowState.Normal; frm.ResizeMode = ResizeMode.CanResize; this.Hide(); frm.Show(); //} //else //{ // MessageBox.Show("Access Denied"); //} } } else { MessageBox.Show("Access Denied"); } //SqlCommand cmdSelect = new SqlCommand("select * from tblUserAccounts"); //cmdSelect.CommandType = CommandType.Text; //foreach (DataRow dr in SqlHelper.ExecuteDataReader(ClsConfig.Cantier_LotCardLabelConnectionString, cmdSelect).Rows) //{ // SqlCommand cmd = new SqlCommand("update tblUserAccounts set UserEncryptedPassword=@Pass where userid = @userid"); // cmd.CommandType = CommandType.Text; // cmd.Parameters.AddWithValue("@userid", Convert.ToInt32(dr["userid"])); // cmd.Parameters.AddWithValue("@Pass", ClsEncrypt_Decrypt_String.Encrypt(dr["UserPassword"].ToString().Trim())); // SqlHelper.ExecuteNonQuery(ClsConfig.Cantier_LotCardLabelConnectionString, cmd); //} }
private Boolean _SaveData() { Boolean _isValid = false; _isValid = _ValidateFields(); SqlCommand cmd = new SqlCommand("SaveUser"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", id); cmd.Parameters.AddWithValue("@UserName", tbUsername.Text.Trim()); cmd.Parameters.AddWithValue("@UserPassword", ClsEncrypt_Decrypt_String.Encrypt("skpi")); cmd.Parameters.AddWithValue("@FullName", chkIsCommon.IsChecked == true ? tbEmpName_Single.Text.Trim() : cboName.Text.ToString()); cmd.Parameters.AddWithValue("@EmpID", chkIsCommon.IsChecked == true ? DBNull.Value.ToString() : cboName.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@Department", cboDepartment.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@Section", cboSection.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@RawMaterialAccess", RawMaterialAccess.IsChecked == true ? true : false); cmd.Parameters.AddWithValue("@IsLotCardUser", IsLotCardUser.IsChecked == true ? true : false); cmd.Parameters.AddWithValue("@AllowReprintLotCard", AllowReprintLotCard.IsChecked == true ? true : false); cmd.Parameters.AddWithValue("@ReprintLotCardPassword", AllowReprintLotCard.IsChecked == true ? ClsEncrypt_Decrypt_String.Encrypt(tbLotCardPassword.Password) : DBNull.Value.ToString()); cmd.Parameters.AddWithValue("@IsPEZAUser", IsPEZAUser.IsChecked == true ? true : false); cmd.Parameters.AddWithValue("@IsNGDataUser", IsNGDataUser.IsChecked == true ? true : false); cmd.Parameters.AddWithValue("@IsOQCInspector", IsOQCInspector.IsChecked == true ? true : false); cmd.Parameters.AddWithValue("@IsPMCDeliveryPerson", IsPMCDeliveryPerson.IsChecked == true ? true : false); cmd.Parameters.AddWithValue("@IsCommonAccount", chkIsCommon.IsChecked == true ? true : false); cmd.Parameters.AddWithValue("@IsAdmin", IsAdmin.IsChecked == true ? true : false); cmd.Parameters.AddWithValue("@IsChangePassword", 0); cmd.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(ClsConfig.Cantier_LotCardLabelConnectionString, cmd); MessageBox.Show("Saved"); ClearFields(); groupDetails.IsEnabled = false; btnAddNewRecord.IsEnabled = true; btnEdit.IsEnabled = false; btnDelete.IsEnabled = false; btnSave.IsEnabled = false; btnCancelChanges.IsEnabled = false; LoadLists(); LoadEmployees(); LoadDepartment(); _command = string.Empty; return(true); }