public ActionResult Create([Bind(Include = "ID,AnswerContent,IsRightAnswer,Status,QuestionID,AnswerType,Mark")] SATAnswer sATAnswer) { try { ViewBag.QuestionID = new SelectList(db.SATQuestions, "ID", "Title", sATAnswer.QuestionID); var textType = new SelectListItem() { Value = "1", Text = "Nhập vào" }; var choiceType = new SelectListItem() { Value = "0", Text = "Chọn câu" }; ViewBag.AnswerType = new SelectList(new List <SelectListItem>() { choiceType, textType }, "Value", "Text"); if (ModelState.IsValid) { db.SATAnswers.Add(sATAnswer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sATAnswer)); } catch (Exception ex) { return(View(sATAnswer)); } }
public ResponseData DeleteLevelTransfer(int id) { ResponseData result = new Models.ResponseData(); using (SATEntities db = new SATEntities()) { using (var transection = db.Database.BeginTransaction()) { try { var listdelete = db.tb_Move_Level_Detail.Where(x => x.MlID == id).ToList(); db.tb_Move_Level_Detail.RemoveRange(listdelete); db.SaveChanges(); var itemdelete = db.tb_Move_Level_Head.Where(x => x.MlID == id).FirstOrDefault(); db.tb_Move_Level_Head.Remove(itemdelete); db.SaveChanges(); transection.Commit(); } catch (Exception ex) { transection.Rollback(); result.MessageCode = ""; result.MessageText = ex.Message; } return result; } } }
public ActionResult AddQuestionToLine(int questionID, string selectedText, int?examContentId = 0) { var underlineText = new SATWritingUnderlineText(); underlineText.QuestionID = questionID; underlineText.UnderlineText = selectedText; underlineText.Number = db.SATQuestions.Find(questionID).QuestionNo; db.SATWritingUnderlineTexts.Add(underlineText); var _question = db.SATQuestions.Find(questionID); if (examContentId != 0) { _question.ExamContentID = examContentId; } else { if (Session["QuestionID"] != null) { Session["QuestionID"] = Session["QuestionID"].ToString() + questionID + ","; } else { Session["QuestionID"] = questionID; } } db.Entry(_question).State = EntityState.Modified; db.SaveChanges(); var question = db.SATQuestions.Where(q => q.ID == questionID); var countListQuestion = db.SATQuestions.Where(q => q.ExamContentID == null && q.SATWritingUnderlineTexts.Any(u => u.QuestionID == q.ID) == false).Except(question).Count(); var inputHidden = "<input type = 'hidden' id = 'questionID' name='questionToAdd' value = '" + questionID + "' />"; return(Json(new { countListQuestion = countListQuestion, inputHidden = inputHidden, number = underlineText.Number }, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "SSID,SSName,SSdescription")] StudentStatus studentStatus) { if (ModelState.IsValid) { db.StudentStatuses.Add(studentStatus); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(studentStatus)); }
public ActionResult Create([Bind(Include = "CourseId,CourseName,CourseDescription,CreditHours,Curriculum,Notes,IsActive")] Cours cours) { if (ModelState.IsValid) { db.Courses.Add(cours); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cours)); }
public ActionResult Create([Bind(Include = "SCID,SCName,SCDescription")] ScheduledClassStatu scheduledClassStatu) { if (ModelState.IsValid) { db.ScheduledClassStatus.Add(scheduledClassStatu); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(scheduledClassStatu)); }
public ActionResult Create([Bind(Include = "carg_Id,carg_Descripcion,carg_UsuarioCrea,carg_FechaCrea,carg_UsuarioModifica,carg_FechaModifica")] tbCargos tbCargos) { if (ModelState.IsValid) { db.tbCargos.Add(tbCargos); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbCargos)); }
public ActionResult Create([Bind(Include = "SCSID,SCSName")] ScheduledClassStatus scheduledClassStatus) { if (ModelState.IsValid) { db.ScheduledClassStatuses.Add(scheduledClassStatus); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(scheduledClassStatus)); }
public ActionResult Create(SATCourseStatus satcoursestatus) { if (ModelState.IsValid) { db.SATCourseStatuses.AddObject(satcoursestatus); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(satcoursestatus)); }
public ActionResult Create(StudentStatu studentstatu) { if (ModelState.IsValid) { db.StudentStatus.AddObject(studentstatu); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(studentstatu)); }
public ActionResult Create(SATScheduledClassStatus satscheduledclassstatus) { if (ModelState.IsValid) { db.SATScheduledClassStatuses.AddObject(satscheduledclassstatus); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(satscheduledclassstatus)); }
public ActionResult Create(CourseStatu coursestatu) { if (ModelState.IsValid) { db.CourseStatus.AddObject(coursestatu); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(coursestatu)); }
public ActionResult Create([Bind(Include = "CourseID,CourseName,Subject,Description,CreditHours,IsVirtual")] Course course) { if (ModelState.IsValid) { db.Courses1.Add(course); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(course)); }
public ActionResult Create(SATCours satcours) { if (ModelState.IsValid) { db.SATCourses.AddObject(satcours); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.statusId = new SelectList(db.SATCourseStatuses, "CSID", "CSName", satcours.statusId); return(View(satcours)); }
public ActionResult Create([Bind(Include = "ID,RawValue,ScoreValue,TypeID")] SATScore sATScore) { if (ModelState.IsValid) { db.SATScores.Add(sATScore); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TypeID = new SelectList(db.SATTypes, "TypeID", "TypeName", sATScore.TypeID); return(View(sATScore)); }
public ActionResult Create([Bind(Include = "StudentID,FirstName,LastName,PhoneNbr,Email,StreetAddress,City,State,ZipCode,Country,PhotoUrl,StatusID")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StatusID = new SelectList(db.StudentStatuses, "StudentStatusID", "StatusName", student.StatusID); return(View(student)); }
public ActionResult Create([Bind(Include = "emp_Id,emp_Identidad,emp_Nombres,emp_Apellidos,emp_FechaNacimiento,emp_Sexo,emp_Direccion,mun_Id,emp_CorreoElectronico,emp_Telefono,carg_Id,emp_FechaIngreso,emp_FechadeSalida,emp_RazonSalida,emp_UsuarioCrea,emp_FechaCrea,emp_UsuarioModifica,emp_FechaModifica")] tbEmpleados tbEmpleados) { if (ModelState.IsValid) { db.tbEmpleados.Add(tbEmpleados); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.carg_Id = new SelectList(db.tbCargos, "carg_Id", "carg_Descripcion", tbEmpleados.carg_Id); return(View(tbEmpleados)); }
public ActionResult Create([Bind(Include = "ScheduledClassID,CourseID,InstructorName,Location,StartDate,EndDate,EnrollmentMax")] ScheduledClass scheduledClass) { if (ModelState.IsValid) { db.ScheduledClasses.Add(scheduledClass); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", scheduledClass.CourseID); return(View(scheduledClass)); }
public ResponseData SaveRoleMenu(List <RoleMenuViewModel> model) { ResponseData result = new Models.ResponseData(); using (SATEntities db = new SATEntities()) { try { if (model != null) { foreach (var item in model) { if (item.MenuType == "M" || (item.ParentID != 0 && (item.MenuType == "T" || item.MenuType == "R"))) { var data = db.tb_Menu_Role.Where(m => m.RoleID == item.RoleID && m.MenuID == item.MenuID).FirstOrDefault(); if (data != null) { data.R_View = item.R_View; data.R_Add = item.R_Add; data.R_Edit = item.R_Edit; data.R_Delete = item.R_Delete; data.ModifyBy = UtilityService.User.UserID; data.ModifyDate = DateTime.Now; db.SaveChanges(); } else { tb_Menu_Role obj = new tb_Menu_Role(); obj.RoleID = item.RoleID; obj.MenuID = item.MenuID; obj.R_View = item.R_View; obj.R_Add = item.R_Add; obj.R_Edit = item.R_Edit; obj.R_Delete = item.R_Delete; obj.CreateBy = UtilityService.User.UserID; obj.CreateDate = DateTime.Now; obj.ModifyBy = UtilityService.User.UserID; obj.ModifyDate = DateTime.Now; db.tb_Menu_Role.Add(obj); db.SaveChanges(); } } } } } catch (Exception ex) { result.MessageCode = ""; result.MessageText = ex.Message; } return(result); } }
public ActionResult Create([Bind(Include = "StudentId,FirstName,LastName,Major,Address,City,State,ZipCode,Phone,Email,PhotoUrl,SSID")] Students students) { if (ModelState.IsValid) { db.Students1.Add(students); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SSID = new SelectList(db.StudentStatuses, "SSID", "SSName", students.SSID); return(View(students)); }
public ActionResult Create([Bind(Include = "car_Id,car_Descripcion,car_Encargado,car_UsuarioCrea,car_FechaCrea,car_UsuarioModifica,car_FechaModifica")] tbCarreras tbCarreras) { if (ModelState.IsValid) { db.tbCarreras.Add(tbCarreras); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.car_Encargado = new SelectList(db.tbEmpleados, "emp_Id", "emp_Identidad", tbCarreras.car_Encargado); return(View(tbCarreras)); }
public ActionResult Edit([Bind(Include = "jor_Id,jor_Descripcion,jor_UsuarioCrea,jor_FechaCrea,jor_UsuarioModifica,jor_FechaModifica")] tbJornadas tbJornadas) { tbJornadas.jor_FechaModifica = DateTime.Now; tbJornadas.jor_UsuarioModifica = 2; if (ModelState.IsValid) { db.Entry(tbJornadas).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbJornadas)); }
public ActionResult Create([Bind(Include = "EnrollmentId,StudentId,ScheduledClassId,EnrollmentDate")] Enrollment enrollment) { if (ModelState.IsValid) { db.Enrollments.Add(enrollment); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ScheduledClassId = new SelectList(db.ScheduledClasses, "ScheduledClassId", "InstructorName", enrollment.ScheduledClassId); ViewBag.StudentId = new SelectList(db.Students, "StudentId", "FirstName", enrollment.StudentId); return(View(enrollment)); }
public ActionResult Create(Enrollment enrollment) { if (ModelState.IsValid) { db.Enrollments.AddObject(enrollment); db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.scheduledClassId = new SelectList(GetClassDdlItems(), "ID", "Name", enrollment.scheduledClassId); ViewBag.studentId = new SelectList(GetStudentDdlItems(), "ID", "Name", enrollment.studentId); return View(enrollment); }
public ActionResult Create([Bind(Include = "EnrollmentId,StudentId,ScheduledClassId,EnrollmentDate")] Enrollments enrollments) { if (ModelState.IsValid) { db.Enrollments1.Add(enrollments); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ScheduledClassId = new SelectList(db.ScheduledClasses1, "ScheduledClassId", "ShortDesc", enrollments.ScheduledClassId); ViewBag.StudentId = new SelectList(db.Students1, "StudentId", "FullName", enrollments.StudentId); return(View(enrollments)); }
public ActionResult Create([Bind(Include = "ScheduledClassId,CourseId,StartDate,EndDate,InstructorName,Location,SCISD")] ScheduledClass scheduledClass) { if (ModelState.IsValid) { db.ScheduledClasses.Add(scheduledClass); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName", scheduledClass.CourseId); ViewBag.SCISD = new SelectList(db.ScheduledClassStatus1, "SCSID", "SCName", scheduledClass.SCISD); return(View(scheduledClass)); }
public ActionResult Create([Bind(Include = "Id,Name,Email,Phone,Password,IsLocked")] SATAccount userModel) { if (ModelState.IsValid) { var model = userModel.Map <Infrastructure.DbContext.User>(); model.Name = userModel.Username; db.Users.Add(model); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userModel)); }
public ActionResult Create([Bind(Include = "mun_Id,mun_Descripcion,mun_UsuarioCrea,mun_FechaCrea,mun_UsuarioModifica,mun_FechaModifica,dep_Id")] tbMunicipios tbMunicipios) { if (ModelState.IsValid) { tbMunicipios.mun_FechaCrea = DateTime.Now; db.tbMunicipios.Add(tbMunicipios); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.dep_Id = new SelectList(db.tbDepartamentos, "dep_Id", "dep_Descripcion", tbMunicipios.dep_Id); return(View(tbMunicipios)); }
public ActionResult Create(SATScheduledClass satscheduledclass) { if (ModelState.IsValid) { db.SATScheduledClasses.AddObject(satscheduledclass); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.courseId = new SelectList(db.SATCourses, "courseId", "courseName", satscheduledclass.courseId); ViewBag.statusId = new SelectList(db.SATScheduledClassStatuses, "SCSID", "SCSName", satscheduledclass.statusId); return(View(satscheduledclass)); }
public ActionResult Edit([Bind(Include = "esc_Id,esc_Codigo,esc_NombreEscuela,esc_Director,esc_Contacto,esc_Telefono,esc_Correo,mun_Id,esc_UsuarioCrea,esc_FechaCrea,esc_UsuarioModifica,esc_FechaModifica")] tbEscuelas tbEscuelas) { if (ModelState.IsValid) { db.Entry(tbEscuelas).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.esc_UsuarioCrea = new SelectList(db.tbUsuarios, "usu_Id", "usu_NombreUsuario", tbEscuelas.esc_UsuarioCrea); ViewBag.esc_UsuarioModifica = new SelectList(db.tbUsuarios, "usu_Id", "usu_NombreUsuario", tbEscuelas.esc_UsuarioModifica); ViewBag.esc_Contacto = new SelectList(db.tbEmpleados, "emp_Id", "emp_Identidad", tbEscuelas.esc_Contacto); ViewBag.esc_Director = new SelectList(db.tbEmpleados, "emp_Id", "emp_Identidad", tbEscuelas.esc_Director); ViewBag.mun_Id = new SelectList(db.tbMunicipios, "mun_Id", "mun_Descripcion", tbEscuelas.mun_Id); return(View(tbEscuelas)); }