public bool CreateSAResponse(SAResponseDAO s) { SAResponse sAResponse = new SAResponse { SAResponse_ID = s.SAResponseID, SAResponseDescription = s.SAResponseDescription }; using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { db.SAResponses.InsertOnSubmit(sAResponse); try { db.SubmitChanges(); } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } } return true; }
public IList<SAResponseDAO> GetSAResponses() { try { using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { IList<SAResponse> sAResponses = (from saResponse in db.SAResponses select saResponse).OrderBy(o => o.SAResponse_ID).ToList(); List<SAResponseDAO> result = new List<SAResponseDAO>(); foreach (var sAResponse in sAResponses) { SAResponseDAO temp = new SAResponseDAO { ID = sAResponse.SAResponse_ID, SAResponseID = sAResponse.SAResponse_ID, SAResponseDescription = sAResponse.SAResponseDescription }; result.Add(temp); } return (result != null ? result : null); } } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } }
public bool UpdateSAResponse(SAResponseDAO newSAResponse) { using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { SAResponse sAResponse = db.SAResponses.Single(s => s.SAResponse_ID == newSAResponse.SAResponseID); sAResponse.SAResponse_ID = newSAResponse.SAResponseID; sAResponse.SAResponseDescription = newSAResponse.SAResponseDescription; try { db.SubmitChanges(); } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } } return true; }
public SAResponseDAO GetSAResponseByID(int id) { try { using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { SAResponse sAResponse = (from sarpns in db.SAResponses where sarpns.SAResponse_ID == id select sarpns).FirstOrDefault(); SAResponseDAO result = new SAResponseDAO { ID = sAResponse.SAResponse_ID, SAResponseID = sAResponse.SAResponse_ID, SAResponseDescription = sAResponse.SAResponseDescription }; return (result != null ? result : null); } } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } }