public MSI_MediaRequestResponse AddMediaRequestResponse(MSI_MediaRequestResponse submittedRequest)
{
string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name);
string logMessage = string.Format("{0}|Method incoming parameters AccountNumber={1}", thisMethod, submittedRequest.ACCOUNT);
LogHelper.Info(logMessage);
MSI_MediaRequestResponseRepository repository = new MSI_MediaRequestResponseRepository();
try
{
repository.Add(submittedRequest);
}
catch (System.Data.Entity.Validation.DbEntityValidationException validationException)
{
foreach (System.Data.Entity.Validation.DbEntityValidationResult errorResult in validationException.EntityValidationErrors)
{
foreach (System.Data.Entity.Validation.DbValidationError error in errorResult.ValidationErrors)
{
ErrorLogHelper.Error(error.ErrorMessage, validationException);
}
}
}
catch (Exception ex)
{
ErrorLogHelper.Error(logMessage, ex);
}
return submittedRequest;
}
public IEnumerable<MSI_MediaRequestResponse> GetMediaRequestResponses(string agency, Guid userId)
{
string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name);
string logMessage = string.Format("{0}|Method incoming parameters agency={1}, userId={2}", thisMethod, agency, userId.ToString());
LogHelper.Info(logMessage);
IEnumerable<MSI_MediaRequestResponse> data = null;
MSI_MediaRequestResponseRepository repository = new MSI_MediaRequestResponseRepository();
try
{
if (string.IsNullOrEmpty(agency))
data = repository.GetAll();
else
data = from requestResponse in repository.GetAll().Where(record => record.AgencyId == agency)
select requestResponse;
}
catch (Exception ex)
{
ErrorLogHelper.Error(logMessage, ex);
}
return data;
}
public MSI_MediaRequestResponse GetMediaRequestResponse(string accountNumber, string agency, Guid userId)
{
string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name);
string logMessage = string.Format("{0}|Method incoming parameters accountNumber={1}, agency={2}, userId={3}", thisMethod, accountNumber, agency, userId.ToString());
LogHelper.Info(logMessage);
MSI_MediaRequestResponse data = null;
MSI_MediaRequestResponseRepository repository = new MSI_MediaRequestResponseRepository();
try
{
if (string.IsNullOrEmpty(agency))
data = repository.GetAll().Where(record => (record.ACCOUNT == accountNumber || record.OriginalAccount == accountNumber) && record.RequestedByUserId == userId).SingleOrDefault();
else
data = repository.GetAll().Where(record => (record.ACCOUNT == accountNumber || record.OriginalAccount == accountNumber) && record.AgencyId == agency).SingleOrDefault();
}
catch (Exception ex)
{
ErrorLogHelper.Error(logMessage, ex);
}
return data;
}
public IEnumerable<MSI_MediaRequestResponse> GetMediaRequestResponses()
{
string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name);
string logMessage = string.Format("{0}", thisMethod);
LogHelper.Info(logMessage);
IEnumerable<MSI_MediaRequestResponse> data = null;
MSI_MediaRequestResponseRepository repository = new MSI_MediaRequestResponseRepository();
try
{
data = from requestResponse in repository.GetAll()
select requestResponse;
}
catch (Exception ex)
{
ErrorLogHelper.Error(logMessage, ex);
}
return data;
}
public MSI_MediaRequestResponse GetMediaRequestResponse(string id)
{
string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name);
string logMessage = string.Format("{0}|Method incoming parameters id={1}", thisMethod, id);
LogHelper.Info(logMessage);
MSI_MediaRequestResponse data = null;
MSI_MediaRequestResponseRepository repository = new MSI_MediaRequestResponseRepository();
try
{
data = repository.GetById(id);
}
catch (Exception ex)
{
ErrorLogHelper.Error(logMessage, ex);
}
return data;
}
