public ActionResult feedbackfinish(ShelonFinish sf,
string HardLesson, string EasyLesson, string ColorEasy, string ColorHard, string eyes, string musical, string playMusic)
{
sessionOrNot();
using (amedilab_dataEntities entities = new amedilab_dataEntities())
{
ShelonFinish found = entities.ShelonFinishes.Where(usr => usr.user_id == _eyeMusicModel.userDAL.user_ID).SingleOrDefault();
if (found == null)
{
// User found in the database
if (eyes == " " || musical == " " || ColorEasy == " " || ColorHard == " " || sf.faces == null || sf.fun == null || sf.hard == null)
{
ModelState.AddModelError("", "please fill all ");
return(View("feedbackfinish"));
}
else
{
sf.user_id = _eyeMusicModel.userDAL.user_ID;
sf.HardColor = Int32.Parse(ColorHard);
sf.clearColor = Int32.Parse(ColorEasy);
if (eyes == "true")
{
sf.closeEyes = true;
}
else
{
sf.closeEyes = false;
}
if (musical == "true")
{
sf.musical = true;
}
else
{
sf.musical = false;
}
if (playMusic == "true")
{
sf.playMusic = true;
}
else
{
sf.playMusic = false;
}
sf.hard = HardLesson;
sf.easy = EasyLesson;
entities.ShelonFinishes.Add(sf);
entities.SaveChanges();
}
}
}
return(View("menustepExp", _eyeMusicModel));
}
public void addToDBStepByStep(object obj)
{
using (amedilab_dataEntities entities = new amedilab_dataEntities())
{
try
{
entities.stepByStep_user.Add((stepByStep_user)obj);
entities.SaveChanges();
}
catch (Exception e)
{
}
}
}
public void addtoDBFunny(object obj)
{
using (amedilab_dataEntities entities = new amedilab_dataEntities())
{
try
{
entities.StepByStepHappies.Add((StepByStepHappy)obj);
entities.SaveChanges();
}
catch (Exception e)
{
}
}
}
/// <summary>
/// Add new exam on specipic level and stage
/// </summary>
/// <param name="obj"></param>
private void addExamToDBUser(object obj)
{
using (amedilab_dataEntities entities = new amedilab_dataEntities())
{
try
{
exam addThis = obj as exam;
//found level by level_ID
addThis.level1 = (from levels in entities.levels
where levels.level1 == _eyeMusicModel.select_level
select levels).SingleOrDefault();
//found stage by stage_ID
addThis.stage1 = (from stages in entities.stages
where stages.stage1 == _eyeMusicModel.select_stage
select stages).SingleOrDefault();
entities.exams.Add((DAL.exam)obj);
entities.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (Exception e)
{
}
}
}
/// <summary>
/// add specipic question of question
/// </summary>
/// <param name="obj"></param>
private void AddToDBExamQ(object obj)
{
using (amedilab_dataEntities entities = new amedilab_dataEntities())
{
try
{
pic_paths the_path;
level lvl;
stage stg;
desacriptaion des;
desacriptaion des1;
desacriptaion des2;
desacriptaion des3;
int?maxlvl;
int?maxstg;
int?maxdes;
int?maxpath;
//check if this image already in DB
var picPathVar = entities.pic_paths.SingleOrDefault(usr => usr.pic_path == ((exam_q_levels)obj).pic_paths.pic_path);
if (picPathVar != null)
{
the_path = picPathVar;
}
else
{
//create row with image path
maxpath = entities.pic_paths.Max(usr => (int?)usr.id);
if (maxpath == null)
{
maxpath = 0;
}
the_path = new pic_paths();
the_path.id = (int)++maxpath;
the_path.pic_path = ((exam_q_levels)obj).pic_paths.pic_path;
//entities.levels.Add(lvl);
//entities.SaveChanges();
}
((exam_q_levels)obj).pic_paths = the_path;
//check if this level already in DB
var levelsVar = entities.levels.SingleOrDefault(usr => usr.level1 == ((exam_q_levels)obj).level.level1);
if (levelsVar != null)
{
lvl = levelsVar;
}
else
{
//create row for level
maxlvl = entities.levels.Max(usr => (int?)usr.id);
if (maxlvl == null)
{
maxlvl = 0;
}
lvl = new level();
lvl.id = (int)++maxlvl;
lvl.level1 = ((exam_q_levels)obj).level.level1;
//entities.levels.Add(lvl);
//entities.SaveChanges();
}
((exam_q_levels)obj).level = lvl;
//check if this stage already in DB
var stageVar = entities.stages.SingleOrDefault(usr => usr.stage1 == ((exam_q_levels)obj).stage.stage1);
if (stageVar != null)
{
stg = stageVar;
}
else
{
//add new row with stage
maxstg = entities.stages.Max(usr => (int?)usr.id);
if (maxstg == null)
{
maxstg = 0;
}
stg = new stage();
stg.id = (int)++maxstg;
stg.stage1 = ((exam_q_levels)obj).stage.stage1;
//entities.stages.Add(stg);
//entities.SaveChanges();
}
((exam_q_levels)obj).stage = stg;
//check if this four descriptions already in DB
var descVar = entities.desacriptaions.SingleOrDefault(usr => usr.desacriptaion1 == ((exam_q_levels)obj).desacriptaion.desacriptaion1);
if (descVar != null)
{
des = descVar;
maxdes = entities.desacriptaions.Max(usr => (int?)usr.id);
}
else
{
maxdes = entities.desacriptaions.Max(usr => (int?)usr.id);
if (maxdes == null)
{
maxdes = 0;
}
des = new desacriptaion();
des.id = (int)++maxdes;
des.desacriptaion1 = ((exam_q_levels)obj).desacriptaion.desacriptaion1;
}
((exam_q_levels)obj).desacriptaion = des;
//1
var descVar1 = entities.desacriptaions.SingleOrDefault(usr => usr.desacriptaion1 == ((exam_q_levels)obj).desacriptaion2.desacriptaion1);
if (descVar1 != null)
{
des1 = descVar1;
}
else
{
des1 = new desacriptaion();
des1.id = (int)++maxdes;
des1.desacriptaion1 = ((exam_q_levels)obj).desacriptaion1.desacriptaion1;
}
((exam_q_levels)obj).desacriptaion1 = des1;
//2
var descVar2 = entities.desacriptaions.SingleOrDefault(usr => usr.desacriptaion1 == ((exam_q_levels)obj).desacriptaion2.desacriptaion1);
if (descVar2 != null)
{
des2 = descVar2;
}
else
{
des2 = new desacriptaion();
des2.id = (int)++maxdes;
des2.desacriptaion1 = ((exam_q_levels)obj).desacriptaion2.desacriptaion1;
}
((exam_q_levels)obj).desacriptaion2 = des2;
//3
var descVar3 = entities.desacriptaions.SingleOrDefault(usr => usr.desacriptaion1 == ((exam_q_levels)obj).desacriptaion3.desacriptaion1);
if (descVar3 != null)
{
des3 = descVar3;
}
else
{
des3 = new desacriptaion();
des3.id = (int)++maxdes;
des3.desacriptaion1 = ((exam_q_levels)obj).desacriptaion3.desacriptaion1;
}
((exam_q_levels)obj).desacriptaion3 = des3;
entities.exam_q_levels.Add((exam_q_levels)obj);
entities.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (Exception e)
{
}
}
}
