private static ReportColumn PopulateFromDBDetailsObject(ReportColumnDetails obj)
{
ReportColumn objNew = new ReportColumn();
objNew.ReportColumnId = obj.ReportColumnId;
objNew.ReportNo = obj.ReportNo;
objNew.TitleResource = obj.TitleResource;
objNew.ReportColumnFormatNo = obj.ReportColumnFormatNo;
objNew.HasSum = obj.HasSum;
objNew.HasCount = obj.HasCount;
objNew.HasAverage = obj.HasAverage;
objNew.HasPercentageOnSums = obj.HasPercentageOnSums;
objNew.PercentageNumeratorColumnIndex = obj.PercentageNumeratorColumnIndex;
objNew.PercentageDenominatorColumnIndex = obj.PercentageDenominatorColumnIndex;
objNew.SortOrder = obj.SortOrder;
return(objNew);
}
/// <summary>
/// GetListForReport
/// Calls [usp_selectAll_ReportColumn_for_Report]
/// </summary>
public override List <ReportColumnDetails> GetListForReport(System.Int32?reportNo)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_selectAll_ReportColumn_for_Report", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@ReportNo", SqlDbType.Int).Value = reportNo;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <ReportColumnDetails> lst = new List <ReportColumnDetails>();
while (reader.Read())
{
ReportColumnDetails obj = new ReportColumnDetails();
obj.ReportColumnId = GetReaderValue_Int32(reader, "ReportColumnId", 0);
obj.ReportNo = GetReaderValue_NullableInt32(reader, "ReportNo", null);
obj.TitleResource = GetReaderValue_String(reader, "TitleResource", "");
obj.ReportColumnFormatNo = GetReaderValue_NullableInt32(reader, "ReportColumnFormatNo", null);
obj.HasSum = GetReaderValue_Boolean(reader, "HasSum", false);
obj.HasCount = GetReaderValue_Boolean(reader, "HasCount", false);
obj.HasAverage = GetReaderValue_Boolean(reader, "HasAverage", false);
obj.HasPercentageOnSums = GetReaderValue_Boolean(reader, "HasPercentageOnSums", false);
obj.PercentageNumeratorColumnIndex = GetReaderValue_NullableInt32(reader, "PercentageNumeratorColumnIndex", null);
obj.PercentageDenominatorColumnIndex = GetReaderValue_NullableInt32(reader, "PercentageDenominatorColumnIndex", null);
obj.SortOrder = GetReaderValue_NullableInt32(reader, "SortOrder", null);
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get ReportColumns", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
