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()); } }