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