private void btn_SaveEdit_Click(object sender, EventArgs e)
{
try
{
if (allow_edit == true)
{
UniversityDataContext udc = new UniversityDataContext();
var q = from p in udc.Ostads
where p.id == Id_edit
select p;
foreach (Ostad item in q)
{
item.id_ostad = Convert.ToInt32(txt_CodeOstadEdit.Text);
item.name = txt_NameEdit.Text;
item.family = txt_LNameEdit.Text;
item.id_meli = txt_CodemellEdit.Text;
item.sh_sh = txt_SSEdit.Text;
item.madrak = com_MadrakEdit.Items[com_MadrakEdit.SelectedIndex].ToString();
item.mobile = txt_NumberMobileEdit.Text;
item.tel = txt_NumberHomeEdit.Text;
item.address = txt_AddressEdit.Text;
udc.SubmitChanges();
allow_edit = false;
FillGrid();
MessageBox.Show(".با موفقیت ذخیره شد");
CleartxtEdit();
}
}
}
catch (Exception e4) { MessageBox.Show(e4.Message); }
}
private void gridviewUser_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == 0)
{
if (MessageBox.Show("آیا مابل به حذف این کاربر هستید؟ ", "پیام", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
Id_edit = Convert.ToInt16(gridviewUser.Rows[e.RowIndex].Cells["id"].Value.ToString());
UniversityDataContext udc = new UniversityDataContext();
var q = udc.Users.Single(p => p.id == Id_edit);
udc.Users.DeleteOnSubmit(q);
udc.SubmitChanges();
FillGrid();
}
}
if (e.ColumnIndex == 1)
{
txt_UserEdit.Text = gridviewUser.Rows[e.RowIndex].Cells[3].Value.ToString();
txt_PassEdit.Text = gridviewUser.Rows[e.RowIndex].Cells[4].Value.ToString();
Id_edit = Convert.ToInt16(gridviewUser.Rows[e.RowIndex].Cells["id"].Value.ToString());
allow_edit = true;
}
}
catch (Exception e3) { MessageBox.Show(e3.Message); }
}
private void btn_Enter_Click(object sender, EventArgs e)
{
try
{
username = txt_Username.Text.Trim();
password = txt_Password.Text.Trim();
UniversityDataContext udc = new UniversityDataContext();
var query = from p in udc.Users
where p.nuser == username && p.npass == password
select p;
// MessageBox.Show(query.Count().ToString());
if (query.Count() == 1)
{
this.Hide();
frmMain obj1 = new frmMain(username);
obj1.Show();
}
else
{
MessageBox.Show(".نام کاربری و رمز عبور اشتباه است");
txt_Username.Select();
}
}
catch (Exception e1) { MessageBox.Show(e1.Message); }
}
private void btn_Search_Click(object sender, EventArgs e)
{
try
{
if (txt_codeDaneshjooSearch.Text != "")
{
int idostad = Convert.ToInt32(txt_codeDaneshjooSearch.Text);
UniversityDataContext udc = new UniversityDataContext();
var q = from p in udc.Students
where p.id_student == idostad
select p;
gridviewDaneshjoo.DataSource = q;
}
if (txt_LNameSearch.Text != "")
{
UniversityDataContext udc = new UniversityDataContext();
var q = from p in udc.Students
where p.family.StartsWith(txt_LNameSearch.Text)
select p;
gridviewDaneshjoo.DataSource = q;
}
}
catch (Exception e1) { MessageBox.Show(e1.Message); }
}
private void btn_SaveEdit1_Click(object sender, EventArgs e)
{
try
{
if (allow_edit == true)
{
UniversityDataContext udc = new UniversityDataContext();
var q = from p in udc.Darses
where p.id == Id_edit
select p;
foreach (Darse item in q)
{
item.id_dars = Convert.ToInt32(txt_CodeDarsEdit.Text);
item.name = txt_NameDarsEdit.Text;
item.tedad_vahed = Convert.ToInt16(txt_CountVahedEdit.Text);
item.type = com_TypeEdit.Items[com_TypeEdit.SelectedIndex].ToString();
}
udc.SubmitChanges();
allow_edit = false;
FillGrid();
MessageBox.Show(".با موفقیت ذخیره شد");
ClearEdit();
}
}
catch (Exception e5) { MessageBox.Show(e5.Message); }
}
private void btn_SaveEdit_Click(object sender, EventArgs e)
{
try
{
if (allow_edit == true)
{
UniversityDataContext udc = new UniversityDataContext();
var q = from p in udc.Users
where p.id == Id_edit
select p;
foreach (User item in q)
{
item.nuser = txt_UserEdit.Text;
item.npass = txt_PassEdit.Text;
}
udc.SubmitChanges();
allow_edit = false;
FillGrid();
MessageBox.Show(".با موفقیت ذخیره شد");
txt_UserEdit.Clear();
txt_PassEdit.Clear();
}
}
catch (Exception e4) { MessageBox.Show(e4.Message); }
}
private void btn_SaveAddNew_Click(object sender, EventArgs e)
{
try
{
if (CheckEmpty() != true)
{
UniversityDataContext udc = new UniversityDataContext();
Student objStudent = new Student();
objStudent.id_student = Convert.ToInt32(txt_CodeDaneshjooAddNew.Text);
objStudent.name = txt_NameAddNew.Text.Trim();
objStudent.family = txt_LNameAddNew.Text.Trim();
objStudent.id_meli = txt_CodemelliAddNew.Text;
objStudent.sh_sh = txt_SSAddNew.Text;
objStudent.vorodi = txt_VorodiAddNew.Text;
objStudent.maghtae = com_AddNew.Items[com_AddNew.SelectedIndex].ToString();
objStudent.mobile = txt_NumberMobileAddNEw.Text;
objStudent.tel = txt_NumberHomeAddNew.Text;
objStudent.address = txt_AddressAddNew.Text;
udc.Students.InsertOnSubmit(objStudent);
udc.SubmitChanges();
FillGrid();
MessageBox.Show(".با موفقیت درج شد", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearAddNew();
}
else
{
MessageBox.Show(".لطفا اطلاعات را کامل کنید", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txt_CodeDaneshjooAddNew.Select();
}
}
catch (Exception e2) { MessageBox.Show(e2.Message); }
}
private void btn_SaveEdit1_Click(object sender, EventArgs e)
{
try
{
if (allow_edit == true)
{
UniversityDataContext udc = new UniversityDataContext();
var q = from p in udc.Students
where p.id == Id_edit
select p;
foreach (Student item in q)
{
item.id_student = Convert.ToInt32(txt_CodeDaneshjooEdit.Text);
item.name = txt_NameEdit.Text.Trim();
item.family = txt_LNameEdit.Text.Trim();
item.id_meli = txt_CodemelliEdit.Text;
item.sh_sh = txt_SSEdit.Text;
item.vorodi = txt_VorodiEdit.Text;
item.maghtae = com_MagtahEdit.Items[com_MagtahEdit.SelectedIndex].ToString();
item.mobile = txt_MobileEdit.Text;
item.tel = txt_HomeEdit.Text;
item.address = txt_AddressEdit.Text;
udc.SubmitChanges();
allow_edit = false;
FillGrid();
MessageBox.Show(".با موفقیت ذخیره شد");
ClearEdit();
}
}
}
catch (Exception e5) { MessageBox.Show(e5.Message); }
}
private void btn_SaveNewUser_Click(object sender, EventArgs e)
{
try
{
if (txt_UserAddNew.Text != "" && txt_PassAddNew.Text != "")
{
if (txt_PassAddNew.Text == txt_PassAddNewAllow.Text)
{
UniversityDataContext udc = new UniversityDataContext();
User objuser = new User();
objuser.nuser = txt_UserAddNew.Text.Trim();
objuser.npass = txt_PassAddNew.Text.Trim();
udc.Users.InsertOnSubmit(objuser);
udc.SubmitChanges();
FillGrid();
MessageBox.Show(".با موفقیت درج شد", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_UserAddNew.Clear();
txt_PassAddNew.Clear();
txt_PassAddNewAllow.Clear();
}
else
{
MessageBox.Show("پسورد مطابقت ندارد");
txt_PassAddNewAllow.Select();
}
}
else
{
MessageBox.Show(".لطفا نام کاربری و رمز عبور را وارد کنید");
txt_UserAddNew.Select();
}
}
catch (Exception e2) { MessageBox.Show(e2.Message); }
}
private void gridviewDaneshjoo_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == 0)
{
if (MessageBox.Show("آیا مابل به حذف این دانشجو هستید؟ ", "پیام", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
Id_edit = Convert.ToInt16(gridviewDaneshjoo.Rows[e.RowIndex].Cells["id"].Value.ToString());
UniversityDataContext udc = new UniversityDataContext();
var q = udc.Students.Single(p => p.id == Id_edit);
udc.Students.DeleteOnSubmit(q);
udc.SubmitChanges();
FillGrid();
MessageBox.Show(".با موفقیت حذف شد", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (e.ColumnIndex == 1)
{
Id_edit = Convert.ToInt32(gridviewDaneshjoo.Rows[e.RowIndex].Cells["id"].Value);
txt_CodeDaneshjooEdit.Text = gridviewDaneshjoo.Rows[e.RowIndex].Cells["id_student"].Value.ToString();
txt_NameEdit.Text = gridviewDaneshjoo.Rows[e.RowIndex].Cells["name"].Value.ToString();
txt_LNameEdit.Text = gridviewDaneshjoo.Rows[e.RowIndex].Cells["family"].Value.ToString();
txt_CodemelliEdit.Text = gridviewDaneshjoo.Rows[e.RowIndex].Cells["id_meli"].Value.ToString();
txt_SSEdit.Text = gridviewDaneshjoo.Rows[e.RowIndex].Cells["sh_sh"].Value.ToString();
txt_VorodiEdit.Text = gridviewDaneshjoo.Rows[e.RowIndex].Cells["vorodi"].Value.ToString();
setComobox(gridviewDaneshjoo.Rows[e.RowIndex].Cells["maghtae"].Value.ToString());
txt_MobileEdit.Text = gridviewDaneshjoo.Rows[e.RowIndex].Cells["mobile"].Value.ToString();
txt_HomeEdit.Text = gridviewDaneshjoo.Rows[e.RowIndex].Cells["tel"].Value.ToString();
txt_AddressEdit.Text = gridviewDaneshjoo.Rows[e.RowIndex].Cells["address"].Value.ToString();
allow_edit = true;
}
}
catch (Exception e4) { MessageBox.Show(e4.Message); }
}
private void btn_SaveAddNew_Click(object sender, EventArgs e)
{
try
{
if (txt_CodeDarsAddNew.Text != "" && txt_NameDarsAddNew.Text != "" && txt_CountVahedAddNew.Text != "" && com_TypeAddNew.SelectedIndex >= 0)
{
UniversityDataContext udc = new UniversityDataContext();
Darse objDars = new Darse();
objDars.id_dars = Convert.ToInt32(txt_CodeDarsAddNew.Text);
objDars.name = txt_NameDarsAddNew.Text;
objDars.tedad_vahed = Convert.ToInt16(txt_CountVahedAddNew.Text);
objDars.type = com_TypeAddNew.Items[com_TypeAddNew.SelectedIndex].ToString();
udc.Darses.InsertOnSubmit(objDars);
udc.SubmitChanges();
FillGrid();
MessageBox.Show(".با موفقیت درج شد", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearAddNew();
}
else
{
MessageBox.Show(".لطفا اطلاعات را کامل کنید", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txt_CodeDarsAddNew.Select();
}
}
catch (Exception e3) { MessageBox.Show(e3.Message); }
}
private void btn_Search_Click(object sender, EventArgs e)
{
try
{
if (txt_codeDarsSearch.Text != "")
{
int idostad = Convert.ToInt32(txt_codeDarsSearch.Text);
UniversityDataContext udc = new UniversityDataContext();
var q = from p in udc.Darses
where p.id_dars == idostad
select p;
gridviewDars.DataSource = q;
}
if (txt_NameDarsSearch.Text != "")
{
UniversityDataContext udc = new UniversityDataContext();
var q = from p in udc.Darses
where p.name.StartsWith(txt_NameDarsSearch.Text)
select p;
gridviewDars.DataSource = q;
}
}
catch (Exception e6) { MessageBox.Show(e6.Message); }
}
private void gridviewDars_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == 0)
{
if (MessageBox.Show("آیا مابل به حذف این درس هستید؟ ", "پیام", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
Id_edit = Convert.ToInt16(gridviewDars.Rows[e.RowIndex].Cells["id"].Value.ToString());
UniversityDataContext udc = new UniversityDataContext();
var q = udc.Darses.Single(p => p.id == Id_edit);
udc.Darses.DeleteOnSubmit(q);
udc.SubmitChanges();
FillGrid();
MessageBox.Show(".با موفقیت حذف شد", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (e.ColumnIndex == 1)
{
Id_edit = Convert.ToInt32(gridviewDars.Rows[e.RowIndex].Cells["id"].Value);
txt_CodeDarsEdit.Text = gridviewDars.Rows[e.RowIndex].Cells["id_dars"].Value.ToString();
txt_NameDarsEdit.Text = gridviewDars.Rows[e.RowIndex].Cells["name"].Value.ToString();
txt_CountVahedEdit.Text = gridviewDars.Rows[e.RowIndex].Cells["tedad_vahed"].Value.ToString();
setComobox(gridviewDars.Rows[e.RowIndex].Cells["type"].Value.ToString());
allow_edit = true;
}
}
catch (Exception e4) { MessageBox.Show(e4.Message); }
}
private void FillFeild()
{
try
{
UniversityDataContext udc = new UniversityDataContext();
var query1 = from p in udc.Ostads.AsEnumerable()
select new { p.id_ostad };
com_OstadAddNew.ValueMember = "id_ostad";
com_OstadAddNew.DataSource = query1.ToList();
com_OstadAddNew.SelectedIndex = 0;
var query2 = from p in udc.Darses.AsEnumerable()
select new { p.id_dars };
com_DarsAddNew.ValueMember = "id_dars";
com_DarsAddNew.DataSource = query2.ToList();
com_DarsAddNew.SelectedIndex = 0;
var query3 = from p in udc.entekhabs
select p;
gridviewKarnameh.DataSource = query3;
}
catch (Exception e2) { MessageBox.Show(e2.Message); }
}
private void btn_SaveAddNew_Click(object sender, EventArgs e)
{
try
{
if (txt_CodeDaneshjooAddNew.Text != "" && txt_CountVahedAddNew.Text != "" && txt_ScoreAddNew.Text != "")
{
UniversityDataContext udc = new UniversityDataContext();
entekhab obj = new entekhab();
obj.id_student = Convert.ToInt32(txt_CodeDaneshjooAddNew.Text);
obj.id_ostad = Convert.ToInt32(com_OstadAddNew.Text);
obj.id_dars = Convert.ToInt32(com_DarsAddNew.Text);
obj.tedad_vahed = Convert.ToInt32(txt_CountVahedAddNew.Text);
obj.nomre = Convert.ToInt32(txt_ScoreAddNew.Text);
udc.entekhabs.InsertOnSubmit(obj);
udc.SubmitChanges();
FillFeild();
MessageBox.Show(".با موفقیت درج شد", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_CodeDaneshjooAddNew.Clear();
txt_CountVahedAddNew.Clear();
txt_ScoreAddNew.Clear();
}
else
{
MessageBox.Show(".لطفا اطلاعات را کامل کنید", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
catch (Exception e1) { MessageBox.Show(e1.Message); }
}
private void FillGrid()
{
try
{
UniversityDataContext udc = new UniversityDataContext();
var query = from p in udc.Students
select p;
gridviewDaneshjoo.DataSource = query;
}
catch (Exception e3) { MessageBox.Show(e3.Message); }
}
private void FillGrid()
{
try
{
UniversityDataContext udc = new UniversityDataContext();
var query = from p in udc.Darses
select p;
gridviewDars.DataSource = query;
}
catch (Exception e2) { MessageBox.Show(e2.Message); }
}
private void btn_Compute_Click(object sender, EventArgs e)
{
try
{
if (txt_CodeDaneshjoo2.Text != "")
{
UniversityDataContext udc = new UniversityDataContext();
var query = from p in udc.entekhabs
where p.id_student == Convert.ToInt32(txt_CodeDaneshjoo2.Text)
select p;
gridviewKarnameh.DataSource = query;
if (gridviewKarnameh.Rows.Count > 0)
{
int count_rows = gridviewKarnameh.Rows.Count;
int[] sum = new int[count_rows];
int[] vaheds = new int[count_rows];
for (int i = 0; i < gridviewKarnameh.Rows.Count; i++)
{
int vahed = Convert.ToInt32(gridviewKarnameh.Rows[i].Cells["tedad_vahed"].Value.ToString());
int nomreh = Convert.ToInt32(gridviewKarnameh.Rows[i].Cells["nomre"].Value.ToString());
sum[i] = (vahed * nomreh);
vaheds[i] = Convert.ToInt32(gridviewKarnameh.Rows[i].Cells["tedad_vahed"].Value.ToString());
}
double sumVahed = vaheds.Sum();
double sumScore = sum.Sum();
double ave = sumScore / sumVahed;
lbl_CountCources.Text = count_rows.ToString();
lbl_SumScore.Text = sumScore.ToString();
lbl_Average.Text = ave.ToString();
}
else
{
MessageBox.Show(".دانشجویی موجود نیست", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(".لطفا شماره دانشجویی را وارد کنید", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Error);
txt_CodeDaneshjoo2.Select();
}
}
catch (Exception e5) { MessageBox.Show(e5.Message); }
}
private void btn_Search_Click(object sender, EventArgs e)
{
try
{
if (txt_codeDaneshjooSearch.Text != "")
{
int idostad = Convert.ToInt32(txt_codeDaneshjooSearch.Text);
UniversityDataContext udc = new UniversityDataContext();
var q = from p in udc.entekhabs
where p.id_student == idostad
select p;
gridviewKarnameh.DataSource = q;
}
}
catch (Exception e3) { MessageBox.Show(e3.Message); }
}
private void gridviewKarnameh_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == 0)
{
if (MessageBox.Show("آیا مابل به حذف این نمره هستید؟ ", "پیام", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
Id_edit = Convert.ToInt16(gridviewKarnameh.Rows[e.RowIndex].Cells["id"].Value.ToString());
UniversityDataContext udc = new UniversityDataContext();
var q = udc.entekhabs.Single(p => p.id == Id_edit);
udc.entekhabs.DeleteOnSubmit(q);
udc.SubmitChanges();
FillFeild();
MessageBox.Show(".با موفقیت حذف شد", "پیام", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception e4) { MessageBox.Show(e4.Message); }
}
public TranscriptService(UniversityDataContext dataContext, IMapper mapper)
{
_dataContext = dataContext;
_mapper = mapper;
}
public AddressService(UniversityDataContext dataContext, IMapper mapper)
{
_dataContext = dataContext;
_mapper = mapper;
}
