public void LoadCruiseAvaialability() { var dateSearching = txtDateSearching.Text; var from = DateTime.Today; if (!String.IsNullOrEmpty(dateSearching)) { try { from = DateTime.ParseExact(dateSearching, "dd/MM/yyyy", CultureInfo.InvariantCulture); } catch { txtDateSearching.Text = ""; } } //Tạo danh sách 15 ngày tới var to = from.AddDays(15); var dateRange = new List <DateTime>(); var current = from; while (current < to) { dateRange.Add(current); current = current.AddDays(1); } //-- RoomsAvaiableDTO = DashBoardManagerBLL.CruiseGetRoomsAvaiableInDateRange(from, to); rptCruiseAvaibility.DataSource = dateRange; rptCruiseAvaibility.DataBind(); }
public Agency AgencyGetById(string agencyId) { var agencyIdAsInt = 0; try { agencyIdAsInt = Int32.Parse(agencyId); } catch { } return(DashBoardManagerBLL.AgencyGetById(agencyIdAsInt)); }
protected void rptCruiseAvaibility_ItemDataBound(object sender, RepeaterItemEventArgs e) { var cruises = DashBoardManagerBLL.CruiseGetAll(); var dateSearching = new DateTime(); try { dateSearching = DateTime.ParseExact(txtDateSearching.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); } catch { } if (e.Item.ItemType == ListItemType.Header) { var ltrHeader = (Literal)e.Item.FindControl("ltrHeader"); var header = ""; foreach (var cruise in cruises) { header += "<th style='width:10%'>" + (cruise.Code != null ? cruise.Code.ToUpper() : "") + "</th>"; } ltrHeader.Text = header; } if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var date = (DateTime)e.Item.DataItem; var className = date.Date == dateSearching.Date ? "--high-light" : ""; var ltrRow = (Literal)e.Item.FindControl("ltrRow"); var rowItems = "<td class=" + className + ">" + "<a href=BookingReport.aspx?NodeId=1&SectionId=15&date=" + date.ToString("dd/MM/yyyy") + ">" + date.ToString("dd/MM/yyyy") + "</a>" + "</td>"; var defaultClassName = className; foreach (var cruise in cruises) { var numberOfRoom = RoomsAvaiableDTO.Where(x => DateTimeUtil.EqualsUpToSeconds(x.Date, date) && x.CruiseId == cruise.Id).First().TotalRoom; var numberOfRoomAvaiable = RoomsAvaiableDTO.Where(x => DateTimeUtil.EqualsUpToSeconds(x.Date, date) && x.CruiseId == cruise.Id).First().NoRAvaiable; double percentOfRoomAvailable = (numberOfRoomAvaiable / numberOfRoom); if (percentOfRoomAvailable == 1) { className = "td__no-room-using"; } if (numberOfRoomAvaiable > 0) { rowItems += "<td class='" + className + "'>" + numberOfRoomAvaiable + "</td>"; } else { rowItems += "<td class='td__not-avaiable'>" + numberOfRoomAvaiable + "</td>"; } className = defaultClassName; } ; var row = string.Format("<tr>{0}</tr>", rowItems); ltrRow.Text = row; } }
public void LoadAgenciesSendNoBookingLast3Month() { var salesId = 0; try { salesId = Int32.Parse(ddlSales.SelectedValue); } catch { } var agenciesSendNoBookingLast3Month = DashBoardManagerBLL.GetAgenciesSendNoBookingLast3Month(salesId).OrderByDescending(x => x.LastBookingDate).ToList(); rptAgenciesSendNoBookingLast3Months.DataSource = agenciesSendNoBookingLast3Month; rptAgenciesSendNoBookingLast3Months.DataBind(); }
public void LoadAgenciesNotVisitedOrUpdatedLast2Month() { var salesId = 0; try { salesId = Int32.Parse(ddlAgenciesNotVisitedSearchSales.SelectedValue); } catch { } var agenciesNotVisitedUpdated = DashBoardManagerBLL.GetAgenciesNotVistedUpdatedLast2Month(salesId).OrderBy(x => x.LastMeetingDate).ToList(); rptAgenciesNotVisitedUpdated.DataSource = agenciesNotVisitedUpdated; rptAgenciesNotVisitedUpdated.DataBind(); }
/// <summary> /// Load meetings theo sales được create trong 7 ngày gần nhất /// </summary> public void LoadRecentMeetings() { var salesId = 0; try { salesId = Int32.Parse(ddlRecentMeetingSearchSales.SelectedValue); } catch { } var from = DateTime.Today.AddDays(-7); var to = DateTime.Today; var recentMeetings = DashBoardManagerBLL.ActivityGetAllRecentMeetingsInDateRange(salesId, from, to).OrderByDescending(a => a.DateMeeting).ToList(); rptRecentMeetings.DataSource = recentMeetings; rptRecentMeetings.DataBind(); }
private void LoadTopAgencies() { var month = 1; try { month = Int32.Parse(ddlMonthTopPartner.SelectedValue); } catch { } var from = new DateTime(DateTime.Today.Year, month, 1); var to = from.AddMonths(1).AddDays(-1); var top10Agencies = DashBoardManagerBLL.AgencyGetTop10(from, to); rptTop10Partner.DataSource = top10Agencies; rptTop10Partner.DataBind(); ddlMonthTopPartner.SelectedValue = month.ToString(); }
protected void Page_Unload(object sender, EventArgs e) { if (userBLL != null) { userBLL.Dispose(); userBLL = null; } if (dashBoardManagerBLL != null) { dashBoardManagerBLL.Dispose(); dashBoardManagerBLL = null; } if (permissionBLL != null) { permissionBLL.Dispose(); permissionBLL = null; } }
protected void Page_Load(object sender, EventArgs e) { CheckAccess(); if (!IsPostBack) { var from = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1); var to = from.AddMonths(1).AddDays(-1); LoadSalesMonthSummary(from, to); ddlMonthSearching.Items.AddRange(Enumerable.Range(1, 12).Select(x => new ListItem() { Text = DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(x), Value = x.ToString() }).ToArray()); ddlYearSearching.Items.AddRange(Enumerable.Range(2008, 50).Select(x => new ListItem() { Text = x.ToString(), Value = x.ToString() }).ToArray()); ddlMonthSearching.SelectedValue = DateTime.Today.Month.ToString(); ddlYearSearching.SelectedValue = DateTime.Today.Year.ToString(); LoadCruiseAvaialability(); LoadBookingReport(); var sales = DashBoardManagerBLL.SalesGetAll(); ddlSales.DataTextField = "UserName"; ddlSales.DataValueField = "Id"; ddlSales.DataSource = sales.Where(s => s.IsUsedInDashBoardManager == true); ddlSales.DataBind(); ddlRecentMeetingSearchSales.DataTextField = "UserName"; ddlRecentMeetingSearchSales.DataValueField = "Id"; ddlRecentMeetingSearchSales.DataSource = sales.Where(s => s.IsUsedInDashBoardManager == true); ddlRecentMeetingSearchSales.DataBind(); ddlAgenciesNotVisitedSearchSales.DataTextField = "UserName"; ddlAgenciesNotVisitedSearchSales.DataValueField = "Id"; ddlAgenciesNotVisitedSearchSales.DataSource = sales.Where(s => s.IsUsedInDashBoardManager == true); ddlAgenciesNotVisitedSearchSales.DataBind(); ddlMonthTopPartner.Items.AddRange(Enumerable.Range(1, 12).Select(x => new ListItem() { Text = DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(x), Value = x.ToString() }).ToArray()); ddlMonthTopPartner.SelectedValue = DateTime.Today.Month.ToString(); LoadAgenciesSendNoBookingLast3Month(); LoadRecentMeetings(); LoadAgenciesNotVisitedOrUpdatedLast2Month(); LoadTopAgencies(); } }
public void LoadSalesMonthSummary(DateTime from, DateTime to) { var salesMonthSummary = DashBoardManagerBLL.GetSalesMonthSummary(from, to); rptSales.DataSource = salesMonthSummary; rptSales.DataBind(); rptNoOfPax2Days.DataSource = salesMonthSummary; rptNoOfPax2Days.DataBind(); rptNoOfPax3Days.DataSource = salesMonthSummary; rptNoOfPax3Days.DataBind(); rptNoOfBookings.DataSource = salesMonthSummary; rptNoOfBookings.DataBind(); rptRevenueInUSD.DataSource = salesMonthSummary; rptRevenueInUSD.DataBind(); rptMeetingReports.DataSource = salesMonthSummary; rptMeetingReports.DataBind(); rptTotalPax.DataSource = salesMonthSummary; rptTotalPax.DataBind(); }
public AgencyContact AgencyContactGetById(int agencyContactId) { return(DashBoardManagerBLL.AgencyContactGetById(agencyContactId)); }
public IEnumerable <Booking> GetNewBookings(DateTime date) { return(DashBoardManagerBLL.BookingGetAllNewBookings(date)); }
public IEnumerable <Booking> GetCancelledBookings(DateTime date) { return(DashBoardManagerBLL.BookingGetAllCancelledBookingOnDate(date)); }