private void setPlaceComboBox()
{
AccountTypeComboBox.SelectedIndex = 0;
placeComboBox.Items.Clear();
if (!login.permission)
{
placeComboBox.Items.Add(new ComboboxItem(login.cityName, login.cityID));
placeComboBox.SelectedIndex = 0;
placeComboBox.Enabled = false;
}
else
{
try
{
SqlManipulator sql = new SqlManipulator();
var cities = sql.queryCities();
foreach (var city in cities)
{
placeComboBox.Items.Add(new ComboboxItem(city.CityName, city.Id));
}
placeComboBox.Enabled = true;
placeComboBox.SelectedIndex = 0;
}
catch (Exception)
{
throw;
}
}
}
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 setComboBoxCity()
{
if (login.permission)
{
try {
cityComboBox.Enabled = true;
SqlManipulator sql = new SqlManipulator();
var cities = sql.queryCities();
foreach (var city in cities)
{
cityComboBox.Items.Add(new ComboboxItem(city.CityName, city.Id));
}
cityComboBox.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
MessageBox.Show("شهری در پایگاه داده وجود ندارد");
}
}
else
{
cityComboBox.Items.Add(new ComboboxItem(login.cityName, login.cityID));
cityComboBox.SelectedIndex = 0;
cityComboBox.Enabled = false;
}
}
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());
}
}
}
