public static DataTable Get(StoredProcedures.Procedures procedure) { string procedureName = GetProcedureName(procedure); if (procedureName == null) { return(null); } SqlCommand cmd = DbConnect.ConnectionDatabase.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = procedureName; cmd.CommandTimeout = DbConnect.ConnectionTimeout; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable data = new DataTable(); DbConnect.OpenConnection(); da.Fill(data); DbConnect.CloseConnection(); return(data); }
private static string GetProcedureName(StoredProcedures.Procedures procedure) { foreach (var item in StoredProcedures.StoredProcedure) { if (item.Key == procedure) { return(item.Value); } } return(null); }