public ActionResult Edit(createOption option)
{
OptionDetail Op = new OptionDetail();
QuesDetail ques = new QuesDetail();
using (var ctx = new mocktestEntities1())
{
ctx.Configuration.LazyLoadingEnabled = false;
Op = ctx.OptionDetails.Where(s => s.QuesDetailId == option.Qid).FirstOrDefault <OptionDetail>();
ques = ctx.QuesDetails.Where(a => a.QuesDetailId == option.Qid).FirstOrDefault <QuesDetail>();
}
ques.Question = option.question.EditQuestion;
ques.OpCorrect = option.question.optionCorrect;
Op.OpOne = option.optionOne;
Op.OpTwo = option.optionTwo;
Op.OpThree = option.optionThree;
Op.OpFour = option.optionFour;
using (mocktestEntities1 selectStatement = new mocktestEntities1())
{
selectStatement.Entry(ques).State = System.Data.Entity.EntityState.Modified;
selectStatement.Entry(Op).State = System.Data.Entity.EntityState.Modified;
selectStatement.SaveChanges();
}
return(Json(JsonRequestBehavior.AllowGet));
}
public ActionResult CreateQuiz(createOption ques)
{
mocktestEntities1 db = new mocktestEntities1();
List <Topic> topicName = new List <Topic>();
List <SubTopic> subName = new List <SubTopic>();
List <QuesDetail> questList = new List <QuesDetail>();
bool Active = true;
QuesDetail newQuestion = new QuesDetail();
OptionDetail newOption = new OptionDetail();
int quesId = 0;
topicName = db.Topics.ToList();
subName = db.SubTopics.ToList();
if (QuestionIsVaild(ques.question.Question, ques.SubId))
{
Int32 Id = ques.SubId;
newQuestion.SubTopicId = Id;
string Queval = ques.question.Question.Replace("<", "<");
string Queval1 = Queval.Replace(">", ">");
newQuestion.Question = Queval1;
newQuestion.OpCorrect = ques.question.optionCorrect;
newQuestion.Active = Active;
newOption.OpOne = ques.optionOne;
newOption.OpTwo = ques.optionTwo;
newOption.OpThree = ques.optionThree;
newOption.OpFour = ques.optionFour;
db.QuesDetails.Add(newQuestion);
db.SaveChanges();
var QSTID = newQuestion.QuesDetailId;
//using (mocktestEntities1 select = new mocktestEntities1())
//{
// var quid = select.QuesDetails.Where(a => a.Question == Queval1 & a.Active == true).FirstOrDefault();
// quesId = quid.QuesDetailId;
//}
newOption.QuesDetailId = QSTID;
newOption.Active = Active;
db.OptionDetails.Add(newOption);
db.SaveChanges();
//return View();
return(Json(new { result = 0, message = "Success" }));
}
//TempData["alertMessage"] = "Question Already Exist!";
//return View();
return(Json(new { result = 1, message = "Question Already Exist!" }));
}
public OptionDetailTests()
{
_put = new OptionDetail();
_put.Side = "put";
_put.Bid = 1;
_put.Ask = 2;
_put.ExpirationDate = DateTime.UtcNow.AddDays(20).ToString("yyyyMMdd");
_put.StrikePrice = 22;
_put.OpenInterest = 1;
_put.Volume = 2;
_call = new OptionDetail();
_call.Side = "call";
_call.Bid = 1;
_call.Ask = 2;
_call.ExpirationDate = DateTime.UtcNow.AddDays(20).ToString("yyyyMMdd");
_call.StrikePrice = 22;
_call.OpenInterest = 1;
_call.Volume = 2;
}
private static void AddOptions(SurveyShrikeEntities context, QuestionModel currentQuestion, Question question)
{
foreach (var currentOption in currentQuestion.Options)
{
Option option = new Option();
option.QuestionId = question.QuestionId;
option.Description = currentOption.Text;
context.Options.Add(option);
context.SaveChanges();
if (option.OptionId > 0)
{
OptionDetail optionDetail = new OptionDetail();
optionDetail.OptionId = option.OptionId;
optionDetail.PlaceHolder = !String.IsNullOrEmpty(currentOption.PlaceHolder) ? currentOption.PlaceHolder : "";
optionDetail.MinLength = currentOption.MinLength;
optionDetail.MaxLength = currentOption.MaxLength;
optionDetail.RegexPattern = !String.IsNullOrEmpty(currentOption.RegexPattern) ? currentOption.RegexPattern : null;
context.OptionDetails.Add(optionDetail);
context.SaveChanges();
}
}
}
public ActionResult UploadExcel(List <HttpPostedFileBase> files, Int32 SubId)
{
mocktestEntities1 db = new mocktestEntities1();
var uploadFile = Request.Files[0];
List <QuesDetail> questList = new List <QuesDetail>();
HomeController home = new HomeController();
int setCount = 0;
int Qid = 0;
bool check = false;
if (uploadFile != null && uploadFile.ContentLength > 0)
{
Stream stream = uploadFile.InputStream;
IExcelDataReader reader = null;
if (uploadFile.FileName.EndsWith(".xls"))
{
reader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (uploadFile.FileName.EndsWith(".xlsx"))
{
reader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
else
{
return(Json(check, JsonRequestBehavior.AllowGet));
}
reader.IsFirstRowAsColumnNames = true;
DataSet result = reader.AsDataSet();
foreach (DataColumn col in result.Tables[0].Columns)
{
}
foreach (DataRow row in result.Tables[0].Rows)
{
DataColumn col1 = result.Tables[0].Columns[0];
if (row[col1.ColumnName].ToString() != "")
{
if (home.QuestionIsVaild(row[col1.ColumnName].ToString(), SubId))
{
QuesDetail newQuestion = new QuesDetail();
OptionDetail newOPtion = new OptionDetail();
newQuestion.Question = row[col1.ColumnName].ToString();
DataColumn col2 = result.Tables[0].Columns[1];
newQuestion.OpCorrect = row[col2.ColumnName].ToString();
newQuestion.SubTopicId = SubId;
newQuestion.Active = true;
db.QuesDetails.Add(newQuestion);
db.SaveChanges();
questList = db.QuesDetails.ToList();
using (mocktestEntities1 context = new mocktestEntities1())
{
var quid = context.QuesDetails.Where(a => a.Question == newQuestion.Question & a.Active == true & a.SubTopicId == SubId).FirstOrDefault();
// quesId = quid.QuesDetailId;
//foreach (var item in questList)
//{
// if (item.Question.Equals(newQuestion.Question))
// {
// Qid = item.QuesDetailId;
// }
//}
newOPtion.QuesDetailId = quid.QuesDetailId;
}
DataColumn col3 = result.Tables[0].Columns[2];
newOPtion.OpOne = row[col3.ColumnName].ToString();
DataColumn col4 = result.Tables[0].Columns[3];
newOPtion.OpTwo = row[col4.ColumnName].ToString();
DataColumn col5 = result.Tables[0].Columns[4];
newOPtion.OpThree = row[col5.ColumnName].ToString();
DataColumn col6 = result.Tables[0].Columns[5];
newOPtion.OpFour = row[col6.ColumnName].ToString();
newOPtion.Active = true;
db.OptionDetails.Add(newOPtion);
db.SaveChanges();
setCount = 1;
}
else
{
continue;
}
}
}
}
if (setCount == 1)
{
ModelState.AddModelError("", "File Uploaded Successfully!");
check = true;
return(Json(check, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(check, JsonRequestBehavior.AllowGet));
}
}
