/// <summary> /// <c>The GetObject method getting data from the database based on SqlCommand</c> /// </summary> /// <typeparam name="T"><c>T isGeneric datatype</c></typeparam> /// <param name="environment"><c>environment is either dev, stag or prod</c></param> /// <param name="cmd"><c>cmd is SqlCommand</c></param> /// <param name="itemFactory">itemFactory is Delegate object</param> /// <param name="connString">connString is client connection string</param> /// <returns>returns the IList generic object</returns> internal static IList <T> GetObjects <T>(string environment, SqlCommand cmd, ItemFactoryDelegate itemFactory, string connString) { SqlConnection connection = cmd.Connection ?? new SqlConnection(connString); SqlDataReader reader = null; IList <T> result = new List <T>(); try { connection.Open(); cmd.Connection = connection; reader = cmd.ExecuteReader(); while (reader.Read()) { result.Add((T)itemFactory(reader)); } } catch (Exception e) { Util.SendErrorMail("healthywayz", e.Message + ';' + e.StackTrace); throw e; } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(result); }
/// <summary> /// <c>The GetObject method getting data from the database based on SqlCommand</c> /// </summary> /// <typeparam name="T"><c>T isGeneric datatype</c></typeparam> /// <param name="environment"><c>environment is either dev, stag or prod</c></param> /// <param name="cmd"><c>cmd is SqlCommand</c></param> /// <param name="itemFactory">itemFactory is Delegate object</param> /// <returns>returns the IList generic object</returns> internal static T GetObject <T>(string environment, SqlCommand cmd, ItemFactoryDelegate itemFactory) { IList <T> obj = GetObjects <T>(environment, cmd, itemFactory); if (obj.Count > 0) { return(obj[0]); } return(default(T)); }
/// <summary> /// <c>The GetObject method data from the database based on SqlCommand</c> /// </summary> /// <typeparam name="T"><c>T isGeneric datatype</c></typeparam> /// <param name="environment"><c>environment is either dev, stag or prod</c></param> /// <param name="cmd"><c>cmd is SqlCommand</c></param> /// <param name="itemFactory">itemFactory is Delegate object</param> /// <returns>returns the IList generic object</returns> internal static List <T> GetObjects <T>(string environment, SqlCommand cmd, ItemFactoryDelegate itemFactory) { SsConnection ssconn = SSDAL.Instance.ConnService.GetClientConnection(environment); SqlConnection connection = cmd.Connection ?? new SqlConnection(ssconn.EnterpriseConnectionString); SqlDataReader reader = null; var result = new List <T>(); try { connection.Open(); cmd.Connection = connection; reader = cmd.ExecuteReader(); while (reader.Read()) { result.Add((T)itemFactory(reader)); } } catch (Exception e) { Util.SendErrorMail("SiteManagement", e.Message + ';' + e.StackTrace); throw e; } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(result); }
/// <summary> /// <c>The GetSortedObjects method getting sorted data from the database based on SqlCommand</c> /// </summary> /// <typeparam name="TKey">TKey is sorted key value</typeparam> /// <typeparam name="TValue">TValue is sorted values</typeparam> /// <param name="environment"><c>environment is either dev, stag or prod</c></param> /// <param name="cmd"><c>cmd is SqlCommand</c></param> /// <param name="itemFactory">itemFactory is Delegate object</param> /// <returns>returns the IDictionary generic object</returns> internal static IDictionary <TKey, TValue> GetSortedObjects <TKey, TValue>(string environment, SqlCommand cmd, ItemFactoryDelegate itemFactory) { SsConnection ssconn = SSDAL.Instance.ConnService.GetClientConnection(environment); SqlConnection connection = cmd.Connection ?? new SqlConnection(ssconn.EnterpriseConnectionString); SqlDataReader reader = null; IDictionary <TKey, TValue> result = new Dictionary <TKey, TValue>(); try { connection.Open(); cmd.Connection = connection; reader = cmd.ExecuteReader(); while (reader.Read()) { result.Add((TKey)reader[0], (TValue)itemFactory(reader)); } } catch (Exception e) { Util.SendErrorMail("healthywayz", e.Message + ';' + e.StackTrace); throw e; } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(result); }