public Document[] GetAllDocumentPerson(int idperson)
{
try
{
using (var c = new Connect())
{
SqlConnection sqlconn = c.GetConnection();
var mapper = new DocumentDataMapper(sqlconn);
IEnumerable <Document> list = mapper.GetAll().Where(d => d.Person.Id == idperson);
return(list.ToArray());
}
}
catch (Exception exception)
{
throw new FaultException <ServerError>(new ServerError());
}
}
public void InsertDocument(Document doc)
{
try
{
using (var connect = new Connect())
{
connect.BeginTrx();
SqlConnection sqlconn = connect.GetConnection();
var docmapper = new DocumentDataMapper(sqlconn);
docmapper.SetTransaction(connect.Transaction);
docmapper.Insert(doc);
connect.Commit();
}
}
catch (Exception exception)
{
throw new FaultException <ServerError>(new ServerError());
}
}
public Document[] GetAllDocumentPerson(int idperson)
{
try
{
using (var c = new Connect())
{
SqlConnection sqlconn = c.GetConnection();
var mapper = new DocumentDataMapper(sqlconn);
IEnumerable<Document> list = mapper.GetAll().Where(d => d.Person.Id == idperson);
return list.ToArray();
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
public int InsertDocument(Document doc)
{
try
{
using (var connect = new Connect())
{
connect.BeginTrx();
SqlConnection sqlconn = connect.GetConnection();
var docmapper = new DocumentDataMapper(sqlconn);
docmapper.SetTransaction(connect.Transaction);
int ret = docmapper.Insert(doc);
connect.Commit();
return ret;
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
