public async Task <IEnumerable <usp_ReturnUserSavedReports_Result> > SavedReports(string userId)
{
var parameters = new[]
{
new SqlParameter("@user_name", userId)
};
var repo = new GenericRepository <usp_ReturnUserSavedReports_Result>(_context);
return(await repo.ExecuteStoredProcedureAsync("usp_ReturnUserSavedReports", parameters));
}
public async Task <IEnumerable <UspReturnMatchedTradesConfirms> > ReturnMatchedTradesConfirms(string userName, int tdTrade)
{
var tradeDetailParam = new[]
{
new SqlParameter("@user_name", userName),
new SqlParameter("@tdTrade", tdTrade)
};
var repo = new GenericRepository <UspReturnMatchedTradesConfirms>(_context);
return(await repo.ExecuteStoredProcedureAsync(
"usp_ReturnMatchedTradesConfirms", tradeDetailParam));
}
public async Task <IEnumerable <UspReturnTradeNotifyList> > GetNotifyList(string userName, int tdTrade)
{
var param = new[]
{
new SqlParameter("@user_name", userName),
new SqlParameter("@tdTrade", tdTrade)
};
var repo = new GenericRepository <UspReturnTradeNotifyList>(_context);
return(await repo.ExecuteStoredProcedureAsync(
"usp_ReturnTradeNotifyList", param));
}
public async Task <IEnumerable <usp_ReturnPackageMaintenanceListHome> > NotificationJobStatus(string userId)
{
var parameters = new[]
{
new SqlParameter("@userId", userId),
new SqlParameter("@NotificationOnly", true)
};
var repo = new GenericRepository <usp_ReturnPackageMaintenanceListHome>(_context);
var notificationStatus = await repo.ExecuteStoredProcedureAsync("usp_ReturnPackageMaintenanceListHome", parameters);
return(notificationStatus);
}
public async Task <IEnumerable <usp_returnBulkCopyOptions_Result> > BulkEditCommentExecute(string selectedTrades, string bulkComment, string bulkCommentType, string userName)
{
var parameters = new[]
{
new SqlParameter("@tdTradeList", selectedTrades),
new SqlParameter("@user_name", userName),
new SqlParameter("@bulkData", bulkComment),
new SqlParameter("@bulkColumn", bulkCommentType)
};
var repo = new GenericRepository <usp_returnBulkCopyOptions_Result>(_context);
return(await repo.ExecuteStoredProcedureAsync("usp_returnBulkCopyOptions", parameters));
}
public async void SaveToFileStore(string fileName, IEnumerable fileImage, string userId, string fileType,
string tdTradeList)
{
var parameters = new[] {
new SqlParameter("@user_name", userId),
new SqlParameter("@FileName", fileName),
new SqlParameter("@FileDate", DateTime.Now),
new SqlParameter("@FileContent", fileImage),
new SqlParameter("@FileType", fileType.Split('/').Last()),
new SqlParameter("@tdTradeList", tdTradeList)
};
var tdmsDataAccess = new GenericRepository <usp_InsertTradesAttachment_Result>(_context);
await tdmsDataAccess.ExecuteStoredProcedureAsync("usp_InsertTradesAttachment", parameters);
}
