public static void addPlan(CPlanEntity planData) { dbContext = new StudentPlanManagementData.StudentPlanManagementContext(); planData.Student = dbContext.StudentEntities.SingleOrDefault(s => s.StudentId == planData.Student.StudentId); //TODO tai sao loi da them o truoc ma dbContext.PlanEnties.Add(planData); dbContext.SaveChanges(); }
public static void addMarkNew(CMarksEntity mark, string strStudentId, string strSemesterId, string strSubjectId) { dbContext = new StudentPlanManagementData.StudentPlanManagementContext(); mark.Take = dbContext.SubjectsTakesEntities.SingleOrDefault(t => t.StudentId == strStudentId && t.SemesterId == strSemesterId && t.SubjectId == strSubjectId); dbContext.MarkEnties.Add(mark); dbContext.SaveChanges(); }
public static List <CPlanEntity> loadPlanNowToLastMont(string strStudentId) { DateTime dtNow = DateTime.Now; dtNow.AddDays(-2); dbContext = new StudentPlanManagementData.StudentPlanManagementContext(); List <CPlanEntity> lists = new List <CPlanEntity>(); lists = dbContext.PlanEnties.Where(p => p.Student.StudentId.Equals(strStudentId) && p.DayofRemind > dtNow).ToList(); return(lists); }
public static string getPlanIdNew() { dbContext = new StudentPlanManagementData.StudentPlanManagementContext(); if (dbContext.PlanEnties.Count() == 0) { return("P0"); } int maxLengthPlanId = dbContext.PlanEnties.Max(p => p.PlandId.Length); var lastPlan = dbContext.PlanEnties.Where(p => p.PlandId.Length == maxLengthPlanId).Max(p => p.PlandId.Substring(1)); string strPlanIdNeew = "P" + (int.Parse(lastPlan) + 1); return(strPlanIdNeew); }