public static Documents GetById(int Id)
{
using (var context = new DocumentsContext())
{
Documents document = context.Documents.FirstOrDefault(d=> d.ID == Id);
return document;
}
}
public static List<Documents> GetAll()
{
using (var context = new DocumentsContext())
{
List<Documents> documents = context.Documents.ToList();
return documents;
}
}
public static bool Create(Documents document)
{
using (var context = new DocumentsContext())
{
context.Documents.Add(document);
return context.SaveChanges() > 0;
}
}
public static bool Update(Documents document)
{
using (var context = new DocumentsContext())
{
context.Documents.Attach(document);
context.Entry(document).State = EntityState.Modified;
return context.SaveChanges() > 0;
}
}
public static IList<Documents> Search(string doc_num, string cust_name, string nonconformity)
{
using (var context = new DocumentsContext())
{
IList<Documents> documents = context.Documents
.Where(d => d.DocNum == doc_num || d.CustName.Contains(cust_name) && d.Nonconformity.Contains(nonconformity)).ToList();
return documents;
}
}
public static bool Delete(int id)
{
using (var context = new DocumentsContext())
{
var asset = context.Documents.Find(id);
context.Documents.Remove(asset);
return context.SaveChanges() > 0;
}
}