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));
}
