public IEnumerable <ReturnDetails> GetLastWeekWebReturnDetails() { using (new SharedConnection(dbConnection)) { var result = dbConnection.Query <ReturnDetails>(SqlLoader.GetSql("web returns performance")); return(result.Any() ? result : null); } }
public IEnumerable <DispatchDetails> GetLastWeekWebDispatchDetails() { using (new SharedConnection(dbConnection)) { var result = dbConnection.Query <DispatchDetails>(SqlLoader.GetSql("web despatch package peerformance")); return(result.Any() ? result : null); } }