//GET: /Comision/AsignarProfesorComision/5 public ActionResult AsignarProfesorComision(int? id) { if (Request.UrlReferrer != null) { ViewBag.returnUrl = Request.UrlReferrer.ToString(); } else { ViewBag.returnUrl = null; } Commission commission = db.Commissions.Find(id); ScheduleComissionViewModel commissionViewModel = new ScheduleComissionViewModel(); commissionViewModel.Commissions = commission.Name; ViewBag.Professors = new SelectList(db.Professors.OrderBy(p => p.Name), "ID", "Name"); ; ViewBag.CommissionID = commission.ID.ToString(); return View(commissionViewModel); }
public ActionResult AsignarProfesorComision(ScheduleComissionViewModel pSchedule) { var vPeriod = Request.Cookies["Periodo"].Value; var vPeriodID = db.Periods.Find(int.Parse(vPeriod)).ID; var vHourCharge = Convert.ToInt32(pSchedule.HourCharge); var vCommissionID = Convert.ToInt32(pSchedule.Commissions); var vProfessorID = Convert.ToInt32(pSchedule.Professors); List<ScheduleComission> vSchedules = pSchedule.ScheduleCommission; string validate = dbHelper.validationsCommission(vCommissionID,vProfessorID,vPeriodID,vSchedules); if(validate.Equals("true")) { int totalHourAssign = 0; //Save Commission Professor CommissionXProfessor vCommissionProfessor = new CommissionXProfessor(); vCommissionProfessor.CommissionID = Convert.ToInt32(vCommissionID); vCommissionProfessor.ProfessorID = Convert.ToInt32(vProfessorID); if (vHourCharge.Equals("1")) { vCommissionProfessor.HourAllocatedTypeID = Convert.ToInt32(vHourCharge); } vCommissionProfessor.PeriodID = vPeriodID; vCommissionProfessor.Schedule = new List<Schedule>(); //Calculate the total hour assign foreach (ScheduleComission vSchedule in vSchedules) { Schedule vTempSchedule = existSchedule(vSchedule.Day, vSchedule.StartHour, vSchedule.EndHour); if (vTempSchedule != null) { //Get id schedule vTempSchedule.CommissionsXProfessors.Add(vCommissionProfessor); } //Convert StartHour to DateTime var vStartHour = DateTime.Parse(vSchedule.StartHour); var vEndHour = DateTime.Parse(vSchedule.EndHour); var CargaC = Math.Ceiling(vEndHour.Subtract(vStartHour).TotalHours); int vDiferencia = Convert.ToInt32(CargaC); totalHourAssign = totalHourAssign + vDiferencia; } vCommissionProfessor.Hours = totalHourAssign; db.CommissionsXProfessors.Add(vCommissionProfessor); db.SaveChanges(); TempData[TempDataMessageKeySuccess] = "Profesor asignado correctamente."; return RedirectToAction("Details", new { id = vCommissionID }); } else if(validate.Equals("falseIsGroupShock")) { TempData[TempDataMessageKeyError] = "Existe choque de horario con grupos, no se asigno al profesor a la comisión"; return RedirectToAction("AsignarProfesorComision"); } else if(validate.Equals("falseIsProjectShock")) { TempData[TempDataMessageKeyError] = "Existe choque de horario con proyectos, no se asigno al profesor a la comisión"; return RedirectToAction("AsignarProfesorComision"); } else if(validate.Equals("falseIsCommissionShock")) { TempData[TempDataMessageKeyError] = "Existe choque de horario con comisiones, no se asigno al profesor a la comisión"; return RedirectToAction("AsignarProfesorComision"); } else if (validate.Equals("falseIsProfessorShock")) { TempData[TempDataMessageKeyError] = "El profesor ya esta asignado a esta comision, no se permite asignar dos veces a un profesor a una comisión "; return RedirectToAction("AsignarProfesorComision"); } return View(); }
public ActionResult EditarAsignacion(ScheduleComissionViewModel pSchedule) { var vPeriod = Request.Cookies["Periodo"].Value; var vPeriodID = db.Periods.Find(int.Parse(vPeriod)).ID; var vCommissionProfessorID = Convert.ToInt32(pSchedule.Commissions); var vHourCharge = Convert.ToInt32(pSchedule.HourCharge); var vProfessorID = Convert.ToInt32(pSchedule.Professors); if (ModelState.IsValid) { CommissionXProfessor vCommissionProfessor = db.CommissionsXProfessors.Find(vCommissionProfessorID); var vCommissionID = vCommissionProfessor.CommissionID; List<ScheduleComission> vSchedules = pSchedule.ScheduleCommission; string validate = dbHelper.validationsEditCommisson(vCommissionID, vProfessorID,vPeriodID, vSchedules); if (validate.Equals("true")) { vCommissionProfessor.ProfessorID = vProfessorID; vCommissionProfessor.HourAllocatedTypeID = Convert.ToInt32(vHourCharge); var totalHourAssign = 0; vCommissionProfessor.Schedule.Clear(); //Calculate the total hour assign foreach (ScheduleComission vSchedule in vSchedules) { Schedule vTempSchedule = existSchedule(vSchedule.Day, vSchedule.StartHour, vSchedule.EndHour); if (vTempSchedule != null) { //Get id schedule vTempSchedule.CommissionsXProfessors.Add(vCommissionProfessor); vCommissionProfessor.Schedule.Add(vTempSchedule); } //Convert StartHour to DateTime var vStartHour = DateTime.Parse(vSchedule.StartHour); var vEndHour = DateTime.Parse(vSchedule.EndHour); var CargaC = Math.Ceiling(vEndHour.Subtract(vStartHour).TotalHours); int vDiferencia = Convert.ToInt32(CargaC); totalHourAssign = totalHourAssign + vDiferencia; } vCommissionProfessor.Hours = totalHourAssign; db.SaveChanges(); TempData[TempDataMessageKeySuccess] = "Profesor asignado correctamente."; return RedirectToAction("Details", new { id = vCommissionProfessor.CommissionID }); } else if (validate.Equals("falseIsGroupShock")) TempData[TempDataMessageKeyError] = "Existe choque de horario con grupos, no se asigno al profesor a la comisión"; else if (validate.Equals("falseIsProjectShock")) TempData[TempDataMessageKeyError] = "Existe choque de horario con proyectos, no se asigno al profesor a la comisión"; else if (validate.Equals("falseIsCommissionShock")) TempData[TempDataMessageKeyError] = "Existe choque de horario con comisiones, no se asigno al profesor a la comisión"; if (Request.UrlReferrer != null) { ViewBag.returnUrl = Request.UrlReferrer.ToString(); } else { ViewBag.returnUrl = null; } var commission_profesor = db.CommissionsXProfessors.Find(vCommissionProfessorID); var commissionID = commission_profesor.CommissionID; Commission commission = db.Commissions.Find(commissionID); ScheduleComissionViewModel commissionViewModel = new ScheduleComissionViewModel(); commissionViewModel.Commissions = commission.Name; ViewBag.Professors = new SelectList(db.Professors, "ID", "Name"); ViewBag.CommissionID = commission_profesor.CommissionID.ToString(); return View(commissionViewModel); } return View(); }
//GET: Comision / EditarAsignacion/5 public ActionResult EditarAsignacion(int id) { if (Request.UrlReferrer != null) { ViewBag.returnUrl = Request.UrlReferrer.ToString(); } else { ViewBag.returnUrl = null; } var commission_profesor = db.CommissionsXProfessors.Find(id); var commissionID = commission_profesor.CommissionID; Commission commission = db.Commissions.Find(commissionID); ScheduleComissionViewModel commissionViewModel = new ScheduleComissionViewModel(); commissionViewModel.Commissions = commission.Name; ViewBag.Professors = new SelectList(db.Professors, "ID", "Name"); ViewBag.CommissionID = commissionID.ToString(); return View(commissionViewModel); }