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