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) { } } }