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