private void ManagerForm_Load(object sender, EventArgs e)
{
ExtensionMethods.DoubleBuffered(this.usersDataGridView, true);
selectedRow = 0;
SqlManipulator sql = new SqlManipulator();
try
{
makeTableUsers(sql.getDataLogin());
//usersDataGridView.Columns[0].Visible = false;
var cities = sql.queryCities();
cityComboBox.DataSource = cities;
// this.cityTableTableAdapter.Fill(this.daftarDataSet1.CityTable);
makeTable(sql.getDataCity());
makeTableUsers(sql.getDataLogin());
makeValidationTable(sql.getValidationData());
startendDate = sql.findMaxminMonthDay(0);
this.versionTextBox.Text = global.currentVersion.ToString();
this.versionTextBox.Enabled = false;
DGV_SetStyle(this.cityDataGridView);
changeCityDGVname();
changeColumnName();
selectedRow = 0;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void removeButton_Click(object sender, EventArgs e)
{
try {
DialogResult dialogResult = MessageBox.Show("آیا از حذف مطمئن هستید؟", "هشدار", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
selectedRow = usersDataGridView.CurrentCell.RowIndex;
SqlManipulator sql = new SqlManipulator();
DataGridViewRow newDataRow = usersDataGridView.Rows[selectedRow];
UserTable deletePerson = new UserTable();
deletePerson.Id = (int)newDataRow.Cells[0].Value;
deletePerson.User = (string)newDataRow.Cells[1].Value;
deletePerson.Password = (string)newDataRow.Cells[2].Value;
if (login.Id == deletePerson.Id)
{
MessageBox.Show("این کاربر مجوز حذف خود را ندارد", "پیغام سیستم ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
sql.removeUser(deletePerson);
var logindata = sql.getDataLogin();
makeTableUsers(logindata);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void tabControl1_Selected(object sender, TabControlEventArgs e)
{
if (e.TabPage == tabPage1)
{
selectedRow = 0;
SqlManipulator sql = new SqlManipulator();
try
{
makeTableUsers(sql.getDataLogin());
/// usersDataGridView.Columns[0].Visible = false;
var cities = sql.queryCities();
cityComboBox.DataSource = cities;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
if (e.TabPage == tabPage2)
{
selectedRow = 0;
SqlManipulator sql = new SqlManipulator();
makeTable(sql.getDataCity());
}
if (e.TabPage == tabPage4)
{
try {
SqlManipulator sql = new SqlManipulator();
makeValidationTable(sql.getValidationData());
var cities = sql.queryCities();
validCityComboBox.DataSource = cities;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void addButton_Click(object sender, EventArgs e)
{
UserTable newLogin = new UserTable();
newLogin.Name = nameTextBox.Text;
newLogin.Family = familyTextBox.Text;
newLogin.User = userNameTextBox.Text;
newLogin.Password = passWordTextBox.Text;
newLogin.City = Convert.ToInt64(cityComboBox.SelectedValue);
newLogin.Permission = persmissionCheckBox.Checked;
newLogin.AdminVersion = AdminCheckBox.Checked;
newLogin.Update = false;
newLogin.Messages = " ";
newLogin.Version = global.currentVersion;
SqlManipulator sql = new SqlManipulator();
Reporter rpt = new Reporter(sql.addUser(newLogin), (int)errorImages.info);
rpt.Show();
makeTableUsers(sql.getDataLogin());
}
