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(); }