public ClassroomModel LoadDataClassroom(int idClassroom) { appClassroom = new ClassroomApplication(); ClassroomModel classroomModel = new ClassroomModel(); classroomModel.listClassroomStudent = new List <ClassroomStudent>(); classroomModel.listTeachingPlan = new List <TeachingPlan>(); try { foreach (DataRow linha in appClassroom.QuerieClassroom(idClassroom).Rows) { if (!linha["idClassroom"].ToString().Equals("")) { classroomModel.idClassroom = Convert.ToInt32(linha["idClassroom"]); classroomModel.nameClassroom = Convert.ToString(linha["nameClassroom"]); classroomModel.shiftClassroom = Convert.ToString(linha["shiftClassroom"]); } else if (!linha["idStudent"].ToString().Equals("")) { ClassroomStudent classroomStudent = new ClassroomStudent(); classroomStudent.Student = new Student(); classroomStudent.idStudent = Convert.ToInt32(linha["idStudent"]); classroomStudent.Student.registrationNumber = Convert.ToString(linha["registrationNumber"]); classroomStudent.Student.nameStudent = Convert.ToString(linha["nameStudent"]); classroomModel.listClassroomStudent.Add(classroomStudent); } else if (!linha["idTeachingPlan"].ToString().Equals("")) { TeachingPlan teachingPlan = new TeachingPlan(); teachingPlan.idTeachingPlan = Convert.ToInt32(linha["idTeachingPlan"]); teachingPlan.activityDescription = Convert.ToString(linha["activityDescription"]); classroomModel.listTeachingPlan.Add(teachingPlan); } } return(classroomModel); } catch (Exception) { throw; } }
public setTeachISP4 GetTeachISPPage4(Int64 StudentISP) { setTeachISP4 returnValue = new setTeachISP4(); DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = " select a.PlanWriter3,a.PlanWriteFrameDate3,a.PlanWriteExecutor3,a.PlanRevise3,a.PlanReviseDate3,a.PlanReviseExecutor3" + " ,a.HearingAssessment,a.HearingAssessmentByT,a.HearingAssessmentDateT,a.HearingAssessmentTool" + " ,a.VocabularyAssessment,a.VocabularyAssessmentBy,a.VocabularyAssessmentDate,a.VocabularyAssessmentTool" + " ,a.LanguageAssessment,a.LanguageAssessmentBy,a.LanguageAssessmentDate,a.LanguageAssessmentTool" + " ,a.intelligenceAssessment,a.intelligenceAssessmentBy,a.intelligenceAssessmentDate,a.intelligenceAssessmentTool" + " ,a.OtherAssessment,a.OtherAssessmentBy,a.OtherAssessmentDate,a.OtherAssessmentTool" + " ,a.Hearing,a.CognitiveAbility,a.ConnectAbility,a.ActAbility,a.Relationship,a.EmotionalManagement" + " ,a.SensoryFunction,a.HealthState,a.DailyLiving,a.LearningAchievement,a.Advantage,a.WeakCapacity" + " ,b.TeachOrder,b.MasterOrder,b.TargetLong " + " ,c.DetailOrder,c.TargetShort,c.DateStart,c.DateEnd,c.EffectiveDate,c.EffectiveMode,c.EffectiveResult,c.Decide "+ " ,PlanRevise3Name,PlanWriter3Name ,HearingAssessmentByName,VocabularyAssessmentByName,LanguageAssessmentByName,intelligenceAssessmentByName,OtherAssessmentByName" + " from CaseISPstate a " + " Left join TeachingPlan b on a.id = b.ISPID " + " Left join TeachingPlanDetail c on c.TPMID = b.id " + " left join ( select staffid as did , StaffName as PlanRevise3Name from staffDatabase ) d on a.PlanRevise3 = d.did " + " left join ( select staffid as eid , StaffName as PlanWriter3Name from staffDatabase ) e on a.PlanWriter3 = e.eid " + " left join ( select staffid as did , StaffName as HearingAssessmentByName from staffDatabase ) f on a.HearingAssessmentByT = f.did " + " left join ( select staffid as eid , StaffName as VocabularyAssessmentByName from staffDatabase ) g on a.VocabularyAssessmentBy = g.eid " + " left join ( select staffid as did , StaffName as LanguageAssessmentByName from staffDatabase ) h on a.LanguageAssessmentBy = h.did " + " left join ( select staffid as eid , StaffName as intelligenceAssessmentByName from staffDatabase ) i on a.intelligenceAssessmentBy = i.eid " + " left join ( select staffid as did , StaffName as OtherAssessmentByName from staffDatabase ) j on a.OtherAssessmentBy = j.did " + " where a.id =@ISPID "; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ISPID", SqlDbType.BigInt).Value = StudentISP; SqlDataReader dr = cmd.ExecuteReader(); string TO = ""; string MO = ""; TeachingPlan addValue = new TeachingPlan(); addValue.TeachingPlanDetail = new List<TeachingPlanDetail>(); returnValue.TeachingPlan = new List<TeachingPlan>(); while (dr.Read()) { if (returnValue.PlanWriter3 == "" || returnValue.PlanWriter3 == null) { returnValue.HearingAssessmentByName = dr["HearingAssessmentByName"].ToString(); returnValue.VocabularyAssessmentByName = dr["VocabularyAssessmentByName"].ToString(); returnValue.LanguageAssessmentByName = dr["LanguageAssessmentByName"].ToString(); returnValue.intelligenceAssessmentByName = dr["intelligenceAssessmentByName"].ToString(); returnValue.OtherAssessmentByName = dr["OtherAssessmentByName"].ToString(); returnValue.PlanWriter3 = dr["PlanWriter3"].ToString(); returnValue.PlanRevise3Name = dr["PlanRevise3Name"].ToString(); returnValue.PlanWriter3Name = dr["PlanWriter3Name"].ToString(); returnValue.PlanWriteFrameDate3 = DateTime.Parse(dr["PlanWriteFrameDate3"].ToString()).ToString("yyyy-MM-dd"); returnValue.PlanWriteExecutor3 = dr["PlanWriteExecutor3"].ToString(); returnValue.PlanRevise3 = dr["PlanRevise3"].ToString(); returnValue.PlanReviseDate3 = DateTime.Parse(dr["PlanReviseDate3"].ToString()).ToString("yyyy-MM-dd"); returnValue.PlanReviseExecutor3 = dr["PlanReviseExecutor3"].ToString(); returnValue.HearingAssessment = dr["HearingAssessment"].ToString(); returnValue.HearingAssessmentBy = dr["HearingAssessmentByT"].ToString(); returnValue.HearingAssessmentDate = DateTime.Parse(dr["HearingAssessmentDateT"].ToString()).ToString("yyyy-MM-dd"); returnValue.HearingAssessmentTool = dr["HearingAssessmentTool"].ToString(); returnValue.VocabularyAssessment = dr["VocabularyAssessment"].ToString(); returnValue.VocabularyAssessmentBy = dr["VocabularyAssessmentBy"].ToString(); returnValue.VocabularyAssessmentDate = DateTime.Parse(dr["VocabularyAssessmentDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.VocabularyAssessmentTool = dr["VocabularyAssessmentTool"].ToString(); returnValue.LanguageAssessment = dr["LanguageAssessment"].ToString(); returnValue.LanguageAssessmentBy = dr["LanguageAssessmentBy"].ToString(); returnValue.LanguageAssessmentDate = DateTime.Parse(dr["LanguageAssessmentDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.LanguageAssessmentTool = dr["LanguageAssessmentTool"].ToString(); returnValue.intelligenceAssessment = dr["intelligenceAssessment"].ToString(); returnValue.intelligenceAssessmentBy = dr["intelligenceAssessmentBy"].ToString(); returnValue.intelligenceAssessmentDate = DateTime.Parse(dr["intelligenceAssessmentDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.intelligenceAssessmentTool = dr["intelligenceAssessmentTool"].ToString(); returnValue.OtherAssessment = dr["OtherAssessment"].ToString(); returnValue.OtherAssessmentBy = dr["OtherAssessmentBy"].ToString(); returnValue.OtherAssessmentDate = DateTime.Parse(dr["OtherAssessmentDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.OtherAssessmentTool = dr["OtherAssessmentTool"].ToString(); returnValue.Hearing = dr["Hearing"].ToString(); returnValue.CognitiveAbility = dr["CognitiveAbility"].ToString(); returnValue.ConnectAbility = dr["ConnectAbility"].ToString(); returnValue.ActAbility = dr["ActAbility"].ToString(); returnValue.Relationship = dr["Relationship"].ToString(); returnValue.EmotionalManagement = dr["EmotionalManagement"].ToString(); returnValue.SensoryFunction = dr["SensoryFunction"].ToString(); returnValue.HealthState = dr["HealthState"].ToString(); returnValue.DailyLiving = dr["DailyLiving"].ToString(); returnValue.LearningAchievement = dr["LearningAchievement"].ToString(); returnValue.Advantage = dr["Advantage"].ToString(); returnValue.WeakCapacity = dr["WeakCapacity"].ToString(); } TeachingPlanDetail addDetailValue = new TeachingPlanDetail(); if ((TO != dr["TeachOrder"].ToString() || MO != dr["MasterOrder"].ToString()) && !String.IsNullOrEmpty(addValue.MasterOrder)) { returnValue.TeachingPlan.Add(addValue); addValue = new TeachingPlan(); addValue.TeachingPlanDetail = new List<TeachingPlanDetail>(); addDetailValue = new TeachingPlanDetail(); addValue.MasterOrder = dr["MasterOrder"].ToString(); addValue.TeachOrder = dr["TeachOrder"].ToString(); addValue.TargetLong = dr["TargetLong"].ToString(); //addDetailValue.DetailOrder = dr["DetailOrder"].ToString(); addDetailValue.DetailOrder = dr["DetailOrder"].ToString(); addDetailValue.TargetShort = dr["TargetShort"].ToString(); addDetailValue.DateStart = DateTime.Parse(dr["DateStart"].ToString()).ToString("yyyy-MM-dd"); addDetailValue.DateEnd = DateTime.Parse(dr["DateEnd"].ToString()).ToString("yyyy-MM-dd"); addDetailValue.EffectiveDate = DateTime.Parse(dr["EffectiveDate"].ToString()).ToString("yyyy-MM-dd"); addDetailValue.EffectiveMode = dr["EffectiveMode"].ToString(); addDetailValue.EffectiveResult = dr["EffectiveResult"].ToString(); addDetailValue.Decide = dr["Decide"].ToString(); addValue.TeachingPlanDetail.Add(addDetailValue); TO = dr["TeachOrder"].ToString(); MO = dr["MasterOrder"].ToString(); } else { addDetailValue = new TeachingPlanDetail(); if (String.IsNullOrEmpty( addValue.MasterOrder)) { addValue.MasterOrder = dr["MasterOrder"].ToString(); addValue.TeachOrder = dr["TeachOrder"].ToString(); addValue.TargetLong = dr["TargetLong"].ToString(); } addDetailValue.DetailOrder = dr["DetailOrder"].ToString(); addDetailValue.TargetShort = dr["TargetShort"].ToString(); addDetailValue.DateStart = DateTime.Parse(dr["DateStart"].ToString()).ToString("yyyy-MM-dd"); addDetailValue.DateEnd = DateTime.Parse(dr["DateEnd"].ToString()).ToString("yyyy-MM-dd"); addDetailValue.EffectiveDate = DateTime.Parse(dr["EffectiveDate"].ToString()).ToString("yyyy-MM-dd"); addDetailValue.EffectiveMode = dr["EffectiveMode"].ToString(); addDetailValue.EffectiveResult = dr["EffectiveResult"].ToString(); addDetailValue.Decide = dr["Decide"].ToString(); addValue.TeachingPlanDetail.Add(addDetailValue); TO = dr["TeachOrder"].ToString(); MO = dr["MasterOrder"].ToString(); } } returnValue.TeachingPlan.Add(addValue); dr.Close(); Sqlconn.Close(); } catch (Exception e) { string ex = e.Message.ToString(); //returnValue.ISP1Data = new setTeachISP1(); //returnValue.ISP1Data.studentID = "-1"; //returnValue.ISP1Data.studentName = e.Message.ToString(); } } return returnValue; }