public IQueryable<KnowledgeViewModel> Read()
{
List<KnowledgeViewModel> ret = new List<KnowledgeViewModel>();
var qry = db.KnowledgeBase;
foreach (KnowledgeBase o in qry)
{
KnowledgeViewModel k = new KnowledgeViewModel();
k.FileAddr = o.FileAddr;
k.FileName = o.FileName;
k.KnowledgeID = o.KnowledgeID;
k.Version = o.Version;
ret.Add(k);
}
return ret.AsQueryable();
}
public bool Update(KnowledgeViewModel knowledgeViewModel)
{
bool ret = false;
try
{
KnowledgeBase k = db.KnowledgeBase.Find(knowledgeViewModel.KnowledgeID);
k.FileAddr = knowledgeViewModel.FileAddr;
k.FileName = knowledgeViewModel.FileName;
//k.Version = 1;
//db.KnowledgeBase.Add(k);
db.SaveChanges();
ret = true;
}
catch
{
}
return ret;
}
public bool Create(KnowledgeViewModel knowledgeViewModel)
{
bool ret = false;
try
{
KnowledgeBase k = new KnowledgeBase();
k.KnowledgeID = db.KnowledgeBase.AsEnumerable().Select(x => x.KnowledgeID).DefaultIfEmpty(0).Max(x => x) + 1;
k.FileAddr = knowledgeViewModel.FileAddr;
k.FileName = knowledgeViewModel.FileName;
k.Version = 1;
db.KnowledgeBase.Add(k);
db.SaveChanges();
ret = true;
}
catch
{
}
return ret;
}
public bool Delete(KnowledgeViewModel knowledgeViewModel)
{
bool ret = false;
try
{
KnowledgeBase k = db.KnowledgeBase.Find(knowledgeViewModel.KnowledgeID);
db.KnowledgeBase.Remove(k);
db.SaveChanges();
ret = true;
}
catch
{
}
return ret;
}
