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