public virtual T TCommitData <T>(List <T> list, string proc, char action, short instance = 1, string ignoreParas = "") { string fields = string.Empty; DataTable table = CreateDataTable(list, ignoreParas); var para = DataTableToSqlParameterArray(table, action, ref fields); try { using (TransactionScope scope = new TransactionScope()) { try { DapperConfiguration.OpenConnection(instance); var data = (T)DapperConfiguration.db.Query <T>(proc, para, commandType: System.Data.CommandType.StoredProcedure); DapperConfiguration.CloseConnection(); scope.Complete(); return(data); } catch (Exception ex) { Logger.LogError(ex); return(default(T)); } } } catch (Exception ex) { Logger.LogError(ex); return(default(T)); } }
public async Task <List <Slider> > GetAll() { using (TransactionScope scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled)) { //A transactionscope must be disposed on the same thread that it was created try { DapperConfiguration.OpenConnection(1); var data = await DapperConfiguration.db.QueryAsync <Slider>("usp_spa_Slider", new { Id = GlobalVariables.IsTransParameter }, commandType : System.Data.CommandType.StoredProcedure); DapperConfiguration.CloseConnection(); scope.Complete(); return(data.ToList()); } catch (Exception ex) { Logger.LogError(ex); return(null); } } }
public List <PostStateHistory> GetAll() { using (TransactionScope scope = new TransactionScope()) { try { DapperConfiguration.OpenConnection(1); var data = DapperConfiguration.db.Query <PostStateHistory>("usp_PostStateHistory", commandType: System.Data.CommandType.StoredProcedure).ToList(); DapperConfiguration.CloseConnection(); scope.Complete(); return(data); } catch (Exception ex) { LogHelper.WriteLog("Execute Category get data: " + ex.Message); return(null); } } }
public List <Advertise> GetAll() { using (TransactionScope scope = new TransactionScope()) { try { DapperConfiguration.OpenConnection(1); var data = DapperConfiguration.db.Query <Advertise>("usp_spa_Advertise", new { Id = GlobalVariables.IsTransParameter }, commandType: System.Data.CommandType.StoredProcedure).ToList(); DapperConfiguration.CloseConnection(); scope.Complete(); return(data); } catch (Exception ex) { Logger.LogError(ex); return(null); } } }
public Configuration GetById(byte id) { using (TransactionScope scope = new TransactionScope()) { try { DapperConfiguration.OpenConnection(1); var data = DapperConfiguration.db.Query <Configuration>("usp_spa_CMSConfig", new { Id = id }, commandType: System.Data.CommandType.StoredProcedure).FirstOrDefault(); DapperConfiguration.CloseConnection(); scope.Complete(); return(data); } catch (Exception ex) { Logger.LogError(ex); return(null); } } }