Summary of "time" column

Question

Hello,how to make summary of column which contains time in format HH:mm:ss?Time is formatted through SQL query as result of some calculations.

Sindhu Nagarajan · Answer

Hi Josip, 

Thanks for your interest in Syncfusion products. 

We are able to understand your requirement. By default, GridGroupingControl does not have direct support to calculate summary (aggregate functions) for DateTime values. However, the reported scenario can be achieved by writing custom summary inherited from SummaryBase class. We have prepared a simple sample as per your requirement.  In the attached sample, we have added summary to calculate the total time of the column. Please refer to the below code and sample, 

Code Snippet 




class DateTimeSummary : SummaryBase 
{     
    public static ITreeTableSummary CreateSummaryMethod(SummaryDescriptor summaryDescriptor, Record record) 
    { 
        object obj = summaryDescriptor.GetValue(record); 
        bool isNull = (obj == null || obj is DBNull); 
        if (isNull) 
            return Empty; 
        else 
        { 
            return new DateTimeSummary(obj.ToString()); 
        } 
    } 
    public DateTimeSummary Combine(DateTimeSummary other) 
    { 
 
        TimeSpan s1; 
        TimeSpan s2; 
        TimeSpan.TryParse(this.Total, out s1); 
        TimeSpan.TryParse(other.Total, out s2); 
        TimeSpan s3 = s1.Add(s2); 
 
        return new DateTimeSummary(s3.ToString()); 
    } 
} 
 
private void GridGroupingControl1_QueryCustomSummary(object sender, GridQueryCustomSummaryEventArgs e) 
{ 
    if( e.SummaryColumn.Name== "TotalTimeSpan") 
     { 
         e.SummaryDescriptor.CreateSummaryMethod = new CreateSummaryDelegate(DateTimeSummary.CreateSummaryMethod); 
     } 
} 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS-763675796 

Please let us know if you have any other queries. 

Regards, 
Sindhu

Josip · Answer

Hi Josip, 

Thanks for your interest in Syncfusion products. 

We are able to understand your requirement. By default, GridGroupingControl does not have direct support to calculate summary (aggregate functions) for DateTime values. However, the reported scenario can be achieved by writing custom summary inherited from SummaryBase class. We have prepared a simple sample as per your requirement.  In the attached sample, we have added summary to calculate the total time of the column. Please refer to the below code and sample, 

Code Snippet 




class DateTimeSummary : SummaryBase 
{     
    public static ITreeTableSummary CreateSummaryMethod(SummaryDescriptor summaryDescriptor, Record record) 
    { 
        object obj = summaryDescriptor.GetValue(record); 
        bool isNull = (obj == null || obj is DBNull); 
        if (isNull) 
            return Empty; 
        else 
        { 
            return new DateTimeSummary(obj.ToString()); 
        } 
    } 
    public DateTimeSummary Combine(DateTimeSummary other) 
    { 
 
        TimeSpan s1; 
        TimeSpan s2; 
        TimeSpan.TryParse(this.Total, out s1); 
        TimeSpan.TryParse(other.Total, out s2); 
        TimeSpan s3 = s1.Add(s2); 
 
        return new DateTimeSummary(s3.ToString()); 
    } 
} 
 
private void GridGroupingControl1_QueryCustomSummary(object sender, GridQueryCustomSummaryEventArgs e) 
{ 
    if( e.SummaryColumn.Name== "TotalTimeSpan") 
     { 
         e.SummaryDescriptor.CreateSummaryMethod = new CreateSummaryDelegate(DateTimeSummary.CreateSummaryMethod); 
     } 
} 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS-763675796 

Please let us know if you have any other queries. 

Regards, 
Sindhu  Colud you check sample link, I have problem with downloding it.

Sindhu Nagarajan · Answer

Hi Josip, 

Sorry for the inconvenience caused. 

Please find the sample from the below link, 

Sample Link: GridGroupingControlSample 

Regards, 
Sindhu

Josip · Answer

Hi Josip, 

Sorry for the inconvenience caused. 

Please find the sample from the below link, 

Sample Link: GridGroupingControlSample 

Regards, 
Sindhu  Thank you! It's working now.Just one more question; I'm trying to convert result in format to show only hours minutes and seconds on this way:TimeSpan s1;TimeSpan s2;TimeSpan.TryParse(this.Total, out s1);TimeSpan.TryParse(other.Total, out s2);TimeSpan s3 = s1.Add(s2);string retVal = string.Format("{0}hr {1}mn {2}sec",                     (int)s3.TotalHours,                     s3.Minutes,                     s3.Seconds);return new DateTimeSummary(retVal);But as result I get only 00:00:00So if the result is two day I want to show as 48:00:00

Mohanraj Gunasekaran · Answer

Hi Josip,  
 
Thanks for your update. 
 
In order to display the total hours instead of days in summary cell, you can use the QueryCellStyleInfo event to make this kind of changes. Please refer to the below code example and the sample, 
 
Code example 




this.gridGroupingControl1.QueryCellStyleInfo += GridGroupingControl1_QueryCellStyleInfo; 
private void GridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e) 
{ 
    if (e.Style.TableCellIdentity.DisplayElement.Kind == DisplayElementKind.Summary && e.Style.TableCellIdentity.SummaryColumn != null && e.Style.TableCellIdentity.SummaryColumn.DisplayColumn == "Date") 
    { 
        TimeSpan time; 
        if (TimeSpan.TryParse(e.Style.CellValue.ToString(), out time)) 
        { 
            e.Style.CellValue = String.Format("{0}:{1}:{2}", Convert.ToInt16(time.TotalHours), time.Minutes, time.Seconds); 
        } 
    } 
} 
 
Sample link: GridGroupingControl 
 
Regards, 
Mohanraj G

Josip · Answer

This is it! Thank you very much!

Mohanraj Gunasekaran · Answer

Hi Josip, 
 
Thanks for your update. 
 
We are glad to know that your reported problem has resolved. 
 
Please let us know if you have any concerns. 
 
Regards, 
Mohanraj G