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