public Image GetImage(int id)
{
using (var surityDBContext = new SurityDBContext())
{
return(surityDBContext.Images.Where(x => x.Id == id).FirstOrDefault());
}
}
public List <Image> SearchImages(string requestNumber, string userName)
{
using (var surityDBContext = new SurityDBContext())
{
if (!string.IsNullOrEmpty(requestNumber) && !string.IsNullOrEmpty(userName))
{
return(surityDBContext.ImageUploadSessions.Include("image").Where(i =>
i.RequestNumber == requestNumber &&
i.UserName == userName
).Select(x => x.Image).ToList());
}
else if (!string.IsNullOrEmpty(requestNumber))
{
return(surityDBContext.ImageUploadSessions.Include("image").Where(i =>
i.RequestNumber == requestNumber
).Select(x => x.Image).ToList());
}
else if (!string.IsNullOrEmpty(userName))
{
return(surityDBContext.ImageUploadSessions.Include("image").Where(i =>
i.UserName == userName
).Select(x => x.Image).ToList());
}
return(new List <Image>());
}
}
public List <DigitalCertificate> Query()
{
using (var surityDBContext = new SurityDBContext())
{
return(surityDBContext.DigitalCertificate.ToList());
}
}
public void Add(ImageUploadSession imageUploadSession)
{
using (var surityDBContext = new SurityDBContext())
{
surityDBContext.ImageUploadSessions.Add(imageUploadSession);
surityDBContext.SaveChanges();
}
}
