/// <summary>
/// Date Created: 25/07/2011
/// Created By: Ryan Bautista
/// (description) hotel dashboard
/// </summary>
public static DataTable GetDashboardDetails(string DateFrom, string DateTo, string Port)
{
DataTable dt = null;
try
{
DateTime dtDateFrom = Convert.ToDateTime(DateFrom);
DateTime dtDateTo = Convert.ToDateTime(DateTo);
Int32 PortID = Convert.ToInt32(Port);
dt = DashboardDAL.GetDashboardDetails(dtDateFrom, dtDateTo, PortID);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
public List <DashboardDTO> GetDashboard(Dashboard _report)
{
List <DashboardDTO> result = new List <DashboardDTO>();
DashboardDAL cmd = new DashboardDAL();
switch (_report)
{
case Dashboard.AlunosPorEscola:
result = cmd.GetAlunosPorEscola();
break;
case Dashboard.AlunosPorBairro:
result = cmd.GetAlunosPorBairro();
break;
case Dashboard.AlunosPorProjeto:
result = cmd.GetAlunosPorProjeto();
break;
default:
break;
}
return(result);
}
/// <summary>
/// Date Created: 25/07/2011
/// Created By: Ryan Bautista
/// (description) hotel dashboard details
/// </summary>
public static DataTable GetHotelDashboardDetails(string BranchID, string DateFrom, string DateTo)
{
DataTable dt = null;
try
{
Int32 BranchIDInt = Convert.ToInt32(BranchID);
DateTime DteFrom = Convert.ToDateTime(DateFrom);
DateTime DteTo = Convert.ToDateTime(DateTo);
dt = DashboardDAL.GetHotelDashboardDetails(BranchIDInt, DteFrom, DteTo);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Author: Charlene Remotigue
/// Date Created: 14/11/2011
/// Description: get port agent port dashboard port
/// </summary>
/// <param name="portAgentId"></param>
/// <returns></returns>
public static DataTable GetPortAgentPortDashboardDetails(string portAgentId, string StartDate, string EndDate)
{
try
{
return(DashboardDAL.GetPortAgentPortDashboardDetails(Int32.Parse(portAgentId), DateTime.Parse(StartDate), DateTime.Parse(EndDate)));
}
catch (Exception ex)
{
throw ex;
}
}
// GET: Dashboard
public ActionResult Dashboard()
{
DataTable dt = obj.BindMenu();
List <DashboardDAL> objmenulist = new List <DashboardDAL>();
foreach (DataRow row in dt.Rows)
{
DashboardDAL objmenu = new DashboardDAL();
objmenu.MenuName = row["menu_name"].ToString();
objmenu.menu_path = row["menu_path"].ToString();
objmenulist.Add(objmenu);
}
// ViewData.Model = dt.AsEnumerable();
return(View(objmenulist.ToList()));
}
/// <summary>
/// Date Created: 25/07/2011
/// Created By: Ryan Bautista
/// (description) hotel dashboard details per week
/// </summary>
public static DataTable GetHotelDashboardDetailsWeek(string BranchID)
{
DataTable dt = null;
try
{
Int32 BranchIDInt = Convert.ToInt32(BranchID);
dt = DashboardDAL.GetHotelDashboardDetailsWeek(BranchIDInt);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
public static DataTable LoadHotelDashboardOverflowExport(String UserId)
{
return(DashboardDAL.LoadHotelDashboardOverflowExport(UserId));
}
/// <summary>
/// 今日游戏机排行榜
/// </summary>
/// <returns></returns>
public static List <TodayGameRevenueModel> GetTodyGameRevenue()
{
return(DashboardDAL.GetTodayGameRevenue());
}
/// <summary>
/// Author: Josephine Gad
/// Date Created: 07/Jan/2013
/// Description: Export Confirmed booking
/// ----------------------------------------
/// Author: Marco Abejar
/// Date Created: 08/April/2013
/// Description: Add Branch Param
/// ----------------------------------------
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public static DataTable LoadHotelDashboardConfirmedExport(String UserId, Int32 BranchId)
{
return(DashboardDAL.LoadHotelDashboardConfirmedExport(UserId, BranchId));
}
public int GetPendingSRVBillingClosureRequestCount(string empCode)
{
return(DashboardDAL.GetPendingSRVBillingClosureRequestCount(empCode));
}
public List <TotaisDashboardProduto> GetTotalizadorProduto(long idconta, long dias)
{
var a = DashboardDAL.GetTotaisDashboardProduto(idconta, dias);
return(a);
}
/// <summary>
/// 客流分析
/// </summary>
/// <returns></returns>
public static List <PassengerFlowModel> GetTodayPassengerFlow()
{
return(DashboardDAL.GetTodayPassengerFlow());
}
public int GetApprovedRequestCount(string empCode)
{
return(DashboardDAL.GetApprovedRequestCount(empCode));
}
public DataTable CityCount()
{
DashboardDAL dalDashboard = new DashboardDAL();
return(dalDashboard.CityCount());
}
public DataTable UserCount()
{
DashboardDAL dalDashboard = new DashboardDAL();
return(dalDashboard.UserCount());
}
public DataTable StateCount()
{
DashboardDAL dalDashboard = new DashboardDAL();
return(dalDashboard.StateCount());
}
public DataTable HospitalCount()
{
DashboardDAL dalDashboard = new DashboardDAL();
return(dalDashboard.HospitalCount());
}
public List <TotaisDashboardPorData> GetTotalizadorDiaDesagendamentos(long idconta, long dt_ini, long dt_fim)
{
var a = DashboardDAL.GetTotaisDashboardDiaDesagendamentos(idconta, dt_ini, dt_fim);
return(a);
}
public DashBoardBO()
{
dashBoardDAL = new DashboardDAL();
}
public List <Product> GetAllProductsInTheInventory()
{
var dal = new DashboardDAL();
return(dal.GetAllProductsInTheInventory());
}
public int GetInprocessRequestCount(string empCode)
{
return(DashboardDAL.GetInprocessRequestCount(empCode));
}
/// <summary>
/// 今日营收分析
/// </summary>
/// <returns></returns>
public static TodayRevenueModel GetTodayRevenue()
{
return(DashboardDAL.GetTodayRevenue());
}
public int GetTotalRequestCount(string empCode)
{
return(DashboardDAL.GetTotalRequestCount(empCode));
}
/// <summary>
/// 今日吧台营收
/// </summary>
/// <returns></returns>
public static List <TodayBarCounterRevenueModel> GetTodayBarCounterRevenue()
{
return(DashboardDAL.GetTodayBarCounterRevenue());
}
public List <PendingRequestModel> GetClosedRequest(string empCode)
{
return(DashboardDAL.GetClosedRequest(empCode));
}
public TotaisDashboard GetTotalizadorDia(long idconta, long dias)
{
var a = DashboardDAL.GetTotalizadorDia(idconta, dias);
return(a);
}
public DASHBOARDBLL(string FACTORY_CD)
{
dashboarddal = new DashboardDAL(FACTORY_CD);
}
/// <summary>
/// 今日营收总览,获取上一个营业日期的现金数与当前营业日期的现金数进行环比查询
/// </summary>
/// <returns></returns>
public static MOMModel GetMOM()
{
return(DashboardDAL.GetMOM());
}
