public ActionResult EditarAsignacion(ScheduleProjectViewModel pSchedule) { var vPeriod = Request.Cookies["Periodo"].Value; var vPeriodID = db.Periods.Find(int.Parse(vPeriod)).ID; var vProjectXProfessorID = Convert.ToInt32(pSchedule.Projects); var vHourChange = Convert.ToInt32(pSchedule.HourCharge); var vProfessorID = Convert.ToInt32(pSchedule.Professors); if (ModelState.IsValid) { ProjectXProfessor vProjectXProfessor = db.ProjectsXProfessors.Find(vProjectXProfessorID); var vProjectID = vProjectXProfessor.ProjectID; List <ScheduleProject> vSchedules = pSchedule.ScheduleProject; string validate = dbHelper.validationsEditProject(vProjectID, vProfessorID, vPeriodID, vSchedules); if (validate.Equals("true")) { vProjectXProfessor.ProfessorID = vProfessorID; vProjectXProfessor.HourAllocatedTypeID = Convert.ToInt32(vHourChange); var totalHourAssign = 0; vProjectXProfessor.Schedule.Clear(); //Calculate the total hour assign foreach (ScheduleProject vSchedule in vSchedules) { Schedule vTempSchedule = existSchedule(vSchedule.Day, vSchedule.StartHour, vSchedule.EndHour); if (vTempSchedule != null) { //Get id schedule vTempSchedule.ProjectsXProfessors.Add(vProjectXProfessor); vProjectXProfessor.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; } vProjectXProfessor.Hours = totalHourAssign; db.SaveChanges(); TempData[TempDataMessageKeySuccess] = "Profesor asignado correctamente"; return(RedirectToAction("Details", new { id = vProjectXProfessor.ProjectID })); } else if (validate.Equals("falseIsProjectShock")) { TempData[TempDataMessageKeyError] = "Existe choque de horario con proyectos, no se asigno al profesor al proyecto"; } else if (validate.Equals("falseIsGroupShock")) { TempData[TempDataMessageKeyError] = "Existe choque de horario con grupos, no se asigno al profesor al proyecto"; } else if (validate.Equals("falseIsCommissionShock")) { TempData[TempDataMessageKeyError] = "Existe choque de horario con comisiones, no se asigno al profesor a la comisión"; } /* Get the list of professor related with project */ if (Request.UrlReferrer != null) { ViewBag.returnUrl = Request.UrlReferrer.ToString(); } else { ViewBag.returnUrl = null; } var ProjectsXProfessors = db.ProjectsXProfessors.Find(vProjectXProfessorID); var projectID = ProjectsXProfessors.ProjectID; Project project = db.Projects.Find(projectID); ScheduleProjectViewModel projectViewModel = new ScheduleProjectViewModel(); projectViewModel.Projects = project.Name; ViewBag.Professors = new SelectList(db.Professors, "ID", "Name"); ViewBag.ProjectID = projectID.ToString(); return(View(projectViewModel)); } return(View()); }
public ActionResult Asignar(ScheduleProjectViewModel pSchedule) { var vPeriod = Request.Cookies["Periodo"].Value; var vPeriodID = db.Periods.Find(int.Parse(vPeriod)).ID; string vHourCharge = pSchedule.HourCharge; int vProjectID = Convert.ToInt32(pSchedule.Projects); int vProfessorID = Convert.ToInt32(pSchedule.Professors); List <ScheduleProject> vSchedules = pSchedule.ScheduleProject; string validate = scheduleHelper.validationProject(vProjectID, vProfessorID, vPeriodID, vSchedules); if (validate.Equals("true")) { int totalHourAssign = 0; //Save Commission Professor ProjectXProfessor vProjectProfessor = new ProjectXProfessor(); vProjectProfessor.ProjectID = Convert.ToInt32(vProjectID); vProjectProfessor.ProfessorID = Convert.ToInt32(vProfessorID); if (vHourCharge.Equals("1")) { vProjectProfessor.HourAllocatedTypeID = Convert.ToInt32(vHourCharge); } vProjectProfessor.PeriodID = vPeriodID; vProjectProfessor.Schedule = new List <Schedule>(); //Calculate the total hour assign foreach (ScheduleProject vSchedule in vSchedules) { Schedule vTempSchedule = existSchedule(vSchedule.Day, vSchedule.StartHour, vSchedule.EndHour); if (vTempSchedule != null) { //Get id schedule vTempSchedule.ProjectsXProfessors.Add(vProjectProfessor); } //Convert StartHour to DateTime var HoraInicio = DateTime.Parse(vSchedule.StartHour); //Convert EndHour to DateTime var HoraFin = DateTime.Parse(vSchedule.EndHour); //Get the difference between StartHour and EndHour var vSTRDiff = Math.Ceiling(HoraFin.Subtract(HoraInicio).TotalHours); int vDiferencia = Convert.ToInt32(vSTRDiff); totalHourAssign = totalHourAssign + vDiferencia; } vProjectProfessor.Hours = totalHourAssign; db.ProjectsXProfessors.Add(vProjectProfessor); db.SaveChanges(); TempData[TempDataMessageKeySuccess] = "Profesor asignado correctamente."; return(RedirectToAction("Asignar")); } else if (validate.Equals("falseIsGroupShock")) { TempData[TempDataMessageKeyError] = "Existe choque de horario con grupos, no se asigno al profesor al proyecto"; return(RedirectToAction("Asignar")); } else if (validate.Equals("falseIsProjectShock")) { TempData[TempDataMessageKeyError] = "Existe choque de horario con proyectos, no se asigno al profesor al proyecto"; return(RedirectToAction("Asignar")); } else if (validate.Equals("falseIsCommissionShock")) { TempData[TempDataMessageKeyError] = "Existe choque de horario con comisiones, no se asigno al profesor al proyecto"; return(RedirectToAction("Asignar")); } else if (validate.Equals("falseIsProfessorShock")) { TempData[TempDataMessageKeyError] = "El profesor ya esta asignado a este proyecto, no se permite asignar dos veces a un profesor a un proyecto "; return(RedirectToAction("Asignar")); } return(View()); }
//GET: Proyecto /DetalleAsignacion/5 public ActionResult DetalleAsignacion(int id) { ProjectXProfessor project_profesor = db.ProjectsXProfessors.Find(id); return(View(project_profesor)); }