public ActionResult Index()
{
var login = SKtimeManagement.Login.Get(UserID);
object model;
string view;
var isAjax = Request.IsAjaxRequest();
if (login.Name == "admin" || login.Type == LoginType.Office)
{
view = isAjax ? Views.SummaryAdminPartial : Views.SummaryAdmin;
model = SummaryAdmin.Get(Employee.BussinessID);
}
else
{
view = isAjax ? Views.SummaryPartial : Views.Summary;
model = Summary.Get(Employee.ID, Employee.BussinessID, UserID);
}
if (isAjax)
{
return(Json(new
{
html = RenderPartialViewToString(view, model)
}, JsonRequestBehavior.AllowGet));
}
return(View(view, model));
}
public static SummaryAdmin Get(int bussinessID)
{
try
{
using (var con = Repo.DB.SKtimeManagement)
{
var now = DateTime.Now;
var result = new SummaryAdmin();
result.Logs = con.Query <Log>(
String.Format(
@"select top 100 l.*, e.Name as [EmployeeName]
from Log l join Employee e on l.EmployeeID = e.ID
where e.BussinessID = {0} and (Action like N'%create%' or Action like N'%modify%' or Action like N'%remove%')
order by l.ID desc", bussinessID)).ToList();
result.PopularProductsByQuantity = con.Query <Popular>(
String.Format(
@"select top 100 e.ProductID as [ID], p.Name, sum(e.Quantity) as [TotalQuantity], sum(e.Quantity * e.Price) as [Revenue]
from ExportProduct e join Product p on e.ProductID = p.ID
where p.BussinessID = {0} and e.OrderID is not null group by e.ProductID, p.Name
order by sum(e.Quantity) desc",
bussinessID)).ToList();
result.PopularTagsByQuantity = con.Query <Popular>(
String.Format(
@"select top 100 t.Name, sum(e.Quantity) as [TotalQuantity], sum(e.Quantity * e.Price) as [Revenue]
from Tag t join ProductTag pt on t.ID = pt.TagID join ExportProduct e on pt.ProductID = e.ProductID join Product p on e.ProductID = p.ID
where p.BussinessID = 1 and e.OrderID is not null
group by t.Name order by sum(e.Quantity) desc",
bussinessID)).ToList();
result.PendingExports = con.Query <ExportRecord>(
String.Format(
@"select e.ID, e.EmployeeID, e.BussinessID, e.WarehouseID, e.Code, e.SubmitDate, e.Note, e.Status, e.ToWarehouseID, tw.Name as [ToWarehouseName], w.Name as [WarehouseName], em.Name as [EmployeeName]
from Export e
join Warehouse w on e.WarehouseID = w.ID and w.Status = 'active'
join Employee em on e.EmployeeID = em.ID
join ExportProduct p on e.ID = p.ExportID
join Warehouse tw on e.ToWarehouseID = tw.ID and tw.Status = 'active'
where e.BussinessID = {0} and e.Removed = 0 and e.Status <> N'{1}'
group by e.ID, e.EmployeeID, e.BussinessID, e.WarehouseID, e.Code, e.SubmitDate, e.Note, e.Status, e.ToWarehouseID, tw.Name, w.Name, em.Name
order by e.ID desc", bussinessID, ExportStatus.Exported)).ToList();
return(result);
}
}
catch
{
return(new SummaryAdmin());
}
}
