public static ResponResultViewModel Create(VersionViewModel entity, long userid) { //Create n Version + 1 ResponResultViewModel result = new ResponResultViewModel(); try { using (var db = new MinProContext()) { t_version version = new t_version(); version.version = entity.version; version.created_by = userid; version.created_on = DateTime.Now; version.is_delete = false; foreach (var quiz in entity.questions) { t_version_detail vd = new t_version_detail(); vd.version_id = version.id; vd.question_id = quiz.id; vd.created_by = userid; vd.created_on = DateTime.Now; db.t_version_detail.Add(vd); } db.t_version.Add(version); db.SaveChanges(); result.Entity = entity; } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }
public static List <VersionViewModel> All(long userid) { List <VersionViewModel> result = new List <VersionViewModel>(); using (var db = new MinProContext()) { result = (from c in db.t_version where c.is_delete == false orderby c.version descending select new VersionViewModel { id = c.id, version = c.version }).Take(1).ToList(); if (result.Count == 0) { t_version version = new t_version(); version.version = 1; version.created_by = userid; version.created_on = DateTime.Now; version.is_delete = false; db.t_version.Add(version); db.SaveChanges(); result = (from c in db.t_version where c.is_delete == false select new VersionViewModel { id = c.id, version = c.version }).ToList(); } } return(result); }
public static ResponResultViewModel Delete(VersionViewModel entity, long userid) { //Delete Version ResponResultViewModel result = new ResponResultViewModel(); try { using (var db = new MinProContext()) { t_version version = db.t_version.Where(o => o.id == entity.id).FirstOrDefault(); if (version != null) { version.version = entity.version; version.deleted_by = userid; version.deleted_on = DateTime.Now; version.is_delete = true; db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.Message = "Version not Found!"; } } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }