public async Task <string> GetAgencySupplierResponse(AgencySupplierResponseEntity message)
{
try
{
message.SearchDateTime = DateTime.Now;
int minToAdd = 20;
using (var _ctx = new MediationEntities())
{
const string sql = @"EXEC [dbo].[spGetAgencySupplierResponse]
@AgencyCode
,@SearchDateTime
,@Key
,@Status
,@SupplierCode
,@MinutesToAdd
";
var result = _ctx.Database
.SqlQuery <SpBaseEntity>(
sql
, new SqlParameter("AgencyCode", message.AgencyCode)
, new SqlParameter("SearchDateTime", message.SearchDateTime)
, new SqlParameter("Key", message.Key)
, new SqlParameter("Status", message.Status)
, new SqlParameter("SupplierCode", message.SupplierCode)
, new SqlParameter("MinutesToAdd", minToAdd)
).FirstOrDefault();
if (result == null)
{
result.Data = null;
}
if (result.StatusCode != "OK-200")
{
result.Data = null;
}
return(result.Data);
}
}
catch (Exception ex)
{
return(null);
}
}
private async Task <string> GetSupplierResponseFromDb(Models.Rootobject model, string supplierCode, string key)
{
AgencySupplierResponseEntity addSupplierDetails = new AgencySupplierResponseEntity();
try
{
DateTime currentDateTime = DateTime.Now;
addSupplierDetails.AgencyCode = model.CommonRequestSearch.AgencyCode;
addSupplierDetails.SearchDateTime = currentDateTime;
addSupplierDetails.Key = key;
addSupplierDetails.Status = 1;
addSupplierDetails.SupplierCode = supplierCode;
string response = await supplierAgencyServices.GetAgencySupplierResponse(addSupplierDetails);
return(response);
}
catch (Exception ex)
{
return(null);
}
}
