public static object VisitorLoadCommand(int startIndex, int maximumRows, string sortExpressions)
{
Dictionary <string, object> result = new Dictionary <string, object>();
result["Data"] = IEnumerableExtentionMethods.GetSegmentList(VisitorSubDomainList, startIndex, maximumRows, sortExpressions);
result["Count"] = VisitorSubDomainList.Count();
return(result);
}
public static object Search(string tungay, string denngay, int startIndex, int maximumRows, string sortExpressions)
{
Guid subId = SessionHelper.GetSession(SessionKey.SubDomain) == string.Empty ? Guid.Empty : new Guid(SessionHelper.GetSession(SessionKey.SubDomain));
string query = string.Empty;
query = @"SELECT sb.[Description] as Title ,COUNT([SubDomainId]) as ViewTime FROM [Log] l right join SubDomain sb on l.[SubDomainId]=sb.Id where 1=1";
query += " and l.[SubDomainId] is not null";
if (!(subId == Guid.Empty))
{
query += " and [SubDomainId] ='" + subId + "'";
}
if (tungay != string.Empty && denngay != string.Empty)
{
DateTime dateStart = DateTime.Parse(tungay, new System.Globalization.DateTimeFormatInfo {
ShortDatePattern = "dd/MM/yyyy"
});
denngay += " 23:59:59 PM";
DateTime dateEnd = DateTime.Parse(denngay, new System.Globalization.DateTimeFormatInfo {
ShortDatePattern = "dd/MM/yyyy"
});
query += " and l.LogTime>='" + dateStart + "'";
query += " and l.LogTime<= '" + dateEnd + "'";
}
query += " group by l.[SubDomainId],sb.[Description]";
query += " order by ViewTime Desc";
VisitorSubDomainList = new List <VisitorSubDomain>();
using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PSCPortalConnectionString"].ConnectionString))
{
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand();
command.CommandText = string.Format(query);
command.CommandType = System.Data.CommandType.Text;
command.Connection = con;
con.Open();
System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
VisitorSubDomain itemp = new VisitorSubDomain();
itemp.Title = (string)reader["Title"];
itemp.ViewTime = (int)reader["ViewTime"];
VisitorSubDomainList.Add(itemp);
}
}
Dictionary <string, object> result = new Dictionary <string, object>();
try
{
result["Data"] = IEnumerableExtentionMethods.GetSegmentList(VisitorSubDomainList, startIndex, maximumRows, sortExpressions);
result["Count"] = VisitorSubDomainList.Count();
}
catch (Exception)
{
throw;
}
return(result);
}
public static object Search(string tungay, string denngay, int startIndex, int maximumRows, string sortExpressions)
{
Guid subId = SessionHelper.GetSession(SessionKey.SubDomain) == string.Empty ? Guid.Empty : new Guid(SessionHelper.GetSession(SessionKey.SubDomain));
if (subId == Guid.Empty)
{
DisplayArticleList = ArticleList.ToList();
}
else
{
DisplayArticleList = new List <Article>();
PSCPortal.Engine.SubDomain subDomain = new PSCPortal.Engine.SubDomain {
Id = subId
};
PageCollection listPage = subDomain.GetPagesBelongTo();
foreach (var item in listPage)
{
foreach (var article in ArticleList.Where(ar => ar.PageId == item.Id))
{
DisplayArticleList.Add(article);
}
}
}
if (tungay != string.Empty && denngay != string.Empty)
{
IFormatProvider provider = new System.Globalization.CultureInfo("en-CA", true);
DateTime startDate = DateTime.Parse(tungay, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault);
DateTime endDate = DateTime.Parse(denngay, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault);
DisplayArticleList = DisplayArticleList.Where(ar => ar.CreatedDate >= startDate && ar.CreatedDate <= endDate).ToList <Article>();
}
Dictionary <string, object> result = new Dictionary <string, object>();
try
{
result["Data"] = IEnumerableExtentionMethods.GetSegmentList(DisplayArticleList, startIndex, maximumRows, sortExpressions);
result["Count"] = DisplayArticleList.Count();
}
catch (Exception)
{
throw;
}
return(result);
}
