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