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 Register(FormCollection formCollection) { try { int empId = Convert.ToInt32(formCollection["EmployeeNumber"]); string uname = formCollection["NewUsername"]; //check the record is already available or not var checkRegistration = entities.UserRegistrationDetails.Where(q => q.EmployeeNumber == empId).FirstOrDefault(); var username = entities.UserRegistrationDetails.Where(q => q.Username == uname).FirstOrDefault(); if (checkRegistration == null && username == null) { //inserting data into User registration details table UserRegistrationDetail user = new UserRegistrationDetail(); user.EmployeeNumber = empId; user.EmployeeName = formCollection["EmployeeName"]; user.ContactNumber = formCollection["ContactNumber"]; user.Username = formCollection["NewUsername"]; user.Password = formCollection["Pass"]; entities.UserRegistrationDetails.Add(user); //adding data in user questions details UserQuestionDetail userQuestion = new UserQuestionDetail(); string qname = formCollection["AllQuestions"]; int qid = (from res in entities.Questions where res.Question1 == qname select res.QuestionId).FirstOrDefault(); userQuestion.QuestionId = qid; userQuestion.Answer = formCollection["Answer"]; userQuestion.EmpoyeeNumber = Convert.ToInt32(formCollection["EmployeeNumber"]); entities.UserQuestionDetails.Add(userQuestion); entities.SaveChanges(); return(Content("<script language='javascript' type='text/javascript'>alert('Employee Registered Successfully');window.location = 'Index';</script>")); } else { // Content("<script language='javascript' type='text/javascript'>alert('This EmployeeId already Registered');window.location = "Index";</script>"); return(Content("<script language='javascript' type='text/javascript'>alert('This Employee already Registered');window.location = 'Index';</script>")); } } catch (Exception) { return(Content("<script language='javascript' type='text/javascript'>alert('This Username already Registered');window.location = 'Index';</script>")); } }
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")); } } }