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);
}
