private void btnLogin_Click(object sender, EventArgs e)
{
try
{
//Generate Password Hash and Check Login Data
var dc = new ClassSRMDataContext(Config.connection);
byte1 = UTF8Encoding.UTF8.GetBytes(txtPass.Text);
byte2 = sha.ComputeHash(byte1);
Hash = BitConverter.ToString(byte2);
var checkLogin = (from v in dc.tbl_Users where v.Name == txtUserName.Text && v.Pass == Hash select v);
if (checkLogin.Count() > 0)
{
this.Hide();
new Form1().ShowDialog();
}
else
{
XtraMessageBox.Show("مشخصات کاربری اشتباه است", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtUserName.Select();
txtPass.Text = string.Empty;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (gridView1.RowCount != 0)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
int id = (int)gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Id");
dc.UpdateSchool(id, txtSName.Text, txtAName.Text, cmbClass.Text, txtDate.Text);
tblSchoolBindingSource.EndEdit();
dc = new ClassSRMDataContext(Config.connection);
XtraMessageBox.Show("مدرسه موردنظر با موفقیت ویرایش شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information);
Schoollist_Load(null, null);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("اطلاعاتی برای ویرایش وجود ندارد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSchoolList_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
new Schoollist().ShowDialog();
tblSchoolBindingSource.DataSource = dc.SelectSchool();
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
if (rd.SelectedIndex == 0)
{
dc.InsertActPoint((int)cmbStudent.EditValue, (int)txtScore.Value, txtDate.Text, txtDesc.Text);
XtraMessageBox.Show("امتیاز موردنظر با موفقیت ثبت شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbStudent_EditValueChanged(null, null);
}
else
{
int val = getValeofItem(cmbScore.Text);
dc.InsertActPoint((int)cmbStudent.EditValue, val, txtDate.Text, txtDesc.Text);
XtraMessageBox.Show("امتیاز موردنظر با موفقیت ثبت شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbStudent_EditValueChanged(null, null);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
int id = (int)gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Id");
int idStu = (int)gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "StudentId");
bool exist = (bool)gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Exist");
var date = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Date").ToString();
if (exist)
{
exist = false;
}
else
{
exist = true;
}
dc.UpdateCheck(id, idStu, exist, date);
checkVBindingSource.EndEdit();
dc = new ClassSRMDataContext(Config.connection);
XtraMessageBox.Show("حضورغیاب موردنظر با موفقیت ویرایش شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception)
{
}
}
private void Process_Load(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
tblSchoolBindingSource.DataSource = dc.SelectSchool();
cmbClass.ItemIndex = 0;
}
private void ChartQuery()
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
var queryWin1 = (from tbl_ActPoints in dc.tbl_ActPoints //دریافت دانش آموز برتر
group tbl_ActPoints by new
{
tbl_ActPoints.StudentId
} into g
orderby
(int?) g.Sum(p => p.Score) descending
select new
{
g.Key.StudentId,
AverageScore = (int?)g.Sum(p => p.Score)
}).Take(1).FirstOrDefault();
var queryWin2 = (from tbl_EvaPoint in dc.tbl_EvaPoints //دریافت دانش آموز برتر
group tbl_EvaPoint by new
{
tbl_EvaPoint.StudentId
} into g
orderby
(int?) g.Sum(p => p.Score) descending
select new
{
g.Key.StudentId,
AverageScore = (int?)g.Sum(p => p.Score)
}).Take(1).FirstOrDefault();
var queryWin3 = (from T in (((from tbl_ActPoints in dc.tbl_ActPoints
select new
{
StudentId = (int?)tbl_ActPoints.StudentId,
Score = (int?)tbl_ActPoints.Score
}).Concat(
from tbl_EvaPoints in dc.tbl_EvaPoints
select new
{
StudentId = (int?)tbl_EvaPoints.StudentId,
Score = (int?)tbl_EvaPoints.Score
})))
group T by new
{
T.StudentId
} into g
orderby g.Sum(p => p.Score) descending
select new
{
g.Key.StudentId,
HighScoreUser = g.Sum(p => p.Score)
}).Take(1).FirstOrDefault();
userId1 = queryWin1.StudentId.Value;
userId2 = queryWin2.StudentId.Value;
userId3 = queryWin3.StudentId.Value;
}
catch (Exception)
{
}
}
private void cmbClass_EditValueChanged(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
tblStudentBindingSource.DataSource = dc.SelectStudentByClassIdNoIMG((int)cmbClass.EditValue);
cmbStudent.ItemIndex = 0;
}
private void tileView_ItemDrop(object sender, DevExpress.XtraGrid.Views.Tile.ItemDropEventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
var newStatus = e.GroupColumnValue;
var prevStatus = e.PrevGroupColumnValue;
if (!prevStatus.Equals(newStatus))
{
var id = tileView.GetRowCellValue(e.RowHandle, "Id");
int lbl = (int)tileView.GetRowCellValue(e.RowHandle, "Label");
if (newStatus.ToString().Equals("انجام شده"))
{
lbl = 2;
}
else if (newStatus.ToString().Equals("درحال انجام"))
{
lbl = 1;
}
else if (newStatus.ToString().Equals("برای انجام"))
{
lbl = 0;
}
else
{
lbl = (int)tileView.GetRowCellValue(e.RowHandle, "Label");
}
dc.UpdateTaskLabel((int)id, newStatus.ToString(), lbl);
dc.SubmitChanges();
dc = new ClassSRMDataContext(Config.connection);
InitData();
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (gridView1.RowCount != 0)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
int id = (int)gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Id");
var result = XtraMessageBox.Show("آیا از حذف این امتیاز اطمینان دارید؟", "توجه", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
dc.DeleteEvaBook(id);
XtraMessageBox.Show("امتیاز موردنظر با موفقیت حذف شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbStudent_EditValueChanged(null, null);
}
}
catch (Exception)
{
}
}
else
{
XtraMessageBox.Show("اطلاعاتی برای حذف وجود ندارد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Shedule_Load(object sender, EventArgs e)
{
context = new ClassSRMDataContext(Config.connection);
DBAppointmentList apts = new DBAppointmentList();
apts.AddRange(context.DBAppointments.ToArray());
List <DBResource> resources = new List <DBResource>();
resources.AddRange(context.DBResources.ToArray());
AppointmentStorage aptStorage = schedulerStorage1.Appointments;
ResourceStorage resStorage = schedulerStorage1.Resources;
aptStorage.Mappings.AllDay = "AllDay";
aptStorage.Mappings.Description = "Description";
aptStorage.Mappings.End = "EndTime";
aptStorage.Mappings.Label = "Label";
aptStorage.Mappings.Location = "Location";
aptStorage.Mappings.RecurrenceInfo = "RecurrenceInfo";
aptStorage.Mappings.ReminderInfo = "ReminderInfo";
aptStorage.Mappings.ResourceId = "CarIdShared";
aptStorage.Mappings.Start = "StartTime";
aptStorage.Mappings.Status = "Status";
aptStorage.Mappings.Subject = "Subject";
aptStorage.Mappings.Type = "EventType";
resStorage.Mappings.Id = "ID";
resStorage.Mappings.Caption = "Model";
resStorage.Mappings.Image = "Picture";
resStorage.DataSource = resources;
aptStorage.DataSource = apts;
schedulerControl1.GoToToday();
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (gridView1.RowCount != 0)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
byte[] imageData = imageToByteArray(img.Image);
int id = (int)gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Id");
dc.UpdateStudent(id, (int)lookUpEdit2.EditValue, txtName.Text, txtLName.Text, txtFName.Text, cmbGender.Text, imageData);
tblStudentBindingSource.EndEdit();
dc = new ClassSRMDataContext(Config.connection);
XtraMessageBox.Show("دانش آموز موردنظر با موفقیت ویرایش شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadStudent();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("اطلاعاتی برای ویرایش وجود ندارد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PointBook_Load(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
GC.Collect();
GC.WaitForPendingFinalizers();
var tosifi = Config.ReadSetting("Tosifi System");
if (tosifi == "true")
{
cmbScore2Visibility.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
cmbScoreVisibility.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
}
else
{
cmbScore2Visibility.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
cmbScoreVisibility.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
}
tblSchoolBindingSource.DataSource = dc.SelectSchool();
cmbClass.ItemIndex = 0;
if (isQuastion)
{
cmbBook.SelectedIndex = bookIndex;
cmbClass.EditValue = SchoolId;
tblStudentBindingSource.DataSource = dc.SelectStudentByClassIdNoIMG((int)cmbClass.EditValue);
cmbStudent.EditValue = StudentId;
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (gridView1.RowCount != 0)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
int id = (int)gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Id");
var result = XtraMessageBox.Show("با حذف دانش آموز، تمامی امتیازات آن حذف خواهند شد.آیا ادامه می دهید؟", "توجه", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
dc.DeleteStudent(id);
XtraMessageBox.Show("دانش آموز موردنظر با موفقیت حذف شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadStudent();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("اطلاعاتی برای حذف وجود ندارد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbStudent_EditValueChanged(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
var query = dc.SelectCurScore((int)cmbStudent.EditValue).First();
lblCurScore.Text = query.ScoreSum.ToString();
}
private void PointActivityList_Load(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
tblSchoolBindingSource.DataSource = dc.SelectSchool();
cmbClass.ItemIndex = 0;
EditableProgressBar();
}
private void frmLetterAll_Load(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
tblSchoolBindingSource.DataSource = dc.SelectSchool();
cmbClass.ItemIndex = 0;
txtDate.EditValue = DateTime.Now;
}
private void Ask_Load(object sender, EventArgs e)
{
GC.Collect();
GC.WaitForPendingFinalizers();
var dc = new ClassSRMDataContext(Config.connection);
tblSchoolBindingSource.DataSource = dc.SelectSchool();
cmbClass.ItemIndex = 0;
}
private void Form1_Load(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
tblSchoolBindingSource.DataSource = dc.SelectSchool();
cmbClass.ItemIndex = Convert.ToInt32(Config.ReadSetting("Default School"));
EnableAnim();
pCalendar.DateTime = DateTime.Now;
initScheduler();
txtDate1.DateTime = DateTime.Now;
}
private void cmbClass_EditValueChanged(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
int count = (cmbClass.Properties.DataSource as IList).Count;
if (count > 0)
{
tblStudentBindingSource.DataSource = dc.SelectStudentByClassIdNoIMG((int)cmbClass.EditValue);
cmbStudent.ItemIndex = 0;
}
}
private void cmbClass2_EditValueChanged(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
int count = (cmbClass2.Properties.DataSource as IList).Count;
if (count > 0)
{
bsStudent.DataSource = dc.SelectTopYear((int)cmbClass2.EditValue);
}
}
private void cmbClass_EditValueChanged(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
string date = txtDate.Text.Substring(0, 7);
int count = (cmbClass.Properties.DataSource as IList).Count;
if (count > 0)
{
gridControl1.DataSource = dc.SelectTopMonth((int)cmbClass.EditValue, date + "/01", date + "/31");
}
}
private void CompareBarChart_Load(object sender, EventArgs e)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
tblSchoolBindingSource.DataSource = dc.SelectSchool();
}
catch (Exception)
{
}
}
private void cmbClass_EditValueChanged(object sender, EventArgs e)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
tblStudentBindingSource.DataSource = dc.SelectStudentByClassIdNoIMG((int)cmbClass.EditValue);
}
catch (Exception)
{
XtraMessageBox.Show("برنامه با مشکل مواجه شد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void loadStudent()
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
tblStudentBindingSource.DataSource = dc.SelectStudentByClassId((int)cmbClass.EditValue);
}
catch (InvalidOperationException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnActive_Click(object sender, EventArgs e)
{
var dc = new ClassSRMDataContext(Config.connection);
dc.InsertCheck((int)gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Id"), true, strDate);
gridView1.DeleteSelectedRows();
gridView1.SelectRow(0);
lblCount.Text = gridView1.DataRowCount + " نفر بررسی نشده اند";
if (gridView1.DataRowCount == 0)
{
Close();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
dc.InsertSchool(txtSchool.Text, txtAdmin.Text, cmbClass.Text, txtDate.Text);
XtraMessageBox.Show("مدرسه موردنظر با موفقیت ثبت شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbClass_EditValueChanged(object sender, EventArgs e)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
bsStudent.DataSource = dc.SelectGifts((int)cmbClass.EditValue, strYear + "/" + strCurMonth + "/" + "01", strYear + "/" + strCurMonth + "/" + "31", strYear + "/" + PrevMonth.ToString("00") + "/" + "01", strYear + "/" + PrevMonth.ToString("00") + "/" + "31");
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Load Student
private void LoadStudent()
{
var dc = new ClassSRMDataContext(Config.connection);
int count = (cmbClass.Properties.DataSource as IList).Count;
if (count > 0)
{
int id = (int)cmbClass.EditValue;
tblStudentBindingSource.DataSource = dc.SelectStudentByClassId(id);
}
GC.Collect();
GC.WaitForPendingFinalizers();
}
private void cmbClass_EditValueChanged(object sender, EventArgs e)
{
try
{
var dc = new ClassSRMDataContext(Config.connection);
sumAEBindingSource.DataSource = from v in dc.SumAEs where v.StuClassId == (int)cmbClass.EditValue select v;
chartControl1.Series["Series 1"].LegendText = cmbClass.Text;
}
catch (Exception)
{
XtraMessageBox.Show("مشکلی پیش آمده است", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
