private void btnOK_Click(object sender, EventArgs e)
{
DataTable table = DBclass.DS.user;
string hash = CalculateMD5Hash(CalculateMD5Hash(tbxOldPass.Text));
DataRow[] rows = table.Select("IDUser="******" and password='******' and role='user'");
if (rows.Length != 0)
{
if (tbxNewPass.Text == tbxNewRePass.Text)
{
DataSetTpos.userRow userRow = (DataSetTpos.userRow)rows[0];
userRow.password = CalculateMD5Hash(CalculateMD5Hash(tbxNewPass.Text));
userTableAdapter utba = new userTableAdapter();
utba.Update(userRow);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
return;
}
else
{
lblErr.Text = "Пароли несоответствуют.";
lblErr.Visible = true;
}
}
else
{
lblErr.Text = "Пароль несоотвествует текущему.";
lblErr.Visible = true;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbxName.Text))
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
DataSetTposTableAdapters.userTableAdapter daUser = new DataSetTposTableAdapters.userTableAdapter();
if (isAdd)
{
DataSetTpos.userRow uRowN = DBclass.DS.user.NewuserRow();
uRowN.username = tbxName.Text;
uRowN.password = CalculateMD5Hash(CalculateMD5Hash(tbxPass.Text));
uRowN.role = cbxRole.SelectedItem.ToString();
DBclass.DS.user.AdduserRow(uRowN);
daUser.Update(uRowN);
daUser.Fill(DBclass.DS.user);
}
else
{
uRow.username = tbxName.Text;
uRow.role = cbxRole.SelectedItem.ToString();
daUser.Update(uRow);
}
}
}
public AddUser(DataSetTpos.userRow userRow)
{
uRow = userRow;
isAdd = false;
InitializeComponent();
if (!isAdd)
{
lblCaption.Text = "Редактировать";
btnAdd.Text = "Изменить";
btnPass.Visible = true;
lblPass.Visible = false;
lblRepass.Visible = false;
tbxPass.Visible = false;
tbxRepass.Visible = false;
}
tbxName.Text = userRow.username;
}
public AddUser(DataSetTpos.userRow userRow)
{
uRow = userRow;
isAdd = false;
InitializeComponent();
if (!isAdd)
{
lblCaption.Text = "Редактировать";
btnAdd.Text = "Изменить";
btnPass.Visible = true;
lblPass.Visible = false;
lblRepass.Visible = false;
tbxPass.Visible = false;
tbxRepass.Visible = false;
cbxRole.SelectedItem = userRow.role;
if (UserValues.role != "admin")
{
cbxRole.Visible = false;
}
}
tbxName.Text = userRow.username;
}
private void dgvTovar_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var dgv = sender as DataGridView;
if (dgv.Columns[e.ColumnIndex] is DataGridViewButtonColumn)
{
DataRow[] dr = DBclass.DS.user.Select("IDUser = "******"IDUser"].Value.ToString());
if (dgv.Columns[e.ColumnIndex].Name == "colBtn")
{
DataSetTpos.userRow uRow = (DataSetTpos.userRow)dr[0];
AddUser adU = new AddUser(uRow);
adU.ShowDialog();
}
else if (dgv.Columns[e.ColumnIndex].Name == "colBtnDel")
{
if (MessageBox.Show("Удалить пользователя?", "", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
dr[0].Delete();
this.userTableAdapter1.Update(DBclass.DS.user);
this.userTableAdapter1.Fill(DBclass.DS.user);
}
}
}
}
