protected void btnCreateClass_Click(object sender, EventArgs e)
{
try
{
tblClass clas = new tblClass();
clas.Name = txtClassName.Value;
clas.Id = new Locdau().LocDauChuoi(txtClassName.Value).ToUpper();
clas.Status = cbkActive.Checked ? true : false;
if (fleUpload.HasFile)
{
string img = SaveAvata(fleUpload.PostedFile) ? "/Content/Image_Class/" + fleUpload.PostedFile.FileName : "";
if (!img.Equals(""))
{
clas.Avata = img;
}
}
bool check = new ClassDB().InsertDB(clas);
if (check)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Thêm mới thông tin thành công')", true);
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Thêm mới thông tin thất bại')", true);
}
}
catch (Exception)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Chỉnh Sửa thông tin thất bại')", true);
}
}
//public ActionResult Index()
//{
// var student = Connection.SMGTGetStudent();
// List<SMGTGetStudent_Result> Categorylist = student.ToList();
// StudentModel schl = new StudentModel();
// List<StudentModel> tcmlist = Categorylist.Select(x => new StudentModel
// {
// SchoolId = x.SchoolId,
// SchoolName = x.SchoolName,
// DateOfBirth = x.DateofBirth,
// CreatedDate = x.CreatedDate,
// StudentId = x.StudentId,
// StudentName = x.studentName,
// IsActive = x.IsActive,
// ModifiedBy = x.ModifiedBy,
// ModifiedDate = x.ModifiedDate
// }).ToList();
// return View(tcmlist);
//}
//
// GET: /Student/Details/5
public ActionResult Details(string StudentId, string SchoolId)
{
Authentication("STCF");
StudentModel TModel = new StudentModel();
tblStudent TCtable = Connection.tblStudents.SingleOrDefault(x => x.StudentId == StudentId && x.SchoolId == SchoolId);
// TModel.IsActive = TCtable.IsActive;
TModel.StudentId = TCtable.StudentId;
TModel.StudentName = TCtable.studentName;
TModel.DateOfBirth = TCtable.DateofBirth;
TModel.ClassId = TCtable.ClassId;
TModel.Gender = TCtable.Gender;
TModel.Gender = TCtable.Gender;
TModel.ImagePathname = TCtable.ImgUrl;
TModel.GradeId = TCtable.GradeId;
TModel.HouseId = TCtable.HouseId;
tblClass sclrank = Connection.tblClasses.SingleOrDefault(x => x.ClassId == TModel.ClassId && x.GradeId == TModel.GradeId && x.SchoolId == SchoolId);
TModel.ClassId = sclrank.ClassName;
tblGrade sclgrade = Connection.tblGrades.SingleOrDefault(x => x.GradeId == TModel.GradeId);
TModel.GradeId = sclgrade.GradeName;
tblHouse sclhouse = Connection.tblHouses.SingleOrDefault(x => x.SchoolId == SchoolId && x.HouseId == TModel.HouseId);
TModel.HouseId = sclhouse.HouseName;
return(View("Detail", TModel));
}
protected void btnEditClass_Click(object sender, EventArgs e)
{
try
{
tblClass clas = new tblClass();
clas.Id = selectRole.SelectedValue.ToString();
clas.Name = txtClassName.Value;
clas.Status = cbkActive.Checked ? true : false;
if (fleUpload.HasFile)
{
string img = SaveAvata(fleUpload.PostedFile) ? "~/Content/Image_Class/" + fleUpload.PostedFile.FileName : "";
if (!string.IsNullOrEmpty(img))
{
clas.Avata = img;
}
}
bool check = new ClassDB().UpdateClass(clas);
if (check)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Chỉnh Sửa thông tin thành công')", true);
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Chỉnh Sửa thông tin thất bại')", true);
}
}
catch (Exception)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Chỉnh Sửa thông tin thất bại')", true);
}
}
// GET: /ClassStudentTeacher/Edit/5
public ActionResult Edit(int?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblClass tblclass = db.tblClasses.Find(id);
if (tblclass == null)
{
return(HttpNotFound());
}
ViewBag.SchoolId = new SelectList(db.tblSchools, "SchoolId", "SchoolDesc", tblclass.SchoolId);
ViewBag.SchoolYearId = new SelectList(db.tblSchoolYears, "SchoolYearId", "SchoolYearDesc", tblclass.SchoolYearId);
ViewBag.SubjectId = new SelectList(db.tblSubjects, "SubjectId", "SubjectDesc", tblclass.SubjectId);
return(View(tblclass));
}
catch (Exception ex)
{
Logging log = new Logging();
log.LogException(ex);
return(View("GeneralError"));
}
}
public async Task <IActionResult> Edit(int id, [Bind("ClassId,Name")] tblClass tblClass)
{
if (id != tblClass.ClassId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tblClass);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tblClassExists(tblClass.ClassId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tblClass));
}
public ActionResult Details(long code, string dates)
{
try
{
SchoolId = USession.School_Id;
DropDownList("%");
HomeWorkModel TModel = new HomeWorkModel();
tblAssignmentHeader TCtable = Connection.tblAssignmentHeaders.SingleOrDefault(x => x.AssignmentNo == code);
TModel.SubjectId = TCtable.SubjectId;
TModel.GradeId = TCtable.GradeId;
TModel.ClassId = TCtable.ClassId;
tblClass TClass = Connection.tblClasses.SingleOrDefault(x => x.ClassId == TCtable.ClassId && x.GradeId == TCtable.GradeId && x.SchoolId == SchoolId);
TModel.Class = TClass.ClassName;
tblGrade TGrade = Connection.tblGrades.SingleOrDefault(x => x.GradeId == TCtable.GradeId);
TModel.Grade = TGrade.GradeName;
tblSubject TSubject = Connection.tblSubjects.SingleOrDefault(x => x.SubjectId == TCtable.SubjectId);
TModel.Subject = TSubject.SubjectName;
TModel.stringDueDate = dates;
TModel.AssignmentDescription = TCtable.AssignmentDescription;
TModel.BatchNo = TCtable.BatchNo;
TModel.BatchDescription = TCtable.BatchDescription;
TModel.FilePath = TCtable.FilePath;
TModel.AssignmentNo = TCtable.AssignmentNo;
return(PartialView("DetailView", TModel));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult Details(string StudentId, string SchoolId)
{
StudentModel TModel = new StudentModel();
tblStudent TCtable = Connection.tblStudents.SingleOrDefault(x => x.StudentId == StudentId && x.SchoolId == SchoolId);
// TModel.IsActive = TCtable.IsActive;
TModel.SchoolId = SchoolId;
TModel.StudentId = TCtable.StudentId;
TModel.StudentName = TCtable.studentName;
TModel.DateOfBirth = TCtable.DateofBirth;
if (TCtable.DateofBirth == null)
{
}
else
{
string a = TCtable.DateofBirth.ToString();
DateTime b = DateTime.Parse(a);
TModel.datetimestring = b.ToShortDateString();
}
TModel.ClassId = TCtable.ClassId;
TModel.Gender = TCtable.Gender;
TModel.Gender = TCtable.Gender;
TModel.ImagePathname = TCtable.ImgUrl;
TModel.GradeId = TCtable.GradeId;
TModel.HouseId = TCtable.HouseId;
if (TCtable.ImgUrl == null || TCtable.ImgUrl == "")
{
TModel.ImagePathname = "~/Uploads/Student/Photo/no_image.jpg";
}
else
{
TModel.ImagePathname = TCtable.ImgUrl;
}
tblClass sclrank = Connection.tblClasses.SingleOrDefault(x => x.ClassId == TModel.ClassId && x.GradeId == TModel.GradeId && x.SchoolId == SchoolId);
TModel.ClassId = sclrank.ClassName;
tblGrade sclgrade = Connection.tblGrades.SingleOrDefault(x => x.GradeId == TModel.GradeId);
TModel.GradeId = sclgrade.GradeName;
if (TModel.HouseId == null)
{
}
else
{
tblHouse sclhouse = Connection.tblHouses.SingleOrDefault(x => x.SchoolId == SchoolId && x.HouseId == TModel.HouseId);
TModel.HouseId = sclhouse.HouseName;
}
return(View("Detail", TModel));
}
public ActionResult Edit([Bind(Include = "ClassID,ClassName")] tblClass tblClass)
{
if (ModelState.IsValid)
{
db.Entry(tblClass).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblClass));
}
public ActionResult DeleteConfirmed(int id)
{
tblClass tblClass = db.tblClasses.Find(id);
db.tblClasses.Remove(tblClass);
tblClass.ClassActive = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Create([Bind("ClassId,Name")] tblClass tblClass)
{
if (ModelState.IsValid)
{
_context.Add(tblClass);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblClass));
}
public bool IsEditClassExists(tblClass editClass)
{
int userAssignedDistrict = _siteUser.Districts[0].Id;
var count = (from x in _db.tblClasses
join y in _db.tblSchools on x.SchoolId equals y.SchoolId
where x.SchoolYearId == editClass.SchoolYearId && x.ClassDesc == editClass.ClassDesc &&
x.ClassId != editClass.ClassId && y.DistrictId == userAssignedDistrict
select x).Count();
return(count > 0 ? true : false);
}
public bool InsertDB(tblClass obj)
{
try
{
dbcontext.tblClasses.InsertOnSubmit(obj);
dbcontext.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public List <tblClass> LoadClass()
{
List <tblClass> drpList = new List <tblClass>();
tblClass item = new tblClass();
item.ClassId = 0;
item.className = "Select";
drpList = dbcontext.tblClasses.ToList();
drpList.Insert(0, item);
return(drpList);
}
public ActionResult Create([Bind(Include = "ClassID,ClassName")] tblClass tblClass)
{
if (ModelState.IsValid)
{
tblClass.ClassActive = true;
tblClass.ReportingDatetime = DateTime.Now;
db.tblClasses.Add(tblClass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblClass));
}
// GET: Classes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblClass tblClass = db.tblClasses.Find(id);
if (tblClass == null)
{
return(HttpNotFound());
}
return(View(tblClass));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
tblClass tblclass = db.tblClasses.Find(id);
db.tblClasses.Remove(tblclass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
Logging log = new Logging();
log.LogException(ex);
return(View("GeneralError"));
}
}
public ActionResult Detail(string GradeId, string ClassId, string AcedamicYear)
{
try
{
SchoolId = USession.School_Id;
tblAccadamicYear Ttable = Connection.tblAccadamicYears.SingleOrDefault(x => x.SchoolId == SchoolId);
Dropdownlistdata(SchoolId);
if (GradeId == null)
{
return(RedirectToAction("Index"));
}
ViewBag.CurentYear = AcedamicYear;
tblGrade TCtable = Connection.tblGrades.SingleOrDefault(x => x.GradeId == GradeId);
ViewBag.CurentGrade = TCtable.GradeName;
tblClass classtable = Connection.tblClasses.SingleOrDefault(x => x.ClassId == ClassId && x.GradeId == GradeId && x.SchoolId == SchoolId);
ViewBag.CurentClass = classtable.ClassName;
ViewBag.ParameterAcedamicYear = Ttable.AccadamicYear;
if (Ttable.AccadamicYear != AcedamicYear)
{
ViewBag.ErrorMsg = false;
}
else
{
ViewBag.ErrorMsg = true;
}
List <StudentGradeAdvanceModel> tcmlist = getdataForTable(AcedamicYear, GradeId, ClassId);
if (tcmlist.Count == 0)
{
return(RedirectToAction("Index"));
}
return(View(tcmlist));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
private void LoadClass()
{
List <tblClass> drpList = new List <tblClass>();
tblClass item = new tblClass();
item.ClassId = 0;
item.className = "Select";
drpList = dbcontext.tblClasses.ToList();
drpList.Insert(0, item);
drpClass.DataValueField = "ClassId";
drpClass.DataTextField = "className";
drpClass.DataSource = drpList;
drpClass.DataBind();
}
protected void Button_Click_Add_Class(object sender, EventArgs e)
{
tblClass item = new tblClass();
item.className = txtClassName.Text;
dbcontext.tblClasses.AddObject(item);
dbcontext.SaveChanges();
grdClass.DataSource = dbcontext.tblClasses;
grdClass.DataBind();
string script = "alert('Class Saved');";
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true);
}
/// <summary>
/// GetStudentNotForThisClass method get all student for all classes except a class.
/// </summary>
/// <param name="classId"></param>
/// <param name="userAssignedDistrict"></param>
/// <param name="schoolYearId"></param>
/// <returns></returns>
public IQueryable <StudentDetail> GetStudentNotForThisClass(tblClass tblClass, int districtId)
{
var studentsForThisClass = GetStudentDetail(tblClass.ClassId);
var query = _db.tblStudents.Join(_db.tblStudentSchoolYears, s => s.StudentId, rc => rc.StudentId, (s, rc) => new { s, rc })
.Where(x => x.s.DistrictId == districtId && x.rc.SchoolYearId == tblClass.SchoolYearId)
.Select(x => new StudentDetail()
{
StudentId = x.s.StudentId,
FullName = (x.s.LastName ?? string.Empty) + ", " + (x.s.FirstName ?? string.Empty) + " " + (x.s.MiddleName ?? string.Empty)
,
LastName = x.s.LastName,
FirstName = x.s.FirstName,
MiddleName = x.s.MiddleName
})
.Except(studentsForThisClass)
.OrderBy(x => x.LastName).ThenBy(x => x.FirstName).ThenBy(x => x.MiddleName);
return(query);
}
/// <summary>
/// GetTeachersForThisClass method get all teachers except a class
/// </summary>
/// <param name="classId"></param>
/// <returns></returns>
public IQueryable <TeacherDetail> GetTeachersNotForThisClass(tblClass tblClass, bool filterTeachersByDistrict, int districtId)
{
var teachersForThisClass = GetTeacherDetail(tblClass.ClassId);
var query = _db.tblUsers
.Join(_db.tblUserSchools, u => u.UserId, us => us.UserId, (u, us) => new { u, us })
.Join(_db.tblSchools, uus => uus.us.SchoolId, s => s.SchoolId, (uus, s) => new { uus, s })
.Join(_db.tblSchoolYears, uussy => uussy.uus.us.SchoolYearId, sy => sy.SchoolYearId, (uussy, sy) => new { uussy, sy })
.Join(_db.tblUserDistricts, uussyud => uussyud.uussy.uus.u.UserId, ud => ud.UserId, (uussuud, ud) => new { uussuud, ud })
.Where(x => x.ud.DistrictId == districtId &&
(filterTeachersByDistrict || x.uussuud.uussy.s.SchoolId == tblClass.SchoolId) && x.uussuud.sy.SchoolYearId == tblClass.SchoolYearId)
.Select(x => new TeacherDetail()
{
TeacherId = x.uussuud.uussy.uus.u.UserId, FullName = x.uussuud.uussy.uus.u.LastName + ", " + x.uussuud.uussy.uus.u.FirstName, LastName = x.uussuud.uussy.uus.u.LastName
})
.Except(teachersForThisClass)
.Distinct()
.OrderBy(x => x.LastName);
return(query);
}
public ActionResult Edit([Bind(Include = "ClassId,SchoolId,ClassDesc,SchoolYearId,SubjectId,Grade,CreateDatetime,ChangeDatetime")] tblClass tblclass)
{
try
{
if (ModelState.IsValid)
{
db.Entry(tblclass).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SchoolId = new SelectList(db.tblSchools, "SchoolId", "SchoolDesc", tblclass.SchoolId);
ViewBag.SchoolYearId = new SelectList(db.tblSchoolYears, "SchoolYearId", "SchoolYearDesc", tblclass.SchoolYearId);
ViewBag.SubjectId = new SelectList(db.tblSubjects, "SubjectId", "SubjectDesc", tblclass.SubjectId);
return(View(tblclass));
}
catch (Exception ex)
{
Logging log = new Logging();
log.LogException(ex);
return(View("GeneralError"));
}
}
// GET: /ClassStudentTeacher/Details/5
public ActionResult Details(int?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblClass tblclass = db.tblClasses.Find(id);
if (tblclass == null)
{
return(HttpNotFound());
}
return(View(tblclass));
}
catch (Exception ex)
{
Logging log = new Logging();
log.LogException(ex);
return(View("GeneralError"));
}
}
public bool UpdateClass(tblClass obj)
{
bool isOk = false;
try
{
tblClass exist = dbcontext.tblClasses.SingleOrDefault(u => u.Id.Equals(obj.Id));
if (exist != null)
{
exist.Name = obj.Name;
exist.Status = obj.Status;
exist.Avata = obj.Avata;
dbcontext.SubmitChanges();
isOk = true;
}
return(isOk);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Edit(long Code, string dates)
{
try
{
SchoolId = USession.School_Id;
HomeWorkModel TModel = new HomeWorkModel();
tblAssignmentHeader TCtable = Connection.tblAssignmentHeaders.SingleOrDefault(x => x.AssignmentNo == Code);
TModel.SubjectId = TCtable.SubjectId;
TModel.GradeId = TCtable.GradeId;
TModel.ClassId = TCtable.ClassId;
tblClass TClass = Connection.tblClasses.SingleOrDefault(x => x.ClassId == TCtable.ClassId && x.GradeId == TCtable.GradeId && x.SchoolId == SchoolId);
TModel.Class = TClass.ClassName;
tblGrade TGrade = Connection.tblGrades.SingleOrDefault(x => x.GradeId == TCtable.GradeId);
TModel.Grade = TGrade.GradeName;
tblSubject TSubject = Connection.tblSubjects.SingleOrDefault(x => x.SubjectId == TCtable.SubjectId);
TModel.Subject = TSubject.SubjectName;
TModel.stringDueDate = dates;
TModel.AssignmentDescription = TCtable.AssignmentDescription;
TModel.BatchNo = TCtable.BatchNo;
TModel.BatchDescription = TCtable.BatchDescription;
TModel.FilePath = TCtable.FilePath;
TModel.AssignmentNo = TCtable.AssignmentNo;
DropDownList(TCtable.GradeId);
var Subject = Connection.GDgetGradeActiveSubject(SchoolId, TCtable.GradeId, "Y");;
List <GDgetGradeActiveSubject_Result> Subjectlist = Subject.ToList();
ViewBag.SubjectId = new SelectList(Subjectlist, "SubjectId", "SubjectName");
ViewBag.SubjectIdtxt = TCtable.SubjectId;
return(PartialView("EditView", TModel));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public void AddClass(tblClass newClass)
{
newClass.CreateDatetime = DateTime.Now;
_db.tblClasses.Add(newClass);
_db.SaveChanges();
}
public void InsertClass()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var classTypeID = int.Parse(ddlClassType.SelectedValue);
int ihdnPKID = int.Parse(hdnPKId.Value);
Int32 ClassID = 0;
if (ihdnPKID == 0)
{
ClassID = (from obj in entities.tblClasses
where obj.CLASS_LEVEL_ID == classTypeID && obj.CLASS_DAY == txtDay.Text && obj.CLASS_TIME == txtTime.Text
select obj.CLASS_ID).FirstOrDefault();
}
else
{
ClassID = (from obj in entities.tblClasses
where obj.CLASS_LEVEL_ID == classTypeID && obj.CLASS_DAY == txtDay.Text && obj.CLASS_TIME == txtTime.Text && obj.CLASS_ID != ihdnPKID
select obj.CLASS_ID).FirstOrDefault();
}
if (ClassID == 0)
{
var objClass = entities.tblClasses.Where(s => s.CLASS_ID == ihdnPKID).OrderByDescending(s => s.CLASS_ID).FirstOrDefault();
if (objClass == null)
{
objClass = new tblClass();
}
objClass.CLASS_LEVEL_ID = Convert.ToInt32(ddlClassType.SelectedValue);
objClass.CLASS_DAY = txtDay.Text;
objClass.CLASS_TIME = txtTime.Text;
objClass.CLASS_CREATED_BY = entities.tblInstructors.AsEnumerable().FirstOrDefault().INSTRUCTOR_ID;
objClass.CLASS_CREATED_DATE = DateTime.Now;
objClass.CLASS_STATUS = chkIsApprove.Checked;
if (objClass.CLASS_ID == 0)
{
entities.tblClasses.Add(objClass);
}
else
{
objClass.CLASS_MODIFY_BY = entities.tblInstructors.Select(x => x.INSTRUCTOR_ID).FirstOrDefault();
objClass.CLASS_MODIFIED_DATE = DateTime.Now;
entities.Entry(objClass).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
objClass = null;
if (hdnPKId.Value != "0")
{
Response.Redirect("ClassList.aspx");
}
ResetControls();
divMessage.Visible = true;
divErrorMsg.Visible = false;
}
else
{
divErrorMsg.Visible = true;
divMessage.Visible = false;
return;
}
}
}
catch (Exception ex)
{
}
}
internal void EditClass(tblClass editClass)
{
editClass.ChangeDatetime = DateTime.Now;
_db.Entry(editClass).State = EntityState.Modified;
_db.SaveChanges();
}
public Response SaveClassMasterDetails(ClassMasterCustomModel objModel)
{
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
if (objModel.ClassId == 0)
{
var rs = dbcontext.tblClasses.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.Title == objModel.Title);
if (rs == null)
{
tblClass objAddNew = new tblClass
{
SchoolId = Convert.ToInt32(CommonHelper.TaskSchoolId.SchoolId),
SessionId = objModel.SessionId,
Title = objModel.Title,
ShortDescription = objModel.ShortDescription,
DDate = objModel.DDate,
IsActive = true,
IsDeleted = false,
CreatedBy = objModel.CreatedBy,
CreatedDate = DateTime.Now,
ModifiedBy = objModel.ModifiedBy,
ModifiedDate = DateTime.Now
};
dbcontext.tblClasses.Add(objAddNew);
dbcontext.SaveChanges();
response.responseData = new { ClassId = objAddNew.ClassId, Title = objAddNew.Title };
response.message = "Record Added Successfully!";
}
else
{
response.success = false;
response.message = "Record Already Exists!";
}
}
else
{
var rs = dbcontext.tblClasses.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.Title == objModel.Title && x.ClassId != objModel.ClassId);
if (rs == null)
{
var objUpdate = dbcontext.tblClasses.FirstOrDefault(m => m.ClassId == objModel.ClassId);
if (objUpdate != null)
{
objUpdate.SessionId = objModel.SessionId;
objUpdate.Title = objModel.Title;
objUpdate.ShortDescription = objModel.ShortDescription;
objUpdate.DDate = objModel.DDate;
objUpdate.ModifiedBy = objModel.ModifiedBy;
objUpdate.ModifiedDate = DateTime.Now;
dbcontext.SaveChanges();
response.responseData = new { ClassId = objUpdate.ClassId, Title = objUpdate.Title };
response.message = "Record Updated Successfully!";
}
}
else
{
response.success = false;
response.message = "Record Already Exists!";
}
}
return(response);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
/// <summary>
/// GetStudentForThisClass method get all student for a class.
/// </summary>
/// <param name="classId"></param>
/// <returns></returns>
public IQueryable<StudentDetail> GetStudentForThisClass(tblClass tblClass)
{
var query = GetStudentDetail(tblClass.ClassId);
return query.OrderBy(x => x.LastName).ThenBy(x => x.FirstName).ThenBy(x => x.MiddleName);
}
/// <summary>
/// GetTeachersForThisClass method get the teachers for a class
/// </summary>
/// <param name="classId"></param>
/// <returns></returns>
public IQueryable<TeacherDetail> GetTeachersForThisClass(tblClass tblClass)
{
var query = GetTeacherDetail(tblClass.ClassId);
return query.Distinct().OrderBy(x => x.LastName);
}
/// <summary>
/// GetTeachersForThisClass method get all teachers except a class
/// </summary>
/// <param name="classId"></param>
/// <returns></returns>
public IQueryable<TeacherDetail> GetTeachersNotForThisClass(tblClass tblClass, bool filterTeachersByDistrict, int districtId)
{
var teachersForThisClass = GetTeacherDetail(tblClass.ClassId);
var query = _db.tblUsers
.Join(_db.tblUserSchools, u => u.UserId, us => us.UserId, (u, us) => new { u, us })
.Join(_db.tblSchools, uus => uus.us.SchoolId, s => s.SchoolId, (uus, s) => new { uus, s })
.Join(_db.tblSchoolYears, uussy => uussy.uus.us.SchoolYearId, sy => sy.SchoolYearId, (uussy, sy) => new { uussy, sy })
.Join(_db.tblUserDistricts, uussyud => uussyud.uussy.uus.u.UserId, ud => ud.UserId, (uussuud, ud) => new { uussuud, ud })
.Where(x => x.ud.DistrictId == districtId
&& (filterTeachersByDistrict || x.uussuud.uussy.s.SchoolId == tblClass.SchoolId) && x.uussuud.sy.SchoolYearId == tblClass.SchoolYearId)
.Select(x => new TeacherDetail() { TeacherId = x.uussuud.uussy.uus.u.UserId, FullName = x.uussuud.uussy.uus.u.LastName + ", " + x.uussuud.uussy.uus.u.FirstName, LastName = x.uussuud.uussy.uus.u.LastName })
.Except(teachersForThisClass)
.Distinct()
.OrderBy(x => x.LastName);
return query;
}
/// <summary>
/// GetStudentForThisClass method get all student for a class.
/// </summary>
/// <param name="classId"></param>
/// <returns></returns>
public IQueryable <StudentDetail> GetStudentForThisClass(tblClass tblClass)
{
var query = GetStudentDetail(tblClass.ClassId);
return(query.OrderBy(x => x.LastName).ThenBy(x => x.FirstName).ThenBy(x => x.MiddleName));
}
/// <summary>
/// GetTeachersForThisClass method get the teachers for a class
/// </summary>
/// <param name="classId"></param>
/// <returns></returns>
public IQueryable <TeacherDetail> GetTeachersForThisClass(tblClass tblClass)
{
var query = GetTeacherDetail(tblClass.ClassId);
return(query.Distinct().OrderBy(x => x.LastName));
}
public bool IsEditClassExists(tblClass editClass)
{
int userAssignedDistrict = _siteUser.Districts[0].Id;
var count = (from x in _db.tblClasses
join y in _db.tblSchools on x.SchoolId equals y.SchoolId
where x.SchoolYearId == editClass.SchoolYearId && x.ClassDesc == editClass.ClassDesc
&& x.ClassId != editClass.ClassId && y.DistrictId == userAssignedDistrict
select x).Count();
return (count > 0 ? true : false);
}
/// <summary>
/// GetStudentForSchool method get students for a school except a class.
/// </summary>
/// <param name="classId"></param>
/// <param name="schoolId"></param>
/// <param name="userAssignedDistrict"></param>
/// <param name="schoolYearId"></param>
/// <returns></returns>
public IQueryable<StudentDetail> GetStudentForSchool(tblClass tblClass, int districtId)
{
var studentsForThisClass = GetStudentDetail(tblClass.ClassId);
var query = _db.tblStudents
.Join(_db.tblStudentSchoolYears, s => s.StudentId, rc => rc.StudentId, (s, rc) => new { s, rc })
.Where(y => y.s.DistrictId == districtId && y.rc.ServingSchoolId == tblClass.SchoolId && y.rc.SchoolYearId == tblClass.SchoolYearId)
.Select(y => new StudentDetail()
{
StudentId = y.s.StudentId,
FullName = (y.s.LastName ?? string.Empty) + ", " + (y.s.FirstName ?? string.Empty) + " " + (y.s.MiddleName ?? string.Empty)
,
LastName = y.s.LastName,
FirstName = y.s.FirstName,
MiddleName = y.s.MiddleName
})
.Except(studentsForThisClass)
.OrderBy(records => records.LastName).ThenBy(records => records.FirstName).ThenBy(records => records.MiddleName);
return query;
}
internal void EditClass(tblClass editClass)
{
editClass.ChangeDatetime = DateTime.Now;
_db.Entry(editClass).State = EntityState.Modified;
_db.SaveChanges();
}
