private void btnfilter_Click(object sender, EventArgs e)
{
Boolean check = false;
string SQL = "select teacherno, name, artcourse, tel, resume from teachers where ";
check = false;
if (txtteacher.Text != "")
{
SQL = SQL + "name like N'%" + txtteacher.Text.Trim() + "%'AND ";
check = true;
}
if (txtartcourse.Text != "")
{
SQL = SQL + "artcourse like N'%" + txtartcourse.Text.Trim() + "%'AND ";
check = true;
}
if (check == true)
{
SQL = SQL.Remove(SQL.Length - 4);
}
teachers te = new teachers();
DataTable dt = new DataTable();
dt = te.Search(SQL);
dataGridView1.DataSource = dt;
}
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 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 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 btnteacher_Click(object sender, EventArgs e)
{
int cmbPos = txtteacher.SelectedIndex;
addteacher ac = new addteacher();
ac.ShowDialog();
teachers te = new teachers();
DataTable dttename = new DataTable();
dttename = te.Search("SELECT name,stdno FROM teachers");
txtteacher.DataSource = dttename;
txtteacher.DisplayMember = "name";
txtteacher.ValueMember = "name";
txtteacher.SelectedIndex = cmbPos;
}
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 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 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;
}
public void idsearch_Click()
{
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";
payments pa = new payments();
pa.id = txtid.Text;
DataTable dt = pa.Selectforedit();
if (dt.Rows.Count > 0)
{
btnUpdate.Enabled = true;
txtid.Enabled = false;
groupBox1.Enabled = true;
// Clear any previous bindings & Add new bindings to the DataView object...
foreach (Control c in groupBox1.Controls)
{
if (c.GetType() == typeof(FiveCharTextBox) || c.GetType() == typeof(NormalCombobox) || c.GetType() == typeof(DateMaskedTextbox) || c.GetType() == typeof(CurrencyTextBox))
{
c.Text = dt.Rows[0][c.Name.Substring(3)].ToString();
}
}
// End of Clearing & Adding of Controls Binding
txtdate.Focus();
}
else
{
MessageBox.Show("شماره قبض در سیستم موجود نمی باشد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
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 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;
}
}
