// GET: Syll/Details
public ActionResult Details()
{
//var syll = new Models.Syll { Syllabus_ID = 123, Course_ID = 321, User_ID = 222 };
AllSyllView all = new AllSyllView();
List <Syll> butangView = new List <Syll>();
List <Syllab> lsylstore = new List <Syllab>();
List <Syllab> lsyl = new List <Syllab>();
lsyl = db.Syllabs.ToList();
foreach (var sud in lsyl)
{
if (sud.User_ID == this.logID)
{
lsylstore.Add(sud);
}
}
List <CourseOutcome> Co = new List <CourseOutcome>();
Co = db.CourseOutcomes.ToList();
List <PEO> Peo = new List <PEO>();
Peo = db.PEOs.ToList();
List <ProgramOutcome> Po = new List <ProgramOutcome>();
Po = db.ProgramOutcomes.ToList();
List <ClassroomAndLabPolicy> Clp = new List <ClassroomAndLabPolicy>();
Clp = db.ClassroomAndLabPolicies.ToList();
List <CourseDeliverableOutputsAndRequirement> Codor = new List <CourseDeliverableOutputsAndRequirement>();
Codor = db.CourseDeliverableOutputsAndRequirements.ToList();
List <LearningPlan> Lp = new List <LearningPlan>();
Lp = db.LearningPlans.ToList();
List <GradingSystem> Gs = new List <GradingSystem>();
Gs = db.GradingSystems.ToList();
List <CourseOutcome> wCo = new List <CourseOutcome>();
List <PEO> wPeo = new List <PEO>();
List <ProgramOutcome> wPo = new List <ProgramOutcome>();
List <ClassroomAndLabPolicy> wClp = new List <ClassroomAndLabPolicy>();
List <CourseDeliverableOutputsAndRequirement> wCodor = new List <CourseDeliverableOutputsAndRequirement>();
List <LearningPlan> wLp = new List <LearningPlan>();
List <GradingSystem> wGs = new List <GradingSystem>();
foreach (Syllab tanan in lsylstore)
{
Syll kuhaUsa = new Syll();
foreach (var sud in Co)
{
if (sud.Syllabus_ID == tanan.Syllabus_ID)
{
//CourseOutcome Coln = new CourseOutcome();
//kuhaUsa.Lco.Add(sud);
//Coln.Add(sud);
wCo.Add(sud);
}
}
foreach (var sud in Peo)
{
if (sud.Syllabus_ID == tanan.Syllabus_ID)
{
//kuhaUsa.Lpeo.Add(sud);
wPeo.Add(sud);
}
}
foreach (var sud in Po)
{
if (sud.Syllabus_ID == tanan.Syllabus_ID)
{
wPo.Add(sud);
}
}
foreach (var qwe in Clp)
{
if (qwe.Syllabus_ID == tanan.Syllabus_ID)
{
//kuhaUsa.Lclp.Add(qwe);
wClp.Add(qwe);
}
}
foreach (var sud in Lp)
{
if (sud.Syllabus_ID == tanan.Syllabus_ID)
{
//kuhaUsa.Llplan.Add(sud);
wLp.Add(sud);
}
}
foreach (var sud in Codor)
{
if (sud.Syllabus_ID == tanan.Syllabus_ID)
{
wCodor.Add(sud);
}
}
foreach (var sud in Gs)
{
if (sud.Syllabus_ID == tanan.Syllabus_ID)
{
wGs.Add(sud);
}
}
kuhaUsa.Lclp = wClp;
kuhaUsa.Lco = wCo;
kuhaUsa.Lcodor = wCodor;
kuhaUsa.Lgs = wGs;
kuhaUsa.Llplan = wLp;
kuhaUsa.Lpeo = wPeo;
kuhaUsa.Lpo = wPo;
butangView.Add(kuhaUsa);
}
all.oru = butangView;
return(View(butangView));
}
public ActionResult InsertSyll(Syll data)
{
List <Syllab> kita = new List <Syllab>();
Syllab res = new Syllab();
Syllab syllabus = new Syllab();
syllabus.User_ID = logID;
syllabus.Course_ID = 1;
//IList<Syllab> syllablist = new List<Syllab>();
db.Syllabs.Add(syllabus);
kita = db.Syllabs.ToList();
foreach (var sud in kita)
{
if (sud.Course_ID == syllabus.Course_ID)
{
res = sud;
break;
}
}
foreach (PEO p in data.Lpeo)
{
if (p.Peo_CODE != null && p.Peo_CVA != null && p.Peo_DESC != null)
{
PEO peo = new PEO();
peo.Peo_CODE = p.Peo_CODE;
peo.Peo_DESC = p.Peo_DESC;
peo.Peo_CVA = p.Peo_CVA;
peo.Syllabus_ID = res.Syllabus_ID;
db.PEOs.Add(peo);
db.SaveChanges();
}
}
foreach (ClassroomAndLabPolicy p in data.Lclp)
{
if (p.CLP_desc != null)
{
ClassroomAndLabPolicy classroomAndLabPolicies = new ClassroomAndLabPolicy();
classroomAndLabPolicies.CLP_desc = p.CLP_desc;
classroomAndLabPolicies.Syllabus_ID = res.Syllabus_ID;
db.ClassroomAndLabPolicies.Add(classroomAndLabPolicies);
db.SaveChanges();
}
}
foreach (CourseDeliverableOutputsAndRequirement p in data.Lcodor)
{
if (p.OutputReq != null && p.OutputReqDesc != null && p.ToA != null && p.Cilo_Add != null)
{
CourseDeliverableOutputsAndRequirement courseDeliverableOutputsAndRequirements = new CourseDeliverableOutputsAndRequirement();
courseDeliverableOutputsAndRequirements.OutputReq = p.OutputReq;
courseDeliverableOutputsAndRequirements.OutputReqDesc = p.OutputReqDesc;
courseDeliverableOutputsAndRequirements.Cilo_Add = p.Cilo_Add;
courseDeliverableOutputsAndRequirements.ToA = p.ToA;
courseDeliverableOutputsAndRequirements.Syllabus_ID = res.Syllabus_ID;
db.CourseDeliverableOutputsAndRequirements.Add(courseDeliverableOutputsAndRequirements);
db.SaveChanges();
}
}
foreach (CourseOutcome p in data.Lco)
{
if (p.CO_Code != null && p.CO_CVA != null && p.CO_DESC != null && p.CO_DOLLevel != null & p.CO_POactivated != null)
{
CourseOutcome courseOutcomes = new CourseOutcome();
courseOutcomes.CO_Code = p.CO_Code;
courseOutcomes.CO_DESC = p.CO_DESC;
courseOutcomes.CO_CVA = p.CO_CVA;
courseOutcomes.CO_POactivated = p.CO_POactivated;
courseOutcomes.CO_DOLLevel = p.CO_DOLLevel;
courseOutcomes.Syllabus_ID = res.Syllabus_ID;
db.CourseOutcomes.Add(courseOutcomes);
db.SaveChanges();
}
}
foreach (GradingSystem p in data.Lgs)
{
if (p.GRD_outputs != null && p.GRD_type != null && p.GRD_weight != null)
{
GradingSystem gradingSystem = new GradingSystem();
gradingSystem.GRD_outputs = p.GRD_outputs;
gradingSystem.GRD_type = p.GRD_type;
gradingSystem.GRD_weight = p.GRD_weight;
gradingSystem.Syllabus_ID = res.Syllabus_ID;
db.GradingSystems.Add(gradingSystem);
db.SaveChanges();
}
}
foreach (LearningPlan p in data.Llplan)
{
if (p.activityL != null && p.activityT != null & p.LPlan_Asses != null && p.LPlan_No_hours != 0 && p.LPlan_Outcome != null && p.LPlan_Topics != null)
{
LearningPlan learningPlan = new LearningPlan();
learningPlan.LPlan_Outcome = p.LPlan_Outcome;
learningPlan.LPlan_No_hours = p.LPlan_No_hours;
learningPlan.LPlan_Topics = p.LPlan_Topics;
learningPlan.LPlan_Asses = p.LPlan_Asses;
learningPlan.activityL = p.activityL;
learningPlan.activityT = p.activityT;
learningPlan.Syllabus_ID = res.Syllabus_ID;
db.LearningPlans.Add(learningPlan);
db.SaveChanges();
}
}
foreach (ProgramOutcome p in data.Lpo)
{
if (p.PO_Code != null && p.PO_attr != null & p.PO_CVA != null && p.PO_Desc != null)
{
ProgramOutcome programOutcome = new ProgramOutcome();
programOutcome.PO_Code = p.PO_Code;
programOutcome.PO_attr = p.PO_attr;
programOutcome.PO_Desc = p.PO_Desc;
programOutcome.PO_CVA = p.PO_CVA;
programOutcome.Syllabus_ID = res.Syllabus_ID;
db.ProgramOutcomes.Add(programOutcome);
db.SaveChanges();
}
}
foreach (Rubric p in data.Lr)
{
if (p.marginal != null && p.notAcceptable != null & p.outstanding != null && p.competent != null && p.criteria != null)
{
Rubric rubric = new Rubric();
rubric.competent = p.competent;
rubric.criteria = p.criteria;
rubric.marginal = p.marginal;
rubric.notAcceptable = p.notAcceptable;
rubric.outstanding = p.outstanding;
rubric.Syllabus_ID = res.Syllabus_ID;
db.Rubrics.Add(rubric);
db.SaveChanges();
}
}
return(View());
}
// GET: Syll/Create
public ActionResult Create()
{
Syll sy = new Syll();
return(View());
}
