public File DownloadDocument(string Inn)
{
File file = null;
using (DBModel1 cm = new DBModel1())
{
documents doc = cm.Documents.FirstOrDefault(f => f.Inn == Inn);
if (doc != null)
{
file = new File()
{
Name = doc.FileName, Content = doc.Data
};
}
}
return(file);
}
public void UploadDocument(string Inn, File file)
{
using (DBModel1 cm = new DBModel1())
{
var doc = cm.Documents.FirstOrDefault(f => f.Inn == Inn);
if (doc != null)
{
cm.Documents.Remove(doc);
cm.SaveChanges();
}
doc = new documents();
doc.FileName = file.Name;
doc.Data = file.Content;
doc.Inn = Inn;
cm.Documents.Add(doc);
cm.SaveChanges();
}
}
public List <AppUser> GetByFilter(string Filter)
{
List <AppUser> lstUsers = new List <AppUser>();
using (DBModel1 cm = new DBModel1())
{
var qResult = (
from p in cm.People
join a in cm.Address on p.Inn equals a.Inn
where p.Surname.Contains(Filter) || p.Inn.Contains(Filter)
select new
{
p.Birthdate,
p.Firstname,
p.Inn,
p.Passport_num,
p.Passport_ser,
p.Patronymic,
p.Surname,
a.Address1
});
foreach (var res in qResult)
{
lstUsers.Add(new AppUser()
{
Address = res.Address1,
Birthdate = res.Birthdate,
Firstname = res.Firstname,
Inn = res.Inn,
Passport_num = res.Passport_num,
Passport_ser = res.Passport_ser,
Patronymic = res.Patronymic,
Surname = res.Surname
});
}
}
return(lstUsers);
}
