protected void Page_Load(object sender, EventArgs e)
{
// MyDate mydate = new MyDate();
if (!IsPostBack)
{
var schoolid = new SchoolInformation().getId();
var semesterid = MyDate.getCurrentSemesterId();
lbldate.Text = "التاريخ: " + MyDate.getHijriDate();
lblDay.Text = "اليوم: " + MyDate.getDay();
ddlClass.DataSource = (from k in km.SubjectsInSemesters where
k.SchoolId == schoolid && k.SemesterId == semesterid
orderby k.ClassId
select k.ClassId).ToList().Distinct();
ddlClass.DataBind();
ddlSubject.DataBind();
SchoolInformation info = new SchoolInformation();
// var schoolid = info.getId();
var lstStudents = (from k in km.Students
where k.SchoolId == schoolid
select new
{
k.IdentityNumber,
k.Name
}).ToList();
ListView1.DataSource = lstStudents;
ListView1.DataBind();
}
// VisiblePlaceHolder();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnView_Click(object sender, EventArgs e)
{
var classid = ddlClass.SelectedValue;
var subjectid = (from k in km.Subjects where k.Name == ddlSubject.SelectedValue select k.Id).FirstOrDefault();
var schoolid = new SchoolInformation().getId();
var semesterid = MyDate.getCurrentSemesterId();
var subject = (from k in km.SubjectsInSemesters
where k.SchoolId == schoolid && k.SemesterId == semesterid &&
k.SubjectId == subjectid && k.ClassId == classid
select k
).FirstOrDefault();
var lstStudent = (from k in km.StudentsSubjects
join
s in km.Students on k.StudentId equals s.IdentityNumber
where k.SubjectId == subject.Id
orderby s.Name
select new
{
s.Name,
s.Id,
s.IdentityNumber
}).ToList();
ListView1.DataSource = lstStudent;
ListView1.DataBind();
}
public ActionResult <object> Save([FromBody] SchoolInformation schoolInformation)
{
try
{
Init();
StringBuilder sbError = new StringBuilder("");
if (!ModelState.IsValid)
{
Response.StatusCode = 400;
return("Failed getting schoolInformation id");
}
else
{
if (string.IsNullOrEmpty(schoolInformation.SchoolId.ToString()))
{
schoolInformation.SchoolId = _user.SchoolID;
}
var isSaved = _schoolInformationService.Save(schoolInformation, ref sbError);
if (!isSaved)
{
Response.StatusCode = 400;
return("schoolInformation save failed " + sbError.ToString());
}
else
{
return((string)"schoolInformation saved successfully");
}
}
}
catch (Exception er)
{
return(Error(er));
}
}
protected void LstEmployee_DataBinding(object sender, EventArgs e)
{
OnlineSchoolEntities km = new OnlineSchoolEntities();
var schoolId = new SchoolInformation().getId();
var semesterId = MyDate.getCurrentSemesterId();
var isSeen = (from m in km.UsersGeneralizations select m.isSeen).FirstOrDefault();
string IsSeenn;
if (isSeen == false)
{
IsSeenn = "لا";
}
else
{
IsSeenn = "نعم";
}
var emp = (from k in km.UsersGeneralizations
select new
{
IsSeenn,
EmployeeName = (from m in km.Employees where m.IdentityNumber == k.UserId select m.Name).FirstOrDefault()
}).ToList();
LstEmployee.DataSource = emp;
LstEmployee.DataBind();
}
protected void ddlStudentID_SelectedIndexChanged(object sender, EventArgs e)
{
var idd = ddlStudentID.SelectedValue;
int schoolid = new SchoolInformation().getId();
txtStudentName.Text = (from k in km.Students where k.IdentityNumber == idd && k.SchoolId == schoolid select k.Name).FirstOrDefault();
}
protected void lstViolence_DataBinding(object sender, EventArgs e)
{
counter = 0;
var schoolid = new SchoolInformation().getId();
DateTime date = DateTime.Now.Date;
//if (Calendar1.CultureName == "ar-SA")
//{
// date = (MyDate.convertHijriToGregorian(txtDate.Text)).Date;
//}
//else
//{
// date = DateTime.ParseExact(txtDate.Text, "yyyy/MM/dd", CultureInfo.CreateSpecificCulture("ar-EG")).Date;
//}
var lst = (from k in km.StudentsViolations
join s in km.Students on k.StudentId equals s.IdentityNumber
join v in km.Violations on k.ViolationId equals v.Id
where s.SchoolId == schoolid
select new
{
s.Id,
s.Name,
v.Title,
v.Grade,
k.Count,
teacher = (from emp in km.Employees where emp.IdentityNumber == k.TeacherId select emp.Name).FirstOrDefault()
}).ToList();
lstViolence.DataSource = lst;
}
protected void btnSaveActivity_Click(object sender, EventArgs e)
{
OnlineSchoolEntities km = new OnlineSchoolEntities();
SchoolInformation info = new SchoolInformation();
Schedual activity = new Schedual();
activity.type = int.Parse(ddlActivity.SelectedValue);
activity.Name = txtActivityName.Text;
activity.Time = Convert.ToDateTime(txtActivityTime.Text).TimeOfDay;
activity.Period = new TimeSpan(0, int.Parse(txtPeriod.Text), 0);
activity.SchoolId = info.getId();
km.Scheduals.Add(activity);
km.SaveChanges();
lstActive.DataBind();
// lblmsg.Text = "تم اضافة النشاط";
lstActive.DataBind();
var nxt = activity.Time + activity.Period;
txtActivityTime.Text = Convert.ToDateTime(nxt.ToString()).ToString("mm:ss tt");
txtActivityName.Text = "";
txtPeriod.Text = "";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "openModal", "<script> addSuccess(' تمت اضافة النشاط بنجاح'); </script>", false);
}
protected void lstBorrow_DataBinding(object sender, EventArgs e)
{
OnlineSchoolEntities km = new OnlineSchoolEntities();
SchoolInformation info = new SchoolInformation();
ltrYear.Text = " " + (from k in km.Semesters where k.IsCurrent == true select k.YearH).FirstOrDefault().ToString();
ltrSemester.Text = " " + MyDate.getCurrentSemester();
ltrSecretaryResourceCenter.Text = info.getLearningResources();
var schoolId = info.getId();
var semesterId = MyDate.getCurrentSemesterId();
// var LibrarianId = info.getSchoolLibrarian();
var preInfo = (from k in km.BorrowsofStudents
join ss in km.Students on k.StudentId equals ss.IdentityNumber
where k.SchoolId == schoolId && k.SemesterId == semesterId
orderby k.DateBorrow
select new
{
ss.Name,
k.DateReturn,
k.DateBorrow,
k.BookId,
ss.Class,
auther = (from b in km.Books where b.Id == k.BookId select b.Auther).FirstOrDefault(),
bookname = (from b in km.Books where b.Id == k.BookId select b.Title).FirstOrDefault(),
k.isReturn
}).ToList();
lstBorrow.DataSource = preInfo;
}
protected void LstOutcoming_DataBinding(object sender, EventArgs e)
{
OnlineSchoolEntities km = new OnlineSchoolEntities();
var schoolId = new SchoolInformation().getId();
int semesterId = MyDate.getCurrentSemesterId();
var Outcoming = (from O in km.Outcomings
where O.IsDeleted != true &&
O.ReceivedDate != null && O.SemesterId == semesterId &&
O.SchoolId == schoolId
select new
{
O.Number,
O.Date,
O.Type,
O.Attachment,
O.Subject,
O.SourceTo,
O.ReceivedName,
O.ReceivedDate,
O.Id,
}).ToList();
LstOutcoming.DataSource = Outcoming;
LstOutcoming.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
SchoolInformation info = new SchoolInformation();
var schoolid = info.getId();
var semesterid = MyDate.getCurrentSemesterId();
OnlineSchoolEntities km = new OnlineSchoolEntities();
var studentlist = (from k in km.StudentsSubjects
join s in km.SubjectsInSemesters on k.SubjectId equals s.Id
join x in km.Students on k.StudentId equals x.IdentityNumber
where s.SchoolId == schoolid && s.SemesterId == semesterid
orderby x.Name
select new
{
stdId = x.Id,
Name = x.Name,
x.IdentityNumber,
subject = (from m in km.Subjects where m.Id == s.SubjectId select m.Name).FirstOrDefault(),
rate = k.Rate
}
).ToList();
ListView1.DataSource = studentlist;
ListView1.DataBind();
}
/// <summary>
/// Open On section
/// </summary>
public void OpenSection()
{
if (SchoolInformation.IsElementDisplayed())
{
SchoolInformation.Click();
}
}
protected void lstPatients_DataBinding(object sender, EventArgs e)
{
OnlineSchoolEntities km = new OnlineSchoolEntities();
var schoolId = new SchoolInformation().getId();
int semesterId = MyDate.getCurrentSemesterId();
var RepInfo = (from ep in km.StudentPatients
join ee in km.Students on ep.StudentId equals ee.IdentityNumber
where ep.SemesterId == semesterId && ep.SchoolId == schoolId
orderby ep.Class descending
select new
{
ee.Name,
ep.Action,
ep.Class,
ep.Description,
ep.HomeTel,
ep.Id,
ep.Mobile,
ep.Recommendations,
ep.WorkTel,
}).ToList();
lstPatients.DataSource = RepInfo;
lstPatients.DataBind();
}
protected void ddlStudents_DataBinding(object sender, EventArgs e)
{
var schoolid = new SchoolInformation().getId();
var lstStd = (from k in km.Students where k.SchoolId == schoolid orderby k.Name select k).ToList();
ddlStudents.DataSource = lstStd;
}
public List <SchoolInformation> GetSchoolData(int Category)
{
List <SchoolInformation> MySkuls = new List <SchoolInformation>();
using (var Con = new SqlConnection(GC.ConnectionString))
{
Con.Open();
Query = "Select * from SchoolsView where CatType='" + Category + "'";
using (var Com = new SqlCommand(Query, Con))
{
Reader = Com.ExecuteReader();
while (Reader.Read())
{
SchoolInformation Sku = new SchoolInformation();
Sku.SchoolId = Convert.ToInt32(Reader["id"].ToString());
Sku.SchoolName = Reader["sch_name"].ToString();
Sku.Moto = Reader["Moto"].ToString();
Sku.RegistrationNumber = Reader["sch_reg_no"].ToString();
MySkuls.Add(Sku);
}
Com.Dispose();
}
Con.Close();
}
return(MySkuls);
}
protected void LstOutcoming_DataBinding(object sender, EventArgs e)
{
OnlineSchoolEntities km = new OnlineSchoolEntities();
var schoolId = new SchoolInformation().getId();
var semesterId = MyDate.getCurrentSemesterId();
var Outcoming = (from I in km.Outcomings
join p in km.Schools on I.SchoolId equals p.Id
where I.SchoolId == schoolId && I.IsDeleted != true && I.SemesterId == semesterId
orderby I.Id descending
select new
{
I.Date,
I.Number,
I.FileNumber,
SourceTo = (from c in km.Constants where c.Id == I.SourceTo select c.value).FirstOrDefault(),
I.Subject,
Type = (from c in km.Constants where c.Id == I.Type select c.value).FirstOrDefault(),
Attachment = (from c in km.Constants where c.Id == I.Type select c.value).FirstOrDefault(),
I.Id,
}).ToList();
LstOutcoming.DataSource = Outcoming;
LstOutcoming.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var number = new SchoolInformation().getSecretaryNumber();
if (number == 0)
{
pdfFrame.Attributes.Add("src", "~/Files/الخريطة_التنظيمية_لمدارس_التعليم_العام_وفقا_لحجم_المدرسة(بدون وكيل.pdf");
}
if (number == 1)
{
pdfFrame.Attributes.Add("src", "~/Files/الخريطة_التنظيمية_لمدارس_التعليم_العام_وفقا_لحجم_المدرسة(بوكيل واحد(.pdf");
}
else
if (number == 2)
{
pdfFrame.Attributes.Add("src", "~/Files/الخريطة_التعليمية_لمدارس_التعليم_العام_وفقا_لحجم_المدرسة(بوكيلين(.pdf");
}
else
if (number == 3)
{
pdfFrame.Attributes.Add("src", "~/Files/الخريطة_التعليمية_لمدارس_التعليم_العام_وفقا_لحجم_المدرسة(ثلاثة_وكلاء(.pdf");
}
}
}
protected void lstBorrow_DataBinding(object sender, EventArgs e)
{
OnlineSchoolEntities km = new OnlineSchoolEntities();
SchoolInformation info = new SchoolInformation();
var schoolId = info.getId();
var semesterId = MyDate.getCurrentSemesterId();
ltrSecretaryLearningResourceCenter.Text = info.getLearningResources();
var preInfo = (from k in km.BorrowsofEmployees
join ee in km.Employees on k.EmployeeId equals ee.IdentityNumber
where k.SchoolId == schoolId && k.SemesterId == semesterId
orderby k.DateReturn, k.DateBorrow
select new
{
ee.Name,
k.DateReturn,
k.DateBorrow,
k.BookId,
auther = (from b in km.Books where b.Id == k.BookId select b.Auther).FirstOrDefault(),
bookname = (from b in km.Books where b.Id == k.BookId select b.Title).FirstOrDefault(),
k.isReturn
}).ToList();
lstBorrow.DataSource = preInfo;
lstBorrow.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
var idd = int.Parse(Request.QueryString["id"]);
SchoolInformation info = new SchoolInformation();
var schoolid = info.getId();
OnlineSchoolEntities km = new OnlineSchoolEntities();
var absent = (from k in km.Absences where k.Id == idd select k).FirstOrDefault();
lblDate.Text = MyDate.getDate(absent.Date + "");
lblEmpName.Text = (from k in km.Employees where k.IdentityNumber == absent.EmployeeId select k.Name).FirstOrDefault();
var lstEmployee = (from k in km.Teachers where k.IdentityNumber != absent.EmployeeId && k.SchoolId == schoolid select k).ToList();
ddlEmployee.DataSource = lstEmployee;
ddlEmployee.DataBind();
LstClass.DataBind();
}
}
}
public Schools GetSchool(int SchoolId)
{
Schools School = new Schools();
using (var Con = new SqlConnection(GC.ConnectionString))
{
Con.Open();
Query = "Select * from SchoolsView where id ='" + SchoolId + "'";
using (var Com = new SqlCommand(Query, Con))
{
Reader = Com.ExecuteReader();
while (Reader.Read())
{
SchoolInformation Sku = new SchoolInformation();
Sku.SchoolId = Convert.ToInt32(Reader["id"].ToString());
Sku.SchoolName = Reader["sch_name"].ToString();
Sku.Moto = Reader["Moto"].ToString();
Sku.RegistrationNumber = Reader["sch_reg_no"].ToString();
School.Info = Sku;
}
Com.Dispose();
}
Con.Close();
}
return(School);
}
protected void btnsave_Click(object sender, EventArgs e)
{
SchoolInformation info = new SchoolInformation();
MyDate mydate = new MyDate();
foreach (ListViewItem item in ListView1.Items)
{
Button btnActive = (Button)item.FindControl("btnActive");
if (btnActive.Text == "غياب")
{
StudentsAbsence abs = new StudentsAbsence();
RadioButtonList radio = ((RadioButtonList)item.FindControl("radio"));
abs.SemesterId = MyDate.getCurrentSemesterId();
abs.SchoolId = info.getId();
abs.StudentId = int.Parse(((HiddenField)item.FindControl("HiddenField1")).Value).ToString();
abs.Date = DateTime.Now;
abs.IsExcuse = Convert.ToBoolean(radio.SelectedValue);
km.StudentsAbsences.Add(abs);
km.SaveChanges();
}
else if (btnActive.Text == "حضور")
{
StudentsAttendence att = new StudentsAttendence();
att.Date = DateTime.Now;
att.SchoolId = info.getId();
att.SemesterId = MyDate.getCurrentSemesterId();
att.StudentId = ((HiddenField)item.FindControl("HiddenField1")).Value;
//TextBox txtArrive = (TextBox)item.FindControl("txtarrivingTime");
//if (!String.IsNullOrEmpty(txtArrive.Text))
//att.ArrivingTime = Convert.ToDateTime(txtArrive.Text).TimeOfDay;
//TextBox txtDeparture = (TextBox)item.FindControl("txtdeptime");
//if (!String.IsNullOrEmpty(txtDeparture.Text))
// att.DepartureTime = Convert.ToDateTime(txtDeparture.Text).TimeOfDay;
km.StudentsAttendences.Add(att);
km.SaveChanges();
}
else if (btnActive.Text == "تأخر")
{
StudentsLateness late = new StudentsLateness();
if (!String.IsNullOrEmpty(((TextBox)item.FindControl("TimeLate")).Text))
{
late.TotalSeconds = Convert.ToDateTime(((TextBox)item.FindControl("TimeLate")).Text).TimeOfDay.TotalSeconds;
late.Amount = Convert.ToDateTime(((TextBox)item.FindControl("TimeLate")).Text).TimeOfDay;
}
late.Date = DateTime.Now;
late.SchoolId = info.getId();
late.SemesterId = MyDate.getCurrentSemesterId();
late.StudentId = ((HiddenField)item.FindControl("HiddenField1")).Value;
km.StudentsLatenesses.Add(late);
km.SaveChanges();
}
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('تم التسجيل بنجاح')", true);
}
Response.Redirect("~/Student/StudentAttendenceReport.aspx");
}
private void FillTable(int weekId)
{
// var weekId = int.Parse(ddlWeek.SelectedValue);
DateTime date = (DateTime)(from k in km.Weeks where k.Id == weekId select k.startDate).FirstOrDefault();
var day = date.DayOfWeek;
switch (day)
{
case DayOfWeek.Saturday:
date = date.AddDays(1);
break;
case DayOfWeek.Sunday:
;
break;
case DayOfWeek.Monday:
date = date.AddDays(-1);
break;
case DayOfWeek.Tuesday:
date = date.AddDays(-2);
break;
case DayOfWeek.Wednesday:
date = date.AddDays(-3);
break;
case DayOfWeek.Thursday:
date = date.AddDays(-4);
break;
case DayOfWeek.Friday:
date = date.AddDays(2);
break;
}
var lstDate = new List <DateTime>();
for (int i = 0; i <= 4; ++i)
{
lstDate.Add(date.AddDays(i));
}
var schoolid = new SchoolInformation().getId();
var semesterId = MyDate.getCurrentSemesterId();
var lst = (from dd in lstDate
select new
{
Date = dd,
}).Distinct().ToList();
lstVisits.DataSource = lst;
lstVisits.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
var idd = int.Parse(Request.QueryString["id"]);
OnlineSchoolEntities km = new OnlineSchoolEntities();
SchoolInformation info = new SchoolInformation();
var absentalert = (from k in km.AbsenceAlerts where k.Id == idd select k).FirstOrDefault();
ltrSchoolName.Text = info.getName();
var emp = (from k in km.Employees where k.IdentityNumber == absentalert.EmployeeId select k).FirstOrDefault();
ltrName.Text = emp.Name;
ltrTeacherName.Text = emp.Name;
ltrTeacherName2.Text = emp.Name;
ltrCivilRegistry10.Text = emp.IdentityNumber.ElementAt(0).ToString();
ltrCivilRegistry9.Text = emp.IdentityNumber.ElementAt(1).ToString();
ltrCivilRegistry8.Text = emp.IdentityNumber.ElementAt(2).ToString();
ltrCivilRegistry7.Text = emp.IdentityNumber.ElementAt(3).ToString();
ltrCivilRegistry6.Text = emp.IdentityNumber.ElementAt(4).ToString();
ltrCivilRegistry5.Text = emp.IdentityNumber.ElementAt(5).ToString();
ltrCivilRegistry4.Text = emp.IdentityNumber.ElementAt(6).ToString();
ltrCivilRegistry3.Text = emp.IdentityNumber.ElementAt(7).ToString();
ltrCivilRegistry2.Text = emp.IdentityNumber.ElementAt(8).ToString();
ltrCivilRegistry1.Text = emp.IdentityNumber.ElementAt(9).ToString();
ltrSpecialization.Text = emp.Specification;
ltrJobNo.Text = emp.JobNumber;
ltrGrade.Text = emp.Level;
ltrCommander.Text = EmployeeManager.getDirectManager(emp.IdentityNumber);
ltrCommanderName.Text = info.getSchoolManager();
ltrCommanderDate.Text = MyDate.getDate();
ltrCurrentWork.Text = (from k in km.Jobs where k.Id == emp.JobId select k.Name).FirstOrDefault();
ltrClass.Text = emp.Degree;
var DateFrom = (DateTime)absentalert.DateFrom;
var DateTo = (DateTime)absentalert.DateTo;
ltrDayFrom.Text = " " + MyDate.getDay(DateFrom) + " ";
ltrDayTo.Text = " " + MyDate.getDay(DateTo) + " ";
ltrDateTo.Text = " " + DateTo.Date.ToString("yyyy/MM/dd") + " ";
ltrDateFrom.Text = " " + DateFrom.Date.ToString("yyyy/MM/dd") + " ";
bool count = Convert.ToBoolean(Request.QueryString["count"]);
if (count)
{
ltrNoAbsenceDay.Text = absentalert.count + absentalert.countHoliday + "";
}
else
{
ltrNoAbsenceDay.Text = absentalert.count + "";
}
}
}
public static string getDirectManager(string identityNumber)
{
// var username = Membership.GetUser().UserName;
//var school = (from k in km.Employees where k.IdentityNumber == username select k.School).FirstOrDefault();
SchoolInformation info = new SchoolInformation();
return(info.getSchoolManager());
}
public void EmployeeName()
{
var schoolid = new SchoolInformation().getId();
var NameEmp = (from emp in ose.Employees where emp.SchoolId == schoolid orderby emp.Name select emp).ToList();
ddlEmployee.DataSource = NameEmp;
ddlEmployee.DataTextField = "Name";
ddlEmployee.DataValueField = "IdentityNumber";
ddlEmployee.DataBind();
}
public SchoolInformationDto(SchoolInformation schoolInformation)
{
SchoolName = schoolInformation.SchoolName;
Address = schoolInformation.Address;
PhoneNumber = schoolInformation.PhoneNumber;
Email = schoolInformation.Email;
SchoolIntroduction = schoolInformation.SchoolIntroduction;
WebsiteUrl = schoolInformation.WebsiteUrl;
Fax = schoolInformation.Fax;
}
protected void ddlStudentNumber_DataBinding(object sender, EventArgs e)
{
var schoolid = new SchoolInformation().getId();
var lst = (from k in km.Students where k.Id != null && k.SchoolId == schoolid orderby k.Id select k).ToList();
ddlStudentNumber.DataValueField = "IdentityNumber";
ddlStudentNumber.DataTextField = "Id";
ddlStudentNumber.DataSource = lst;
}
protected void ListView1_DataBinding(object sender, EventArgs e)
{
SchoolInformation info = new SchoolInformation();
var schoolid = info.getId();
OnlineSchoolEntities km = new OnlineSchoolEntities();
var Studentlist = (from k in km.Students where k.SchoolId == schoolid select k).ToList();
ListView1.DataSource = Studentlist;
}
protected void lstVisits_ItemDataBound(object sender, ListViewItemEventArgs e)
{
var schoolid = new SchoolInformation().getId();
var semesterId = MyDate.getCurrentSemesterId();
ListView lstSubjects = (ListView)(e.Item.FindControl("lstSubjects"));
ListView lstClass = (ListView)(e.Item.FindControl("lstClass"));
ListView lstTeacher = (ListView)(e.Item.FindControl("lstTeacher"));
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
if (e.Item.ItemType == ListViewItemType.DataItem)
{
DateTime date = Convert.ToDateTime(DataBinder.Eval(e.Item.DataItem, "Date").ToString());
var lst = new List <int> {
1, 2, 3, 4, 5, 6
};
var lst2 = (from i in lst
let visit = (from k in km.LibraryClassVisits
join s in km.SubjectsInSemesters on k.SubjectId equals s.Id
join t in km.Teachers on k.TeacherId equals t.IdentityNumber
where k.Period == i && k.Date == date &&
k.SchoolId == schoolid &&
k.SemesterId == semesterId
select new
{
k.Date,
k.Id,
k.IsDone,
k.Period,
subjectName = (from sub in km.Subjects where sub.Id == s.SubjectId select sub.Name).FirstOrDefault(),
classId = s.ClassId,
teacherName = t.Name
}).FirstOrDefault()
select new
{
isNull = (visit == null),
date,
Id = (visit == null) ? 0 : visit.Id,
IsDone = (visit == null) ? false : visit.IsDone,
Period = i,
subjectName = (visit == null) ? "" : visit.subjectName,
classId = (visit == null) ? "" : visit.classId,
teacherName = (visit == null) ? "" : visit.teacherName
}).ToList();
lstSubjects.DataSource = lst2;
lstSubjects.DataBind();
lstClass.DataSource = lst2;
lstClass.DataBind();
lstTeacher.DataSource = lst2;
lstTeacher.DataBind();
}
}
public void FillStudentName()
{
SchoolInformation schInfo = new SchoolInformation();
var schoolid = schInfo.getId();
var EmpName = (from k in OS.Students where k.SchoolId == schoolid orderby k.Name select k).ToList();
lstStuName.DataSource = EmpName;
lstStuName.DataValueField = "IdentityNumber";
lstStuName.DataTextField = "Name";
lstStuName.DataBind();
}
public void CouncileName()
{
int CouncileID = int.Parse(Request.QueryString["CouncileID"]);
var schoolid = new SchoolInformation().getId();
var CouncileName = (from pd in km.Counciles
where pd.Id == CouncileID
select pd).FirstOrDefault();
lblname.Text = CouncileName.Name;
}