public JsonResult UpdateUserRegesterQuestion(ModelUserRegQuestion GetUserQues)
{
try
{
using (IwillDbEntities data = new IwillDbEntities())
{
var UserQuestion = data.UserQuestions.Where(i => i.UQID == GetUserQues.UQID).FirstOrDefault();
if (UserQuestion == null)
{
return(Json("No Record Found", JsonRequestBehavior.AllowGet));
}
UserQuestion.UQuestion = GetUserQues.UQuestion;
UserQuestion.IsStudent = GetUserQues.IsStudent;
int r = data.SaveChanges();
if (r >= 0)
{
TempData["success"] = "Question has Successfully updated";
return(Json("Record Updated Successfully", JsonRequestBehavior.AllowGet));
}
else
{
//ViewData["Error"]= "Error: on updating the question";
return(Json("error on inserting", JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
ViewData["Error"] = "Error: " + ex.Message;
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
public ActionResult InsertQuesForUserRegistration(ModelUserRegQuestion mod)
{
using (var transaction = DBC.Database.BeginTransaction())
{
try
{
if (mod == null)
{
throw new Exception("There is no Questionairs to save ");
}
var QuestionObj = new UserQuestion()
{
UQuestion = mod.UQuestion,
FkUQType = mod.FkUQType,
IsStudent = mod.IsStudent,
IsActive = mod.IsActive == null ? true : mod.IsActive,
CreatedOn = DateTime.Now,
CreatedBy = Helper.User.UID
};
DBC.UserQuestions.Add(QuestionObj);
DBC.SaveChanges();
if (mod.FkUQType != 2)
{
var QuestionID = DBC.UserQuestions.Local[0].UQID;
foreach (var item in mod.UserQuestionDetail)
{
var ObjDetail = new UserQuestionDetail()
{
QuesOptionName = item.QuesOptionName,
IsRight = item.IsRight,
IsActive = item.IsActive == null ? true : item.IsActive,
FkQID = QuestionID,
};
DBC.UserQuestionDetails.Add(ObjDetail);
DBC.SaveChanges();
}
}
TempData["success"] = "Question has been created";
transaction.Commit();
return(RedirectToAction("ViewCreateQuesForUserRegistration", "UserRegQuestion"));
}
catch (Exception ex)
{
transaction.Rollback();
ViewData["Error"] = "Error: to Save data " + ex.Message;
return(RedirectToAction("ViewCreateQuesForUserRegistration", "UserRegQuestion"));
}
}
}
public ActionResult AddQuestionOptionMcqz(ModelUserRegQuestion mod)
{
using (var transaction = DBC.Database.BeginTransaction())
{
try
{
long?effectedID = null;
if (mod == null)
{
throw new Exception("There is no Questionairs to save ");
}
foreach (var item in mod.UserQuestionDetail)
{
var ObjDetail = new UserQuestionDetail();
ObjDetail.QuesOptionName = item.QuesOptionName;
if (item.IsRight)
{
var DBoptions = DBC.UserQuestionDetails.Where(i => i.FkQID == mod.UQID && i.IsRight == true).FirstOrDefault();
DBoptions.IsRight = false;
DBC.SaveChanges();
}
ObjDetail.IsRight = item.IsRight;
ObjDetail.IsActive = item.IsActive == null ? true : item.IsActive;
ObjDetail.FkQID = mod.UQID;
DBC.UserQuestionDetails.Add(ObjDetail);
DBC.SaveChanges();
effectedID = DBC.UserQuestionDetails.Local[0].UQDID;
}
TempData["success"] = "New Question MCQz Options has been created";
TempData["UQID"] = mod.UQID;
TempData["option"] = effectedID;
transaction.Commit();
return(RedirectToAction("ViewUserQuestionsList", "UserRegQuestion"));
}
catch (Exception ex)
{
transaction.Rollback();
ViewData["Error"] = "Error: to Save data " + ex.Message;
return(RedirectToAction("ViewUserQuestionsList", "UserRegQuestion"));
}
}
}