public JsonResult fileUpload(string questiontypeid)
{
string errormsg = string.Empty;
int resultforsave = 0;
var data = Request.Files[0];
bool fileerror = false;
if (!Request.Files[0].ContentType.Contains("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"))
{
errormsg = "Please select Excel file only.";
fileerror = true;
}
if (fileerror == false)
{
#region Excel FIle upload
//string orgid = Session["OrgId"].ToString();
string orgid = User.OrgId;
string path = string.Empty;
//FileStream stream = new FileStream(data.FileName, FileMode.Open, FileAccess.Read);
Excel.IExcelDataReader excelReader;
excelReader = Excel.ExcelReaderFactory.CreateOpenXmlReader(data.InputStream);
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet();
EPortal.Models.Question question = null;
EPortal.Models.QuestionOption questionoption = null;
EPortal.Models.QuestionAnswar questionanswar = null;
EPortal.Models.QuestionsourceGroup questionsourcegroup = null;
List <EPortal.Models.Question> questionlist = new List <Question>();
List <EPortal.Models.QuestionOption> questionoptionlist = new List <QuestionOption>();
List <EPortal.Models.QuestionAnswar> questionanswarlist = new List <QuestionAnswar>();
List <EPortal.Models.QuestionsourceGroup> questionsourcegoruplist = new List <QuestionsourceGroup>();
using (EPortalEntities entity = new EPortalEntities())
{
if (result.Tables.Count > 0)
{
string sourceid = string.Empty;
string questiontext = string.Empty;
foreach (var item in result.Tables[0].Rows)
{
var source = ((System.Data.DataRow)item).ItemArray[0].ToString();
if (source != "")
{
var sourceobj = (from s in entity.Questionsources
where s.QuestionTypeId == questiontypeid &&
s.OrganizationID == orgid &&
s.SourceCode == source
select s).FirstOrDefault();
if (sourceobj != null)
{
sourceid = sourceobj.Id;
}
else
{
sourceid = "";
errormsg = "One or more source is invalid.";
}
}
#region Question
questiontext = ((System.Data.DataRow)item).ItemArray[1].ToString();
question = new Question();
question.Id = Guid.NewGuid().ToString();
question.Question1 = questiontext;
question.QuestionTypeId = questiontypeid;
question.SourceId = sourceid == "" ? null : sourceid;
int questionmarksindex = ((System.Data.DataRow)item).ItemArray.Count() - 1;
var questionmarks = ((System.Data.DataRow)item).ItemArray[questionmarksindex].ToString();
question.QuestionMarks = questionmarks == "" ? 1 : Convert.ToInt16(questionmarks);
question.OrganizationID = orgid;
question.RowState = true;
question.CreateDateTime = System.DateTime.Now;
entity.Questions.Add(question);
//questionlist.Add(question);
#endregion
#region Question Source
if (sourceid != "")
{
questionsourcegroup = new QuestionsourceGroup();
questionsourcegroup.Id = Guid.NewGuid().ToString();
questionsourcegroup.QuestionId = question.Id;
questionsourcegroup.QuestionSourceId = sourceid;
questionsourcegroup.OrganizationID = orgid;
questionsourcegroup.RowState = true;
questionsourcegroup.CreateDateTime = System.DateTime.Now;
entity.QuestionsourceGroups.Add(questionsourcegroup);
//questionsourcegoruplist.Add(questionsourcegroup);
}
#endregion
if (questiontext == "")
{
errormsg = "One or more Question is invalid.";
}
int columncount = ((System.Data.DataRow)item).ItemArray.Count() - 2;
int count = 1;
for (int i = 2; i <= columncount - 1; i++)
{
string optiontext = ((System.Data.DataRow)item).ItemArray[i].ToString();
if (optiontext != "")
{
#region Question Option
questionoption = new QuestionOption();
questionoption.Id = Guid.NewGuid().ToString();
questionoption.QuestionId = question.Id;
questionoption.QuestionOption1 = optiontext;
questionoption.OrganizationID = orgid;
questionoption.RowState = true;
questionoption.CreateDateTime = System.DateTime.Now;
questionoption.SequenceNo = count;
entity.QuestionOptions.Add(questionoption);
//questionoptionlist.Add(questionoption);
#endregion
#region Question Answar
int questionanansindex = ((System.Data.DataRow)item).ItemArray.Count() - 2;
string anstext = ((System.Data.DataRow)item).ItemArray[questionanansindex].ToString();
if ((Convert.ToInt16(anstext) + 1) == i)
{
questionanswar = new QuestionAnswar();
questionanswar.Id = Guid.NewGuid().ToString();
questionanswar.QuestionId = question.Id;
questionanswar.QuestionAnswarId = questionoption.Id;
questionanswar.OrganizationID = orgid;
questionanswar.RowState = true;
questionanswar.CreateDateTime = System.DateTime.Now;
entity.QuestionAnswars.Add(questionanswar);
//questionanswarlist.Add(questionanswar);
}
#endregion
count = count + 1;
}
}
}
}
else
{
errormsg = "Selected file is empty.No Data found.";
}
if (errormsg == string.Empty)
{
resultforsave = entity.SaveChanges();
}
}
#endregion
}
return(Json(new { result = resultforsave > 0 ? true : false, errormsg = errormsg }, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveQuestion(List <QuestionOptionList> optionlist, Questionobj question)
{
int result = 0;
//string orgid = Session["OrgId"].ToString();
string orgid = User.OrgId;
EPortal.Models.Question questionmodel = new Question();
EPortal.Models.QuestionOption questionoptionmodel = null;
List <EPortal.Models.QuestionOption> questionoptionmodellist = new List <QuestionOption>();
EPortal.Models.QuestionAnswar questionanswer = null;
EPortal.Models.QuestionsourceGroup questionsourcegroup = null;
List <EPortal.Models.QuestionAnswar> questionanswerlist = new List <QuestionAnswar>();
using (EPortalEntities entity = new EPortalEntities())
{
if (question.QuestionId == "" || question.QuestionId == null)
{
#region For Insert
questionmodel.Id = Guid.NewGuid().ToString();
questionmodel.Question1 = question.QuestionInfo;
questionmodel.QuestionTypeId = question.QuestionTyeId;
questionmodel.QuestionMarks = question.QuestionMark;
questionmodel.HaveMultiAns = question.HaveMultiAns;
if (question.QuestionSourceId != "0")
{
questionmodel.SourceId = question.QuestionSourceId;
}
else
{
questionmodel.SourceId = null;
}
questionmodel.OrganizationID = orgid;
questionmodel.RowState = true;
questionmodel.CreateDateTime = DateTime.Now;
entity.Entry(questionmodel).State = System.Data.Entity.EntityState.Added;
entity.Questions.Add(questionmodel);
if (question.QuestionSourceId != "0" && question.QuestionSourceId != null)
{
questionsourcegroup = new QuestionsourceGroup();
questionsourcegroup.Id = Guid.NewGuid().ToString();
questionsourcegroup.QuestionId = questionmodel.Id;
questionsourcegroup.QuestionSourceId = question.QuestionSourceId;
questionsourcegroup.OrganizationID = orgid;
questionsourcegroup.RowState = true;
questionsourcegroup.CreateDateTime = DateTime.Now;
entity.Entry(questionsourcegroup).State = System.Data.Entity.EntityState.Added;
entity.QuestionsourceGroups.Add(questionsourcegroup);
}
int count = 0;
foreach (QuestionOptionList item in optionlist)
{
questionoptionmodel = new QuestionOption();
questionoptionmodel.Id = Guid.NewGuid().ToString();
questionoptionmodel.QuestionId = questionmodel.Id;
questionoptionmodel.QuestionOption1 = item.OptionText;
questionoptionmodel.SequenceNo = count;
questionoptionmodel.OrganizationID = orgid;
questionoptionmodel.RowState = true;
questionoptionmodel.CreateDateTime = DateTime.Now;
entity.Entry(questionoptionmodel).State = System.Data.Entity.EntityState.Added;
entity.QuestionOptions.Add(questionoptionmodel);
if (item.Selected == true)
{
questionanswer = new QuestionAnswar();
questionanswer.Id = Guid.NewGuid().ToString();
questionanswer.QuestionId = questionmodel.Id;
questionanswer.QuestionAnswarId = questionoptionmodel.Id;
questionanswer.OrganizationID = orgid;
questionanswer.RowState = true;
questionanswer.CreateDateTime = DateTime.Now;
entity.Entry(questionanswer).State = System.Data.Entity.EntityState.Added;
entity.QuestionAnswars.Add(questionanswer);
}
count = count + 1;
}
#endregion
}
else
{
questionmodel = (from q in entity.Questions
where q.OrganizationID == orgid &&
q.Id == question.QuestionId
select q).FirstOrDefault();
if (questionmodel != null)
{
questionmodel.Question1 = question.QuestionInfo;
questionmodel.QuestionMarks = question.QuestionMark;
questionmodel.HaveMultiAns = question.HaveMultiAns;
entity.Entry(questionmodel).State = System.Data.Entity.EntityState.Modified;
}
int count = 0;
foreach (var item in optionlist)
{
var existdata = (from qo in entity.QuestionOptions
where qo.OrganizationID == orgid &&
qo.QuestionId == question.QuestionId &&
qo.Id == item.OptionId
select qo).FirstOrDefault();
if (existdata != null)
{
count = existdata.SequenceNo.HasValue ? existdata.SequenceNo.Value : 0;
existdata.QuestionOption1 = item.OptionText;
entity.Entry(existdata).State = System.Data.Entity.EntityState.Modified;
var checkans = (from qa in entity.QuestionAnswars
where qa.OrganizationID == orgid &&
qa.QuestionId == question.QuestionId &&
qa.QuestionAnswarId == item.OptionId
select qa).FirstOrDefault();
if (checkans != null)
{
if (item.Selected == true)
{
entity.Entry(checkans).State = System.Data.Entity.EntityState.Modified;
}
else
{
entity.Entry(checkans).State = System.Data.Entity.EntityState.Deleted;
}
}
else
{
if (item.Selected == true)
{
questionanswer = new QuestionAnswar();
questionanswer.Id = Guid.NewGuid().ToString();
questionanswer.QuestionId = question.QuestionId;
questionanswer.QuestionAnswarId = item.OptionId;
questionanswer.OrganizationID = orgid;
questionanswer.RowState = true;
questionanswer.CreateDateTime = DateTime.Now;
entity.Entry(questionanswer).State = System.Data.Entity.EntityState.Added;
entity.QuestionAnswars.Add(questionanswer);
}
}
}
else
{
questionoptionmodel = new QuestionOption();
questionoptionmodel.Id = Guid.NewGuid().ToString();
questionoptionmodel.QuestionId = questionmodel.Id;
questionoptionmodel.QuestionOption1 = item.OptionText;
questionoptionmodel.SequenceNo = count + 1;
questionoptionmodel.OrganizationID = orgid;
questionoptionmodel.RowState = true;
questionoptionmodel.CreateDateTime = DateTime.Now;
entity.Entry(questionoptionmodel).State = System.Data.Entity.EntityState.Added;
entity.QuestionOptions.Add(questionoptionmodel);
if (item.Selected == true)
{
questionanswer = new QuestionAnswar();
questionanswer.Id = Guid.NewGuid().ToString();
questionanswer.QuestionId = questionmodel.Id;
questionanswer.QuestionAnswarId = questionoptionmodel.Id;
questionanswer.OrganizationID = orgid;
questionanswer.RowState = true;
questionanswer.CreateDateTime = DateTime.Now;
entity.Entry(questionanswer).State = System.Data.Entity.EntityState.Added;
entity.QuestionAnswars.Add(questionanswer);
}
count = count + 1;
}
}
}
result = entity.SaveChanges();
}
return(Json(result > 0 ? true : false, JsonRequestBehavior.AllowGet));
}