// This method will get column names which has totals and type of totals....
public static List <ColumnTotals> Listoftotals(string tot)
{
List <ColumnTotals> totals = new List <ColumnTotals>();
ColumnTotals tt;
// To check fot totals........
if (tot != null)
{
foreach (string whole in tot.Split(','))
{
tt = new ColumnTotals();
tt.Totaltype = whole.Split('@')[1];
tt.ColumnName = whole.Split('@')[0];
totals.Add(tt);
}
}
return(totals);
}
// this method will get all the header totals required for KPI and dashboard
public static List <ColumnTotals> GetHeaderValues(string name, string section)
{
IEnumerable <tbl_ReportTotal> reptotals = DbContext.tbl_ReportTotals.Where(s => s.Report_Name == name & s.Report_Type == section);
List <ColumnTotals> totals = new List <ColumnTotals>();
try
{
foreach (tbl_ReportTotal t1 in reptotals)
{
foreach (string individual in t1.Report_Totals.ToString().Split(','))
{
ColumnTotals c1 = new ColumnTotals();
string[] seperator = individual.Split('@', '#');
c1.Friendlyname = seperator[0];
c1.Totaltype = seperator[1];
c1.ColumnName = seperator[2];
totals.Add(c1);
}
}
}
catch { }
return(totals);
}