private void SetReaderToObject(ref OrganizationScale objOrganizationScale, ref SqlDataReader result)
{
if (result.HasRows)
{
objOrganizationScale.OrganizationScaleID = (int)result.GetValue(result.GetOrdinal("OrganizationScaleID"));
objOrganizationScale.OrganizationScaleName = result.GetValue(result.GetOrdinal("OrganizationScaleName")).ToString();
objOrganizationScale.OrganizationScaleSample = result.GetValue(result.GetOrdinal("OrganizationScaleSample")).ToString();
}
}
/// <summary>
/// Clones the specified LST OrganizationScale.
/// </summary>
/// <param name="lstOrganizationScale">The LST OrganizationScale.</param>
/// <returns>List<OrganizationScale></returns>
static public List <OrganizationScale> Clone(List <OrganizationScale> lstOrganizationScale)
{
List <OrganizationScale> lstCOrganizationScale = new List <OrganizationScale>();
foreach (OrganizationScale objOrganizationScale in lstOrganizationScale)
{
lstCOrganizationScale.Add(OrganizationScale.Clone(objOrganizationScale));
}
return(lstCOrganizationScale);
}
private List <OrganizationScale> GetOrganizationScaleList(string strSprocName, string strWhere, string strOrderBy)
{
List <OrganizationScale> OrganizationScales = new List <OrganizationScale>();
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
try
{
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = strSprocName;
command.Parameters.Add(dbconn.GenerateParameterObj("@strWhere", SqlDbType.VarChar, strWhere, 1000));
command.Parameters.Add(dbconn.GenerateParameterObj("@strOrderBy", SqlDbType.VarChar, strOrderBy, 1000));
result = command.ExecuteReader();
while (result.Read())
{
OrganizationScale objOrganizationScale = new OrganizationScale();
SetReaderToObject(ref objOrganizationScale, ref result);
OrganizationScales.Add(objOrganizationScale);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(OrganizationScales);
}
/// <summary>
/// Clones the specified object OrganizationScale.
/// </summary>
/// <param name="objOrganizationScale">The object OrganizationScale.</param>
/// <returns>OrganizationScale</returns>
static public OrganizationScale Clone(OrganizationScale objOrganizationScale)
{
OrganizationScale objCOrganizationScale = new OrganizationScale(objOrganizationScale.OrganizationScaleID);
return(objCOrganizationScale);
}