protected void setAutoComplete()
{
TaaliClasses.DataList data = new TaaliClasses.DataList();
var id = from c in data.ClassList()
select c.ClassID.ToString();
if (id != null && id.Count() > 0)
{
boxID.AutoCompleteCustomSource.AddRange(id.ToArray());
}
var department = from c in data.ClassList()
where c.Department != null && !c.Department.Equals("")
select c.Department;
if (department != null && department.Count() > 0)
{
boxDepartment.AutoCompleteCustomSource.AddRange(department.ToArray());
}
var floor = from c in data.ClassList()
where c.BuildingFloor != null
select c.BuildingFloor.ToString();
if (floor != null && floor.Count() > 0)
{
boxFloor.AutoCompleteCustomSource.AddRange(floor.ToArray());
}
var capacity = from c in data.ClassList()
select c.Capacity.ToString();
if (capacity != null && capacity.Count() > 0)
{
boxCapacity.AutoCompleteCustomSource.AddRange(capacity.ToArray());
}
}
protected void setAutoComplete()
{
TaaliClasses.DataList data = new TaaliClasses.DataList();
var typeTitle = from t in data.TypeList()
select t.TypeTitle;
if (typeTitle != null && typeTitle.Count() > 0)
{
boxType.AutoCompleteCustomSource.AddRange(typeTitle.ToArray());
}
var hours = from t in data.TypeList()
select t.HoursPerUnit.ToString();
if (hours != null && hours.Count() > 0)
{
boxHours.AutoCompleteCustomSource.AddRange(hours.ToArray());
}
var salary = from t in data.TypeList()
select t.SalaryPerUnit.ToString();
if (salary != null && salary.Count() > 0)
{
boxSalary.AutoCompleteCustomSource.AddRange(salary.ToArray());
}
var price = from t in data.TypeList()
select t.PricePerUnit.ToString();
if (price != null && price.Count() > 0)
{
boxPrice.AutoCompleteCustomSource.AddRange(price.ToArray());
}
}
protected void setAutoComplete()
{
TaaliClasses.DataList data = new TaaliClasses.DataList();
var level = from m in data.MajorList()
where m.MajorLevel != null && !m.MajorLevel.Equals("")
select m.MajorLevel;
if (level != null && level.Count() > 0)
{
boxMajorLevel.AutoCompleteCustomSource.AddRange(level.ToArray());
}
var title = from m in data.MajorList()
where m.Title != null && !m.Title.Equals("")
select m.Title;
if (title != null && title.Count() > 0)
{
boxTitle.AutoCompleteCustomSource.AddRange(title.ToArray());
}
var branch = from m in data.MajorList()
where m.Branch != null && !m.Branch.Equals("")
select m.Branch;
if (branch != null && branch.Count() > 0)
{
boxBranch.AutoCompleteCustomSource.AddRange(branch.ToArray());
}
}
protected void setAutoComplete()
{
TaaliClasses.DataList data = new TaaliClasses.DataList();
var title = from s in data.SubjectList()
where s.Title != null
select s.Title.ToString();
if (title != null && title.Count() > 0)
{
boxTitle.AutoCompleteCustomSource.AddRange(title.ToArray());
}
}
protected override void btnOK_Click(object sender, EventArgs e)
{
this.setData(new Class());
TaaliClasses.DataList data = new TaaliClasses.DataList();
var cList = data.FindClass(this.TheClass.ClassID,
this.TheClass.Department, this.TheClass.BuildingFloor, this.TheClass.Capacity);
if (cList.Count <= 0)
{
MessageBox.Show("هیج کلاسی با ابن مشخصات یافت نشد.", "خطا",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
return;
}
this.Classes = cList;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
protected override void btnOK_Click(object sender, EventArgs e)
{
this.setData(new SubjectType());
TaaliClasses.DataList data = new TaaliClasses.DataList();
var typeList = data.FindType(this.TheType.TypeTitle, this.TheType.Theory);
if (typeList.Count <= 0)
{
MessageBox.Show("نوع درس با این مشخصات یافت نشد.", "خطا",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
return;
}
this.Types = typeList;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
private void btnAddTeacher_Click(object sender, EventArgs e)
{
TeacherCategory.BaseTeacherForm btf = new TeacherCategory.BaseTeacherForm();
TaaliClasses.DataList data = new TaaliClasses.DataList();
btf.Teachers = data.TeacherList().Where(t => t.SubjectTeachers.Where(st =>
st.SubjectID == this.TheSubject.SubjectID && st.Active).Count() > 0 &&
(from tt in t.TimeTeachers
join uht in this.Times
on tt.TimeID equals uht.HoldingTimeID
where uht.Enabled && tt.Active
select tt.Teacher).Count() > 0 &&
(from ti in this.Times
join tt in this.TimeTableCells
on ti.HoldingTimeID equals tt.TimeTeacher.TimeID
where tt.TimeTeacher.TeacherID == t.TeacherID
select ti).Count() == 0).ToList();
btf.SetDontShowControls();
btf.MultiSelect = false;
DialogResult dr = btf.ShowDialog();
if (dr == System.Windows.Forms.DialogResult.OK)
{
try
{
this.TheTeacher = taali.Teachers.ToList().Where(t => t.TeacherID == btf.SelectedItems
.SelectedItems[0].TeacherID && t.SubjectTeachers.Where(st => st.Active &&
st.SubjectID == this.TheSubject.SubjectID).Count() > 0 &&
(from tt in t.TimeTeachers
join ti in this.Times
on tt.TimeID equals ti.HoldingTimeID
where ti.Enabled
select tt.Teacher).Count() > 0).Single();
this.boxTeacher.Text = this.TheTeacher.ToString();
this.btnAddTeacher.Enabled = false;
this.btnDeleteTeacher.Enabled = true;
this.btnAddClass.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "خطا",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
}
}
}
protected override void btnOK_Click(object sender, EventArgs e)
{
this.TheSubject = new Subject();
this.setData();
TaaliClasses.DataList data = new TaaliClasses.DataList();
var subjects = data.FindSubject(this.TheSubject.Title, this.TheSubject.SubjectType);
if (subjects.Count <= 0)
{
MessageBox.Show("هیچ درسی پیدا نشد.", "خطا",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
return;
}
this.Subjects = subjects;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
protected override void btnOK_Click(object sender, EventArgs e)
{
this.TheTeacher = new Teacher();
this.setData();
TaaliClasses.DataList data = new TaaliClasses.DataList();
var teachers = data.FindTeacher(this.TheTeacher.FirstName, this.TheTeacher.LastName);
if (teachers.Count <= 0)
{
MessageBox.Show("هیچ استادی با این مشخصات یافت نشد.", "خطا",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
return;
}
this.Teachers = teachers;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
protected override void btnOK_Click(object sender, EventArgs e)
{
this.setData(new Major());
TaaliClasses.DataList data = new TaaliClasses.DataList();
var majors = data.FindMajor(this.TheMajor.MajorLevel,
this.TheMajor.Title, this.TheMajor.Branch);
if (majors.Count <= 0)
{
MessageBox.Show("رشته تحصیلی با این مشخصات وجود ندارد.", "خطا",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
return;
}
//TaaliClasses.DataExchange.Majors = majors;
this.Majors = majors;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
protected override void btnOK_Click(object sender, EventArgs e)
{
this.TheGroup = new Group();
this.setData();
TaaliClasses.DataList data = new TaaliClasses.DataList();
var groups = data.FindGroup(this.TheGroup.Major, this.TheGroup.Title,
this.TheGroup.EnterYear, this.TheGroup.EnterSemester, this.TheGroup.NumberOfStudent);
if (groups.Count <= 0)
{
MessageBox.Show("هیچ گروهی پیدا نشد.", "خطا",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
return;
}
this.Groups = groups;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
protected void setAutoComplete()
{
TaaliClasses.DataList data = new TaaliClasses.DataList();
var title = from g in data.GroupList()
where g.Title != null && !g.Title.Equals("")
select g.Title;
if (title != null && title.Count() > 0)
{
boxGroupTitle.AutoCompleteCustomSource.AddRange(title.ToArray());
}
var numberOfStudent = from g in data.GroupList()
where g.NumberOfStudent != null
select g.NumberOfStudent.ToString();
if (numberOfStudent != null && numberOfStudent.Count() > 0)
{
boxNumberOFStudent.AutoCompleteCustomSource.AddRange(numberOfStudent.ToArray());
}
}
protected void setAutoComplete()
{
TaaliClasses.DataList data = new TaaliClasses.DataList();
var first = from s in data.TeacherList()
where s.FirstName != null
select s.FirstName;
if (first != null && first.Count() > 0)
{
boxFirstName.AutoCompleteCustomSource.AddRange(first.ToArray());
}
var last = from s in data.TeacherList()
where s.LastName != null
select s.LastName;
if (last != null && last.Count() > 0)
{
boxLastName.AutoCompleteCustomSource.AddRange(last.ToArray());
}
}
private void btnAddClass_Click(object sender, EventArgs e)
{
ClassCategory.BaseClassForm bcf = new ClassCategory.BaseClassForm();
bcf.MultiSelect = false;
TaaliClasses.DataList data = new TaaliClasses.DataList();
bcf.Classes = data.ClassList()
.Where(c => (from ti in this.Times
join tt in this.TimeTableCells
on ti.HoldingTimeID equals tt.TimeTeacher.TimeID
where tt.ClassID == c.ClassID
select ti).Count() == 0).ToList();
bcf.SetDontShowControls();
DialogResult dr = bcf.ShowDialog();
if (dr == System.Windows.Forms.DialogResult.OK)
{
this.TheClass = taali.Classes.Where(c => c.ClassID == bcf.SelectedClasses
.SelectedItems[0].ClassID).Single();
this.boxClass.Text = this.TheClass.ClassID.ToString();
this.btnAddClass.Enabled = false;
this.btnDeleteClass.Enabled = true;
}
}
