private void آیجادفایلپشتیبانToolStripMenuItem_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
saveFileDialog1.InitialDirectory = Application.StartupPath + "\\Backup";
saveFileDialog1.FileName = Date.currentDate_Getter().Replace("/", "").Trim();
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string a = saveFileDialog1.FileName.ToString();
try
{
DB back = new DB();
back.path = a;
back.Backup_name = Date.currentDate_Getter() + "-" + DateTime.Now.ToLongTimeString().Substring(0, 8);
back.CreateBackup();
MessageBox.Show("تهیه فایل پشتیبان با موفقیت انجام شد", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception)
{
MessageBox.Show("تهیه فایل پشتیبان با مشکل مواجه شد", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void addstd_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
FillDataSetAndView();
if (objCurrencyManager.Count == 0)
{
foreach (Control c in grpinfo_box.Controls)
{
if (c.GetType() == typeof(FiveCharTextBox) || c.GetType() == typeof(NormalTextbox) || c.GetType() == typeof(NormalCombobox) || c.GetType() == typeof(DateMaskedTextbox) || c.GetType() == typeof(CellPhoneTextBox) || c.GetType() == typeof(CurrencyTextBox))
{
c.Enabled = false;
}
}
btnAdd.Enabled = false;
btnMoveFirst.Enabled = false;
btnMovePrevious.Enabled = false;
btnMoveNext.Enabled = false;
btnMoveLast.Enabled = false;
btnNew.Visible = true;
//btnCancel.Visible = false;
txtRecordPosition.Text = "No Record";
toolStripStatusLabel1.Text = "آماده ایجاد رکورد جدید";
}
else
{
BindFields();
objCurrencyManager.Position = objCurrencyManager.Count - 1;
ShowPosition();
btnAdd.Enabled = false;
}
}
private void frmGhabzDaryaft_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
newform();
Courses co = new Courses();
DataTable dtname = new DataTable();
dtname = co.Search("SELECT coursename FROM courses order by coursename");
txtartcourse.DataSource = dtname;
txtartcourse.DisplayMember = "coursename";
txtartcourse.ValueMember = "coursename";
std st = new std();
DataTable dtstdname = new DataTable();
dtstdname = st.Search("SELECT name, stdno FROM std order by name");
txtname.DataSource = dtstdname;
txtname.DisplayMember = "name";
txtname.ValueMember = "name";
txtstdno.DataBindings.Clear();
txtstdno.DataBindings.Add("Text", dtstdname, "stdno");
}
private void fromMonthPayers_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
txtdate.Text = cur_date;
//txtclday.Text = cur_day;
radioButton1.Checked = true;
idsearch.Enabled = true;
idsearch.PerformClick();
dataGridView1.AutoGenerateColumns = true;
string[] col_headers = { "مشخصه", "رشته هنری", "نام استاد", "ش هنرجو", "نام هنرجو", "روز کلاس", "ساعت شروع", "ساعت پایان", "آخرین تاریخ تسویه", "تاریخ شروع" };
int[] col_width = { 70, 100, 100, 80, 140, 80, 80, 80, 110, 90 };
for (int i = 0; i < col_headers.Length; i++)
{
dataGridView1.Columns[i].HeaderText = col_headers[i].ToString();
dataGridView1.Columns[i].Width = col_width[i];
}
DataGridViewCellStyle objAlternatingCellStyle = new DataGridViewCellStyle();
objAlternatingCellStyle.BackColor = Color.Khaki;
dataGridView1.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle;
}
private void frmPaymentEslah_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
txtid.Focus();
}
private void teacherview_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
Courses co = new Courses();
DataTable dtname = new DataTable();
dtname = co.Search("SELECT coursename FROM courses order by coursename");
txtartcourse.DataSource = dtname;
txtartcourse.DisplayMember = "coursename";
txtartcourse.ValueMember = "coursename";
teachers te = new teachers();
DataTable dttename = new DataTable();
dttename = te.Search("SELECT name FROM teachers order by name");
txtteacher.DataSource = dttename;
txtteacher.DisplayMember = "name";
txtteacher.ValueMember = "name";
DataTable dt = new DataTable();
dt = te.SelectforView();
cmddel.Enabled = true;
cmdedit.Enabled = true;
txtteacher.Text = "";
txtartcourse.Text = "";
dataGridView1.DataSource = dt;
dataGridView1.AutoGenerateColumns = true;
if (dataGridView1.RowCount == 0)
{
cmddel.Enabled = false;
cmdedit.Enabled = false;
}
string[] col_headers = { "ردیف", "نام و نام خانوادگی", "رشته هنری", "تلفن", "سوابق هنری" };
int[] col_width = { 67, 130, 110, 100, 200 };
for (int i = 0; i < col_headers.Length; i++)
{
dataGridView1.Columns[i].HeaderText = col_headers[i].ToString();
dataGridView1.Columns[i].Width = col_width[i];
}
DataGridViewCellStyle objAlternatingCellStyle = new DataGridViewCellStyle();
objAlternatingCellStyle.BackColor = Color.Khaki;
dataGridView1.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle;
}
private void frmGhabzView_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
Courses co = new Courses();
DataTable dtname = new DataTable();
dtname = co.Search("SELECT coursename FROM courses order by coursename");
txtartcourse.DataSource = dtname;
txtartcourse.DisplayMember = "coursename";
txtartcourse.ValueMember = "coursename";
std st = new std();
DataTable dtstdname = new DataTable();
dtstdname = st.Search("SELECT name FROM std order by name");
txtname.DataSource = dtstdname;
txtname.DisplayMember = "name";
txtname.ValueMember = "name";
txtartcourse.Text = "";
txtname.Text = "";
checkBox1.Checked = true;
btnfilter.PerformClick();
grdDataViewer.AutoGenerateColumns = true;
string[] col_headers = { "شماره قبض", "ش هنرجویی", "نام و نام خانوادگی", "کلاس", "تاریخ", "تاریخ پایان تسویه", "ماه تسویه", "هزینه دوره", "مبلغ دریافتی", "توضیحات" };
int[] col_width = { 70, 60, 120, 90, 80, 80, 70, 70, 70, 180 };
for (int i = 0; i < col_headers.Length; i++)
{
grdDataViewer.Columns[i].HeaderText = col_headers[i].ToString();
grdDataViewer.Columns[i].Width = col_width[i];
}
DataGridViewCellStyle objAlternatingCellStyle = new DataGridViewCellStyle();
objAlternatingCellStyle.BackColor = Color.Khaki;
grdDataViewer.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle;
DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle();
dataGridViewCellStyle1.Format = "N0";
dataGridViewCellStyle1.NullValue = null;
grdDataViewer.Columns["mablagh"].DefaultCellStyle = dataGridViewCellStyle1;
grdDataViewer.Columns["paid"].DefaultCellStyle = dataGridViewCellStyle1;
}
private void frmAllInfo_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
fillBasicInfo();
fillClassInfo();
fillHozoorInfo();
fillGhabzInfo();
fillHistoryInfo();
}
private void frmGhabzEdit_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
Courses co = new Courses();
DataTable dtname = new DataTable();
dtname = co.Search("SELECT coursename FROM courses order by coursename");
txtartcourse.DataSource = dtname;
txtartcourse.DisplayMember = "coursename";
txtartcourse.ValueMember = "coursename";
}
private void frmGhabzPardakht_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
newform();
teachers te = new teachers();
DataTable dttename = new DataTable();
dttename = te.Search("SELECT name FROM teachers order by name");
txtname.DataSource = dttename;
txtname.DisplayMember = "name";
txtname.ValueMember = "name";
}
private void frmHozoorView_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
Courses co = new Courses();
DataTable dtname = new DataTable();
dtname = co.Search("SELECT coursename FROM courses order by coursename");
txtartcourse.DataSource = dtname;
txtartcourse.DisplayMember = "coursename";
txtartcourse.ValueMember = "coursename";
std st = new std();
DataTable dtstdname = new DataTable();
dtstdname = st.Search("SELECT name FROM std order by name");
txtname.DataSource = dtstdname;
txtname.DisplayMember = "name";
txtname.ValueMember = "name";
txtartcourse.Text = "";
txtname.Text = "";
checkBox1.Checked = true;
btnfilter.PerformClick();
grdDataViewer.AutoGenerateColumns = true;
string[] col_headers = { "ردیف", "مشخصه هنرجو", "نام و نام خانوادگی", "مشخصه کلاس", "رشته هنری", "تاریخ", "روز", "وضعیت" };
int[] col_width = { 60, 70, 120, 70, 90, 80, 80, 77 };
for (int i = 0; i < col_headers.Length; i++)
{
grdDataViewer.Columns[i].HeaderText = col_headers[i].ToString();
grdDataViewer.Columns[i].Width = col_width[i];
}
DataGridViewCellStyle objAlternatingCellStyle = new DataGridViewCellStyle();
objAlternatingCellStyle.BackColor = Color.Khaki;
grdDataViewer.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle;
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
DialogResult dr;
dr = MessageBox.Show("آیا مایل به تهیه ی فایل پشتیبان هستید؟", "اخطار", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information);
if (dr == DialogResult.Cancel)
{
e.Cancel = true;
}
else if (dr == DialogResult.Yes)
{
if (System.IO.Directory.Exists(Application.StartupPath + @"\Backup"))
{
string a = Application.StartupPath + "\\Backup\\" + Date.currentDate_Getter().Replace('/', '.') + ".bak";
try
{
DB back = new DB();
back.path = a;
back.Backup_name = Date.currentDate_Getter() + "-" + DateTime.Now.ToLongTimeString().Substring(0, 8);
back.CreateBackup();
}
catch (Exception)
{
MessageBox.Show("تهیه فایل پشتیبان با مشکل مواجه شد", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
System.IO.Directory.CreateDirectory(Application.StartupPath + @"\Backup");
string a = Application.StartupPath + "\\Backup\\" + Date.currentDate_Getter().Replace('/', '.') + ".bak";
try
{
DB back = new DB();
back.path = a;
back.Backup_name = Date.currentDate_Getter() + "-" + DateTime.Now.ToLongTimeString().Substring(0, 8);
back.CreateBackup();
}
catch (Exception)
{
MessageBox.Show("تهیه فایل پشتیبان با مشکل مواجه شد", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void frmPaymentsView_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
teachers te = new teachers();
DataTable dttename = new DataTable();
dttename = te.Search("SELECT name FROM teachers order by name");
txtname.DataSource = dttename;
txtname.DisplayMember = "name";
txtname.ValueMember = "name";
txtname.Text = "";
checkBox1.Checked = true;
btnfilter.PerformClick();
grdDataViewer.AutoGenerateColumns = true;
string[] col_headers = { "شماره قبض", "نام و نام خانوادگی", "تاریخ صدور", "ماه تسویه", "مبلغ", "شرح قبض" };
int[] col_width = { 100, 120, 90, 100, 90, 150 };
for (int i = 0; i < col_headers.Length; i++)
{
grdDataViewer.Columns[i].HeaderText = col_headers[i].ToString();
grdDataViewer.Columns[i].Width = col_width[i];
}
DataGridViewCellStyle objAlternatingCellStyle = new DataGridViewCellStyle();
objAlternatingCellStyle.BackColor = Color.Khaki;
grdDataViewer.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle;
DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle();
dataGridViewCellStyle1.Format = "N0";
dataGridViewCellStyle1.NullValue = null;
grdDataViewer.Columns["mablagh"].DefaultCellStyle = dataGridViewCellStyle1;
}
private void classview_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
Courses co = new Courses();
DataTable dtname = new DataTable();
dtname = co.Search("SELECT coursename FROM courses order by coursename");
txtartcourse.DataSource = dtname;
txtartcourse.DisplayMember = "coursename";
txtartcourse.ValueMember = "coursename";
std st = new std();
DataTable dtstdname = new DataTable();
dtstdname = st.Search("SELECT name FROM std order by name");
txtstdname.DataSource = dtstdname;
txtstdname.DisplayMember = "name";
txtstdname.ValueMember = "name";
teachers te = new teachers();
DataTable dttename = new DataTable();
dttename = te.Search("SELECT name FROM teachers order by name");
txtteacher.DataSource = dttename;
txtteacher.DisplayMember = "name";
txtteacher.ValueMember = "name";
txtartcourse.Text = "";
txtteacher.Text = "";
txtstdname.Text = "";
txtday.Text = "";
cmddel.Enabled = true;
cmdedit.Enabled = true;
checkBox1.Checked = true;
}
private void frmHozoor_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
Courses co = new Courses();
DataTable dtname = new DataTable();
dtname = co.Search("SELECT coursename FROM courses order by coursename");
class_txtartcourse.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
class_txtartcourse.AutoCompleteSource = AutoCompleteSource.ListItems;
class_txtartcourse.Items.Add("");
foreach (DataRow dr in dtname.Rows)
{
class_txtartcourse.Items.Add(dr[0].ToString());
}
std st = new std();
DataTable dtstdname = new DataTable();
dtstdname = st.Search("SELECT stdno, name FROM std order by name");
txtstdname.DataSource = dtstdname;
txtstdname.DisplayMember = "name";
txtstdname.ValueMember = "name";
txtstdno.DataBindings.Clear();
txtstdno.DataBindings.Add("Text", dtstdname, "stdno");
txtday.SelectedIndex = DayReader(DateTime.Now.DayOfWeek.ToString());
DataGridViewCellStyle ghabzGridViewStyle = new DataGridViewCellStyle();
ghabzGridViewStyle.Format = "N0";
ghabzGridViewStyle.NullValue = null;
ghabzGridView.Columns["mablagh"].DefaultCellStyle = ghabzGridViewStyle;
newform();
}
private void frmersalbehonarju_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn();
checkColumn.Name = "x";
checkColumn.HeaderText = "";
checkColumn.Width = 60;
checkColumn.ReadOnly = false;
checkColumn.FillWeight = 60; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values
dataGridView1.Columns.Add(checkColumn);
UpdateGridview();
txtreg_date.Text = Date.currentDate_Getter();
thrd = new Thread(new ThreadStart(UpdateBilling));
thrd.IsBackground = true;
thrd.Start();
// UpdateBilling();
}
private void نموداردرآمدToolStripMenuItem_Click(object sender, EventArgs e)
{
bool IsOpen = false;
foreach (Form f in Application.OpenForms)
{
if (f.GetType() == typeof(frmIncomePrintViewer))
{
IsOpen = true;
f.Focus();
break;
}
}
if (IsOpen == false)
{
frmIncomePrintViewer fsm = new frmIncomePrintViewer();
fsm.txtyear.Value = decimal.Parse(Date.currentDate_Getter().Substring(0, 4));
fsm.Show();
}
}
private void frmHozoorByTeacherview_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
teachers st = new teachers();
DataTable dtteachername = new DataTable();
dtteachername = st.Search("SELECT name FROM teachers order by name");
txtteacher.DataSource = dtteachername;
txtteacher.DisplayMember = "name";
txtteacher.ValueMember = "name";
txtteacher.Text = "";
DataGridViewCellStyle objAlternatingCellStyle = new DataGridViewCellStyle();
objAlternatingCellStyle.BackColor = Color.Khaki;
grdDataViewer.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle;
}
private void Form1_Load(object sender, EventArgs e)
{
fc.MdiParent = this;
Point p = new Point(20, this.Height - 320);
fc.Location = p;
fc.Show();
//Tag = 0;
timeDispaly.Text = DateTime.Now.ToLongTimeString();
dateDisplay.Text = Date.currentDate_Getter();
Amoozeshgah sh = new Amoozeshgah();
toolStripStatusLabel3.Text += sh.Select().Rows[0]["name"].ToString();
this.Text = toolStripStatusLabel3.Text;
acc acnt = new acc();
if (acnt.checkpass().Rows.Count > 0)
{
frmLogin frl = new frmLogin();
frl.ShowDialog();
}
InputLanguage lang = GetFarsiLanguage();
if (lang == null)
{
MessageBox.Show("تنظیمات صفجه کلید ویندوز فاقد کیبورد فارسی می باشد، برای کسب اطالاعات بیشتر با پشتیبانی تماس بگیرید");
}
InputLanguage.CurrentInputLanguage = lang;
Timer1.Start();
backgroundWorker1.RunWorkerAsync();
}
private void addclass_Load(object sender, EventArgs e)
{
System.Globalization.CultureInfo inp = new System.Globalization.CultureInfo("fa-IR");
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(inp);
cur_date = Date.currentDate_Getter();
Courses co = new Courses();
DataTable dtname = new DataTable();
dtname = co.Search("SELECT coursename FROM courses");
txtartcourse.DataSource = dtname;
txtartcourse.DisplayMember = "coursename";
txtartcourse.ValueMember = "coursename";
teachers te = new teachers();
DataTable dttename = new DataTable();
dttename = te.Search("SELECT name FROM teachers");
txtteacher.DataSource = dttename;
txtteacher.DisplayMember = "name";
txtteacher.ValueMember = "name";
FillDataSetAndView();
if (objCurrencyManager.Count == 0)
{
foreach (Control c in grpinfo_box.Controls)
{
if (c.GetType() == typeof(NormalTextbox) || c.GetType() == typeof(NormalCombobox) || c.GetType() == typeof(TimeMaskedTextbox) || c.GetType() == typeof(DateMaskedTextbox))
{
c.Enabled = false;
}
}
txtopen_date.Text = cur_date;
btnAdd.Enabled = false;
btnMoveFirst.Enabled = false;
btnMovePrevious.Enabled = false;
btnMoveNext.Enabled = false;
btnMoveLast.Enabled = false;
btnUpdate.Enabled = false;
btnNew.Visible = true;
txtRecordPosition.Text = "No Record";
toolStripStatusLabel1.Text = "آماده ایجاد رکورد جدید";
}
else
{
BindFields();
objCurrencyManager.Position = objCurrencyManager.Count - 1;
ShowPosition();
btnAdd.Enabled = false;
}
std st = new std();
DataTable dtstdname = new DataTable();
dtstdname = st.Search("SELECT name, stdno FROM std order by name");
txtstdname.DataSource = dtstdname;
txtstdname.DisplayMember = "name";
txtstdname.ValueMember = "name";
txtstdno.DataBindings.Clear();
txtstdno.DataBindings.Add("Text", dtstdname, "stdno");
}
private void frmCalender_Load(object sender, EventArgs e)
{
cur_date = Date.currentDate_Getter();
DeskTopCalender();
}
