private void deleteRestrictionButton_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("آیا از حذف مطمئن هستید؟", "هشدار", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
try {
selectedRow = validationDataGridView.CurrentCell.RowIndex;
SqlManipulator sql = new SqlManipulator();
DataGridViewRow newDataRow = validationDataGridView.Rows[selectedRow];
validationTable deletedRestriction = new validationTable();
deletedRestriction.City = (long)newDataRow.Cells[2].Value;
deletedRestriction.startDate = (long)newDataRow.Cells[3].Value;
deletedRestriction.enDate = (long)newDataRow.Cells[4].Value;
deletedRestriction.id = (long)newDataRow.Cells[0].Value;
deletedRestriction.description = (String)newDataRow.Cells[1].Value;
sql.removeRestriction(deletedRestriction);
var data = sql.getValidationData();
makeValidationTable(data);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
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 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 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 editButton_Click(object sender, EventArgs e)
{
try
{
if (!inputValidation())
{
return;
}
Utility utl = new Utility();
SqlManipulator sql = new SqlManipulator();
DaftarTable newDaftar = new DaftarTable();
if (login.permission)
{
var itm = (ComboboxItem)placeComboBox.SelectedItem;
login.cityID = itm.Value;
}
else
{
newDaftar.CityID = login.cityID;
}
newDaftar.Id = data.Id;
//var item = (ComboboxItem)placeComboBox.SelectedItem;
//newDaftar.CityID = item.Value;
newDaftar.Refund = Convert.ToInt64(this.refundTextBox.Text);
newDaftar.AccountType = this.AccountTypeComboBox.SelectedItem.ToString();
// newDaftar.BillDetailCode = Convert.ToInt64(this.billDetailCodetextBox.Text);
newDaftar.CodeBudget = Convert.ToInt64(this.BudgetCodetextBox.Text);
//newDaftar.Date = this.dateMaskedTextBox.Text;
newDaftar.PlaceName = placeComboBox.SelectedItem.ToString();
// newDaftar.RealDate = utl.changeToRealDate(newDaftar.Date);
newDaftar.Deposit = Convert.ToInt64(this.DepositTextBox.Text);
newDaftar.RealDate = data.RealDate;
newDaftar.DepositDetail = Convert.ToInt64(this.DepositDetailtextBox.Text);
newDaftar.DepositOwnerDetail = this.DepositOwnerDetailTextBox.Text;
newDaftar.CityID = data.CityID;
if (sql.isRestricted(newDaftar, login.permission))
{
MessageBox.Show("دسترسی شما به این تاریخ توسط مدیر سیستم محدود شده است", "خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
;
Reporter rpt = new Reporter(sql.update(newDaftar, godmode), (int)errorImages.info);
rpt.Show();
form.refreshLastState(lastState, pageNumber, false);
this.Hide();
}
catch (Exception ex)
{
MessageBox.Show("ورودی های خود را کنترل نمائید", "خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
MessageBox.Show(ex.Message);
}
}
private void sendButton_Click(object sender, EventArgs e)
{
SqlManipulator sql = new SqlManipulator();
if (sql.sendMessages(this.MessageRichTextBox.Text))
{
MessageBox.Show("پیغام با موفقیت ارسال شد ، در ورود جدید به کاربران پیغام شما نمایش خواهد داده شد ");
}
else
{
MessageBox.Show("خطایی رخ داده است ");
};
}
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 updateButton_Click(object sender, EventArgs e)
{
try {
if (activateCheckBox.Checked)
{
SqlManipulator sql = new SqlManipulator();
if (sql.sendUpdateNotify(Int32.Parse(this.versionTextBox.Text.ToString())))
{
MessageBox.Show("با موفقیت پیام بروزرسانی ارسال شد ، کاربران ملزم به استفاده از نسخه جدید می باشند ");
}
}
else
{
this.versionTextBox.Text = global.currentVersion.ToString();
}
}
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());
}
private void importAllButton_Click(object sender, EventArgs e)
{
try
{
if (login.permission)
{
var dataToimport = excelData;
SqlManipulator sql = new SqlManipulator();
Utility util = new Utility();
foreach (var data in dataToimport)
{
var convertedData = util.convertYekeQuery(data.ToList());
var query = convertedData.AsQueryable();
ComboboxItem itm = (ComboboxItem)cityComboBox.SelectedItem;
long id = itm.Value;
sql.excelToSqlCopy(query, id);
}
}
else
{
var dataToimport = excelData;
SqlManipulator sql = new SqlManipulator();
Utility util = new Utility();
foreach (var data in dataToimport)
{
var convertedData = util.convertYekeQuery(data.ToList());
var query = convertedData.AsQueryable();
sql.excelToSqlCopy(query, login.cityID);
}
}
this.mainForm.refreshDGV();
}
catch (Exception ex)
{
MessageBox.Show(ex.Data.ToString());
}
this.Hide();
}
private void addRestriction()
{
try
{
validationTable valid = new validationTable();
DateTime endTime = endDateTimePickerX1.SelectedDateInDateTime;
StartEndMonthClass date = new StartEndMonthClass();
date.endDate = Convert.ToInt64(endTime.ToFa("yyyyMMdd"));
valid.startDate = startendDate.min;
valid.enDate = date.endDate;
valid.City = Convert.ToInt64(validCityComboBox.SelectedValue);
SqlManipulator sql = new SqlManipulator();
//if (this.lockAllCitiesCheckBox.Checked == true)
//{
// var cities = sql.getDataCity();
// foreach(var city in cities)
// {
// }
//}
var cityName = sql.getCityName(valid.City);
FarsiDateUtil startDate = new FarsiDateUtil(startendDate.min.ToString());
FarsiDateUtil endDate = new FarsiDateUtil(date.endDate.ToString());
valid.description = "قفل" + " " + cityName + " " + endDate.MonthName + endDate.Year;
Reporter rpt = new Reporter(sql.addValidation(valid), (int)errorImages.info);
rpt.Show();
makeValidationTable(sql.getValidationData());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void addCityToFormManagerButton_Click(object sender, EventArgs e)
{
try {
CityTable newCity = new CityTable();
newCity.CityName = CityTextBox.Text;
newCity.Id = Convert.ToInt64(IDTextBox.Text);
SqlManipulator sql = new SqlManipulator();
if (sql.addCity(newCity))
{
makeTable(sql.getDataCity());
MessageBox.Show("با موفقیت شهر مورد نظر اضافه گردید");
mainForm.setCityComboBox();
}
else
{
MessageBox.Show("خطا");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void RemoveButton_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("آیا از حذف مطمئن هستید؟", "هشدار", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
try {
selectedRow = cityDataGridView.CurrentCell.RowIndex;
SqlManipulator sql = new SqlManipulator();
DataGridViewRow newDataRow = cityDataGridView.Rows[selectedRow];
CityTable deletedCity = new CityTable();
deletedCity.Id = (long)newDataRow.Cells[1].Value;
deletedCity.CityName = (string)newDataRow.Cells[0].Value;
sql.removeCity(deletedCity);
var cityData = sql.getDataCity();
makeTable(cityData);
}
catch (Exception)
{
throw;
}
}
}
private void loginButton_Click(object sender, EventArgs e)
{
try
{
var cn = Properties.Settings.Default.MainConnectionString;
if (IsServerConnected(cn))
{
UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn);
foreach (var q in db.UserTables)
{
if (q.User == this.UserNametextBox.Text && q.Password == this.PasswordTextBox.Text)
{
this.Hide();
LoginInfo login = new LoginInfo();
login.cityID = q.City;
login.Name = q.Name;
login.Id = q.Id;
login.family = q.Family;
login.permission = q.Permission.Value;
login.user = q.User;
login.update = q.Update.Value;
login.messages = q.Messages;
login.version = q.Version ?? default(int);
login.adminVersion = q.AdminVersion ?? default(bool);
if (login.version > currentVersion && !login.adminVersion)
{
MessageBox.Show("نسخه شما بروز نیست . آخرین نسخه بروز شده را نصب کنید ", "پیغام",
MessageBoxButtons.OK,
MessageBoxIcon.Stop);
this.Close();
return;
}
SqlManipulator sql = new SqlManipulator();
if (!login.adminVersion)
{
if (login.update)
{
MessageBox.Show(login.messages, "پیغام ",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
try {
sql.MessagesSeenStatus(false, login);
}
catch (Exception)
{ MessageBox.Show("خطا در پیغام"); }
}
}
string cityName = sql.getCityName(login.cityID);
login.cityName = cityName;
form.setLoginData(login);
Properties.Settings.Default.LastUser = this.UserNametextBox.Text;
tmr = new Timer();
//set time interval 3 sec
tmr.Interval = 3500;
//starts the timer
formwait = new SplashScreenForm();
formwait.Show();
tmr.Start();
tmr.Tick += tmr_Tick;
permission = q.Permission.Value;
Properties.Settings.Default.Save();
return;
}
}
MessageBox.Show("نام کاربری و گذر واژه فاقد اعتبار است", "خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
else
{
MessageBox.Show("ارتباط با سرور قطع است ، تنظیمات سرور را بررسی کنید", "خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void importButton1_Click(object sender, EventArgs e)
{
try
{
if (refundRadioButton.Checked == false && depositRadioButton.Checked == false)
{
MessageBox.Show(" لطفا نوع فایل را انتخاب نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
// StartProgress();
if (login.permission)
{
var dataToimport = excelData[excelMonthscomboBox.SelectedIndex];
SqlManipulator sql = new SqlManipulator();
ExcelManipulatorcs excel = new ExcelManipulatorcs();
var query = excel.dataCorrection(dataToimport);
var itm = (ComboboxItem)cityComboBox.SelectedItem;
long id = itm.Value;
if (this.refundRadioButton.Checked)
{
var report = sql.refundFromFile(query, id);
Reporter rpt = new Reporter(report, Convert.ToInt32(errorImages.info));
rpt.Show();
}
if (this.depositRadioButton.Checked)
{
sql.excelToSqlCopy(query, id);
}
this.mainForm.refreshDGV();
}
else
{
Utility util = new Utility();
var dataToimport = excelData[excelMonthscomboBox.SelectedIndex];
SqlManipulator sql = new SqlManipulator();
var convertedData = util.convertYekeQuery(dataToimport.ToList());
convertedData = util.convertToRealDate(convertedData);
var query = convertedData.AsQueryable();
if (this.refundRadioButton.Checked)
{
var report = sql.refundFromFile(query, login.cityID);
Reporter rpt = new Reporter(report, Convert.ToInt32(errorImages.info));
rpt.Show();
}
if (this.depositRadioButton.Checked)
{
sql.excelToSqlCopy(query, login.cityID);
}
this.mainForm.refreshDGV();
}
excelData.Clear();
this.Hide();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
// CloseProgress();
}
