public JsonResult Get(int pageIndex,
int pageSize,
string pageOrder,
int productID,
string fromDate,
string toDate,
List <int> groups
)
{
DateTime?sDate = null,
eDate = null;
if (!String.IsNullOrWhiteSpace(fromDate))
{
sDate = Utilities.ToEnglishDate(fromDate).Date;
}
if (!String.IsNullOrWhiteSpace(toDate))
{
eDate = Utilities.ToEnglishDate(toDate).Date;
}
var list = ProductVisits.Get(pageIndex,
pageSize,
pageOrder,
productID,
sDate,
eDate,
groups
);
int total = ProductVisits.Count(productID, sDate, eDate, groups);
int totalPage = (int)Math.Ceiling((decimal)total / pageSize);
if (pageSize > total)
{
pageSize = total;
}
if (list.Count < pageSize)
{
pageSize = list.Count;
}
JsonResult result = new JsonResult()
{
Data = new
{
TotalPages = totalPage,
PageIndex = pageIndex,
PageSize = pageSize,
Rows = list
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
return(result);
}
internal void IncProVisits(int ProductCode)
{
try
{
ProductVisits NewRecord = new ProductVisits();
dataContext.ProductVisits.InsertOnSubmit(NewRecord);
NewRecord.ProductCode = ProductCode;
NewRecord.VisitDate = DateTime.Now;
dataContext.SubmitChanges();
}
catch
{
}
}
