/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IList<FinanceModel> RetrieveFinanceDetails(SearchFinanceModel model)
{
return new DataAccess.DataAccess().ExecuteReader<FinanceModel>("AVZ_FIN_spRetriveActivities", new
{
MerchantId = model.merchantId == null ? 0 : model.merchantId,
ActivityTypeId = model.activityTypeId == null ? 0 : model.activityTypeId,
DateOfActivity = model.dateOfActivity,
Affiliation = model.affiliationId == null ? 0 : model.affiliationId,
ProcessorId = model.processorId == null ? 0 : model.processorId
});
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IList<FinanceModel> RetrieveFinanceDetails(SearchFinanceModel model)
{
if (String.IsNullOrEmpty(model.dateOfActivity))
model.dateOfActivity = "0000-00-00";
else
{
DateTime dt = DateTime.ParseExact(model.dateOfActivity, "yyyy-MM-ddThh:mm:ss",
CultureInfo.InvariantCulture);
model.dateOfActivity = dt.ToString("yyyy-MM-dd");
}
return financeRepository.RetrieveFinanceDetails(model);
}
/// <summary>
/// Insert Finance detials in DB
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IList<FinanceModel> InsertFinanceDetails(SearchFinanceModel model)
{
return new DataAccess.DataAccess().ExecuteReader<FinanceModel>("AVZ_FIN_spUpdateActivities", new
{
MerchantId = model.merchantId,
ActivityTypeId = model.activityTypeId,
DateOfActivity = model.dateOfActivity,
Amount = model.amount,
ProcessorId = model.processorId,
Notes = string.IsNullOrEmpty(model.notes)? string.Empty : model.notes,
InsertUserId = model.insertUserId,
ContractId=model.contractId,
TransferContractId = model.transferContractId
});
}
/// <summary>
/// Insert Finance detials in DB
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IList<FinanceModel> InsertFinanceDetails(SearchFinanceModel model)
{
return financeRepository.InsertFinanceDetails(model);
}
public HttpResponseMessage SaveFinanceActivity(SearchFinanceModel financeModel)
{
IList<FinanceModel> response;
using (FinanceTier fT = new FinanceTier())
{
response = fT.InsertFinanceDetails(financeModel);
return this.Request.CreateResponse(HttpStatusCode.OK, response);
}
}
public HttpResponseMessage SearchFinanceActivity(SearchFinanceModel model)
{
IList<FinanceModel> response;
try
{
using (FinanceTier fT = new FinanceTier())
{
response = fT.RetrieveFinanceDetails(model);
}
return this.Request.CreateResponse(HttpStatusCode.OK, response);
}
catch (Exception ex)
{
//throw ex.Message;
}
return this.Request.CreateResponse(HttpStatusCode.OK);
}
