private void cmddel_Click(object sender, EventArgs e) { if (dataGridView1.CurrentRow != null) { DialogResult dr; dr = MessageBox.Show("آیا از حذف کلاس اطمینان دارید؟", "حذف", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { int icol = 0; int irow = dataGridView1.CurrentRow.Index; string val = dataGridView1[icol, irow].Value.ToString(); classes cl = new classes(); cl.classno = long.Parse(val); cl.Delete(); if (btnfilter.Enabled == true) { btnfilter.PerformClick(); } else { DataTable dt = new DataTable(); dt = cl.Select(); dataGridView1.DataSource = dt; } } } }
private void btnfilter_Click(object sender, EventArgs e) { //DataGridViewComboBoxColumn class_hozoor_status = new DataGridViewComboBoxColumn(); //class_hozoor_status.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.ComboBox; //class_hozoor_status.DropDownWidth = 2; //class_hozoor_status.HeaderText = "تغییر وضعیت"; //class_hozoor_status.Items.AddRange(new object[] { //"حاضر", //"غایب"}); //class_hozoor_status.MaxDropDownItems = 2; //class_hozoor_status.Name = "class_hozoor_status"; //class_hozoor_status.ReadOnly = false; //dataGridView4.Columns.Add(class_hozoor_status); classes cl = new classes(); cl.clday = class_txtday.Text; if (class_txtartcourse.Text.Trim().Equals("")) { cl.artcourse = null; } else { cl.artcourse = class_txtartcourse.Text.Trim(); } DataTable dt = new DataTable(); dt = cl.SelectforHozoor(class_txtdate.Text); dataGridView4.DataSource = dt; //string[] col_headers = { "تغییر وضعیت", "ش هنرجویی", "نام و نام خانوادگی", "شماره کلاس", "رشته هنری", "نام استاد", "روز کلاس", "ساعت شروع", "ساعت پایان" }; //int[] col_width = { 80, 70, 120, 80, 80, 90, 80, 80, 80 }; //for (int i = 0; i < col_headers.Length; i++) //{ // dataGridView4.Columns[i].HeaderText = col_headers[i].ToString(); // dataGridView4.Columns[i].Width = col_width[i]; // if (i > 0) // dataGridView4.Columns[i].ReadOnly = true; //} if (dataGridView4.RowCount > 0) { btnHozoorAll.Enabled = true; btn_class_sabegheh.Enabled = true; btn_class_shahrieh.Enabled = true; colorize(); } else { btnHozoorAll.Enabled = false; btn_class_sabegheh.Enabled = false; btn_class_shahrieh.Enabled = false; } }
private void button1_Click_1(object sender, EventArgs e) { if (dataGridView1.CurrentRow != null) { int col = 0; int row = dataGridView1.CurrentRow.Index; string val = dataGridView1[col, row].Value.ToString(); classes cl = new classes(); DataTable datat = new DataTable(); cl.classno = long.Parse(val); datat = cl.Selectforedit(); CloseClass ec = new CloseClass(); ec.txtclassno.Text = val; ec.cur_date = this.cur_date; ec.Search_Click(); ec.ShowDialog(); if (btnfilter.Enabled == true) { btnfilter.PerformClick(); } else { DataTable dt = new DataTable(); dt = cl.Select(); dataGridView1.DataSource = dt; } } }
private void txtid_TextChanged(object sender, EventArgs e) { classes tk = new classes(); tk.stdno = txtstdno.Text; DataTable cldt = tk.SelectbystdNo(); dataGridView1.DataSource = cldt;; txtartcourse.DataSource = cldt; txtartcourse.DisplayMember = "artcourse"; txtartcourse.ValueMember = "artcourse"; hozoorclass hzc = new hozoorclass(); hzc.stdno = txtstdno.Text; dataGridView2.DataSource = hzc.SelectSabegheh(); if (txtstdno.Text == "" || txtday.Text.Trim() == "" || !txtdate.MaskCompleted || txtstdname.Text == "" || txtartcourse.Text == "" || dataGridView1.Rows.Count == 0) { btnUpdate.Enabled = false; } else { btnUpdate.Enabled = true; } }
public void Search_Click() { Courses co = new Courses(); DataTable dtname = new DataTable(); dtname = co.Search("SELECT coursename FROM courses"); 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"); txtstdname.DataSource = dtstdname; txtstdname.DisplayMember = "name"; txtstdname.ValueMember = "name"; txtstdno.DataBindings.Clear(); txtstdno.DataBindings.Add("Text", dtstdname, "stdno"); teachers te = new teachers(); DataTable dttename = new DataTable(); dttename = te.Search("SELECT name FROM teachers"); txtteacher.DataSource = dttename; txtteacher.DisplayMember = "name"; txtteacher.ValueMember = "name"; DataTable dt = new DataTable(); classes cu = new classes(); cu.classno = long.Parse(txtclassno.Text); dt = cu.Selectforedit(); if (dt.Rows.Count > 0) { btnUpdate.Enabled = true; txtclassno.Enabled = false; //idsearch.Enabled = false; grpinfo_box.Enabled = true; // Clear any previous bindings & Add new bindings to the DataView object... 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.Text = dt.Rows[0][c.Name.Substring(3)].ToString(); } } // End of Clearing & Adding of Controls Binding txtartcourse.Focus(); } else { MessageBox.Show("مشخصه کلاس در سیستم موجود نمی باشد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void txtartcourse_Enter(object sender, EventArgs e) { classes cl = new classes(); DataTable tmp = cl.Search("select artcourse from classes where (stdname=N'" + txtname.Text + "' and (payan_date=N'' or payan_date is null))"); if (tmp.Rows.Count > 0) { txtartcourse.Text = tmp.Rows[0][0].ToString(); } }
private void FillDataSetAndView() { // Initialize a new instance of the DataSet object... classes cl = new classes(); datat = cl.Select(); // Set our CurrencyManager object // to the DataView object... objCurrencyManager = (CurrencyManager)(this.BindingContext[datat]); }
private void btnUpdate_Click(object sender, EventArgs e) { classes cl = new classes(); cl.classno = long.Parse(txtclassno.Text.Trim()); cl.payan_date = txtpayan_date.Text; cl.CloseClass(); MessageBox.Show("عملیات بستن کلاس مورد نظر با موفقیت انجام شد"); this.Close(); }
private void btnOpenClass_Click(object sender, EventArgs e) { classes cl = new classes(); cl.classno = long.Parse(txtclassno.Text); cl.stdno = txtstdno.Text;; cl.UnCloseClass(); MessageBox.Show("عملیات بازسازی کلاس مورد نظر با موفقیت انجام شد"); fillClassInfo(); }
private void checkBox1_CheckedChanged(object sender, EventArgs e) { if (txtteacher.Text == "" && txtartcourse.Text == "" && txtstdname.Text == "" && txtday.Text == "" && !txttimeFrom.MaskCompleted && !txttimeTo.MaskCompleted && !txtdateFrom.MaskCompleted && !txtdateTo.MaskCompleted && !checkBox1.Checked) { btnfilter.Enabled = false; classes cl = new classes(); DataTable dt = new DataTable(); dt = cl.Select(); dataGridView1.DataSource = dt; } else { btnfilter.Enabled = true; } }
private void btnUpdate_Click(object sender, EventArgs e) { std stdn = new std(); stdn.stdno = txtstdno.Text; if (!stdn.SelectfornameCheck().Equals(txtstdname.Text)) { MessageBox.Show("نام هنرجو با شماره پرونده مطابقت ندارد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); txtstdname.Focus(); return; } classes cl = new classes(); cl.classno = long.Parse(txtclassno.Text.Trim()); cl.teacher = txtteacher.Text; cl.stdname = txtstdname.Text; cl.stdno = txtstdno.Text; cl.artcourse = txtartcourse.Text; cl.clday = txtclday.Text.Trim(); cl.clFromTime = txtclFromTime.Text; cl.clToTime = txtclToTime.Text; cl.method = txtmethod.Text.Trim(); cl.open_date = txtopen_date.Text; if (cl.CheckExists()) { DialogResult dr; dr = MessageBox.Show("کلاسی با این مشخصات پایه در سیستم موجود می باشد، آیا از ایجاد این کلاس و تداخل آنها اطمینان دارید؟", "خطای تداخل", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (dr == DialogResult.Yes) { cl.Update(); this.Close(); } else { txtartcourse.Focus(); } } else { cl.Update(); this.Close(); } }
private void btnNew_Click(object sender, EventArgs e) { foreach (Control c in grpinfo_box.Controls) { if (c.GetType() == typeof(NormalTextbox) || c.GetType() == typeof(TimeMaskedTextbox) || c.GetType() == typeof(DateMaskedTextbox)) { if (c != txtstdno) { c.Enabled = true; c.Text = ""; } } else if (c.GetType() == typeof(NormalCombobox)) { c.Enabled = true; if (((ComboBox)c).Items.Count > 0) { ((ComboBox)c).SelectedIndex = 0; } } } txtopen_date.Text = cur_date; // Clear the book title and price fields... txtRecordPosition.Text = "رکورد جدید"; classes cls = new classes(); cls.open_date = txtopen_date.Text; long codeCounter = cls.Selectmaxid(); txtclassno.Text = codeCounter.ToString(); btnAdd.Enabled = false; btnMoveFirst.Enabled = false; btnMovePrevious.Enabled = false; btnMoveNext.Enabled = false; btnMoveLast.Enabled = false; btnUpdate.Enabled = false; btnNew.Visible = false; btnCancel.Visible = true; toolStripStatusLabel1.Text = "لطفا اطلاعات رکورد جدید را وارد نمایید"; txtartcourse.Focus(); }
private void cmdadd_Click(object sender, EventArgs e) { addclass ac = new addclass(); // ac.cur_date = this.cur_date; ac.ShowDialog(); if (btnfilter.Enabled == true) { btnfilter.PerformClick(); } else { classes cl = new classes(); DataTable dt = new DataTable(); dt = cl.Select(); dataGridView1.DataSource = dt; } }
private void btnOpenClass_Click(object sender, EventArgs e) { classes cl = new classes(); cl.classno = long.Parse(dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString().Trim()); cl.stdno = dataGridView1["stdno", dataGridView1.CurrentRow.Index].Value.ToString().Trim(); cl.UnCloseClass(); MessageBox.Show("عملیات بازسازی کلاس مورد نظر با موفقیت انجام شد"); if (btnfilter.Enabled == true) { btnfilter.PerformClick(); } else { DataTable dt = new DataTable(); dt = cl.Select(); dataGridView1.DataSource = dt; } }
public void Search_Click() { DataTable dt = new DataTable(); classes cu = new classes(); cu.classno = long.Parse(txtclassno.Text); dt = cu.Selectforedit(); if (dt.Rows.Count > 0) { btnUpdate.Enabled = false; txtclassno.Enabled = false; //idsearch.Enabled = false; //grpinfo_box.Enabled = true; // Clear any previous bindings & Add new bindings to the DataView object... 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.Text = dt.Rows[0][c.Name.Substring(3)].ToString(); } } txtpayan_date.Text = dt.Rows[0]["payan_date"].ToString(); // End of Clearing & Adding of Controls Binding grpinfo_box.Enabled = false; if (!txtpayan_date.MaskCompleted) { txtpayan_date.Text = cur_date; } txtpayan_date.Focus(); } else { MessageBox.Show("مشخصه کلاس در سیستم موجود نمی باشد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void fillClassInfo() { DataTable dt = new DataTable(); classes cu = new classes(); cu.stdno = txtstdno.Text; dt = cu.SelectbystdNo(); if (dt.Rows.Count > 0) { txtstdno.Enabled = false; grpBasicInfo.Enabled = true; // Clear any previous bindings & Add new bindings to the DataView object... foreach (Control c in grpClassInfo.Controls) { if (c.GetType() == typeof(NormalTextbox) || c.GetType() == typeof(NormalCombobox) || c.GetType() == typeof(TimeMaskedTextbox) || c.GetType() == typeof(DateMaskedTextbox)) { c.Text = dt.Rows[0][c.Name.Substring(3)].ToString(); } } // End of Clearing & Adding of Controls Binding } else { // Clear any previous bindings & Add new bindings to the DataView object... foreach (Control c in grpClassInfo.Controls) { if (c.GetType() == typeof(NormalTextbox) || c.GetType() == typeof(NormalCombobox) || c.GetType() == typeof(TimeMaskedTextbox) || c.GetType() == typeof(DateMaskedTextbox)) { c.Text = "-"; } } btnOpenClass.Enabled = false; btnCloseClass.Enabled = false; btnClassEdit.Enabled = false; } }
private void addbtnTextChanged(object sender, EventArgs e) { if (sender == txtopen_date && txtopen_date.MaskCompleted && btnNew.Visible == false) { try { long.Parse(txtopen_date.Text.Substring(0, 4).Trim()); classes cls = new classes(); cls.open_date = txtopen_date.Text; long codeCounter = cls.Selectmaxid(); txtclassno.Text = codeCounter.ToString(); } catch { txtclassno.Text = ""; } } if (sender == txtclFromTime && txtclFromTime.MaskCompleted && btnNew.Visible == false) { try { TimeSpan dtime = TimeSpan.Parse(txtclFromTime.Text); TimeSpan add30 = TimeSpan.Parse("00:30"); txtclToTime.Text = dtime.Add(add30).ToString(); } catch { MessageBox.Show("لطفا ساعت کلاس را به صورت صحیح وارد نمایید"); } } if (sender == txtartcourse && txtartcourse.Text != "" && btnNew.Visible == false) { teachers te = new teachers(); DataTable tedt = new DataTable(); tedt = te.Search("select name from teachers where artcourse=N'" + txtartcourse.Text + "'"); if (tedt.Rows.Count > 0) { txtteacher.Text = tedt.Rows[0][0].ToString(); } } if (txtclassno.Text == "" || txtartcourse.Text == "" || txtteacher.Text == "" || txtstdname.Text == "" || txtclday.Text == "" || !txtclFromTime.MaskCompleted || !txtclToTime.MaskCompleted || !txtopen_date.MaskCompleted) { btnAdd.Enabled = false; btnUpdate.Enabled = false; } else if (btnNew.Visible == false) { btnAdd.Enabled = true; } else if (btnNew.Visible == true) { btnUpdate.Enabled = true; } }
private void btnUpdate_Click(object sender, EventArgs e) { std stdn = new std(); stdn.stdno = txtstdno.Text; if (!stdn.SelectfornameCheck().Equals(txtstdname.Text)) { MessageBox.Show("نام هنرجو با شماره پرونده مطابقت ندارد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); txtstdname.Focus(); return; } // Declare local variables and objects... int intPosition; // Save the current record position... intPosition = objCurrencyManager.Position; // Set the SqlCommand object properties... classes cl = new classes(); cl.classno = long.Parse(txtclassno.Text.Trim()); cl.teacher = txtteacher.Text; cl.stdname = txtstdname.Text; cl.stdno = txtstdno.Text; cl.artcourse = txtartcourse.Text; cl.clday = txtclday.Text.Trim(); cl.clFromTime = txtclFromTime.Text; cl.clToTime = txtclToTime.Text; cl.method = txtmethod.Text.Trim(); cl.open_date = txtopen_date.Text; if (cl.CheckExists()) { DialogResult dr; dr = MessageBox.Show("کلاسی با این مشخصات پایه در سیستم موجود می باشد، آیا از ایجاد این کلاس و تداخل آنها اطمینان دارید؟", "خطای تداخل", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (dr == DialogResult.Yes) { cl.Update(); // Fill the DataSet and bind the fields... FillDataSetAndView(); BindFields(); // Set the record position // to the one that you saved... objCurrencyManager.Position = intPosition; // Show the current record position... ShowPosition(); // Display a message that the record was updated... toolStripStatusLabel1.Text = "عملیات ویرایش رکورد با موفقیت انجام شد"; } else { txtartcourse.Focus(); } } else { cl.Update(); // Fill the DataSet and bind the fields... FillDataSetAndView(); BindFields(); // Set the record position // to the one that you saved... objCurrencyManager.Position = intPosition; // Show the current record position... ShowPosition(); // Display a message that the record was updated... toolStripStatusLabel1.Text = "عملیات ویرایش رکورد با موفقیت انجام شد"; } }
private void btnfilter_Click(object sender, EventArgs e) { Boolean check = false; string SQL = "select * from classes where "; check = false; if (txtartcourse.Text != "") { SQL = SQL + "artcourse = N'" + txtartcourse.Text.Trim() + "'AND "; check = true; } if (txtteacher.Text != "") { SQL = SQL + "teacher like N'%" + txtteacher.Text.Trim() + "%'AND "; check = true; } if (txtstdname.Text != "") { SQL = SQL + "stdname = N'" + txtstdname.Text.Trim() + "'AND "; check = true; } if (txtday.Text != "") { SQL = SQL + "clday = N'" + txtday.Text.Trim() + "'AND "; check = true; } if (txttimeFrom.MaskCompleted) { SQL = SQL + "clFromTime >= N'" + txttimeFrom.Text.Trim() + "'AND "; check = true; } if (txttimeTo.MaskCompleted) { SQL = SQL + "clfromtime <=N'" + txttimeTo.Text.Trim() + "'AND "; check = true; } if (txtdateFrom.MaskCompleted) { SQL = SQL + "open_date >= N'" + txtdateFrom.Text.Trim() + "'AND "; check = true; } if (txtdateTo.MaskCompleted) { SQL = SQL + "open_date <=N'" + txtdateTo.Text.Trim() + "'AND "; check = true; } if (checkBox1.Checked) { SQL = SQL + "(payan_date is null OR payan_date=N'')AND "; check = true; } if (check == true) { SQL = SQL.Remove(SQL.Length - 4) + " order by payan_date, artcourse"; } classes cl = new classes(); DataTable dt = new DataTable(); dt = cl.Search(SQL); dataGridView1.DataSource = dt; }