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