void HienThi()
{
a.OpenConnection();
SqlDataAdapter sda1 = new SqlDataAdapter("select count(*) from Sach", a.strConn);
DataTable dt = new DataTable();
sda1.Fill(dt);
DashBoardBLL dashBoardBLL = new DashBoardBLL();
SachLbl.Text = dt.Rows[0][0].ToString();
SqlDataAdapter sda2 = new SqlDataAdapter("select count(*) from DocGia", a.strConn);
DataTable dt2 = new DataTable();
sda2.Fill(dt2);
DocGiaLbl.Text = dt2.Rows[0][0].ToString();
SqlDataAdapter sda3 = new SqlDataAdapter("select count(*) from NhanVien", a.strConn);
DataTable dt3 = new DataTable();
sda3.Fill(dt3);
NhanVienLbl.Text = dt3.Rows[0][0].ToString();
SqlDataAdapter sda4 = new SqlDataAdapter("select count(*) from ChiTiet_MuonTra WHERE DaTra != 1", a.strConn);
DataTable dt4 = new DataTable();
sda4.Fill(dt4);
MuonSachLbl.Text = dt4.Rows[0][0].ToString();
SqlDataAdapter sda5 = new SqlDataAdapter("select count(*) from ChiTiet_MuonTra WHERE DaTra = 1", a.strConn);
DataTable dt5 = new DataTable();
sda5.Fill(dt5);
TraSachLbl.Text = dt5.Rows[0][0].ToString();
a.CloseConnection();
}
public void LoadCruiseAvaialability()
{
var dateSearching = txtDateSearching.Text;
var from = DateTime.Today.AddDays(1);
if (!String.IsNullOrEmpty(dateSearching))
{
try
{
from = DateTime.ParseExact(dateSearching, "dd/MM/yyyy", CultureInfo.InvariantCulture).AddDays(-3);
}
catch
{
txtDateSearching.Text = "";
}
}
//Tạo danh sách 7 ngày tới
var to = from.AddDays(7);
var dateRange = new List <DateTime>();
var current = from;
while (current < to)
{
dateRange.Add(current);
current = current.AddDays(1);
}
//--
RoomsAvaiableDTO = DashBoardBLL.CruiseGetRoomsAvaiableInDateRange(from, to);
rptCruiseAvaibility.DataSource = dateRange;
rptCruiseAvaibility.DataBind();
}
public new void Dispose()
{
if (dashBoardBLL != null)
{
dashBoardBLL.Dispose();
dashBoardBLL = null;
}
}
protected void Page_Unload(object sender, EventArgs e)
{
if (dashBoardBLL != null)
{
dashBoardBLL.Dispose();
dashBoardBLL = null;
}
}
public Agency AgencyGetById(string agencyId)
{
var agencyIdAsInt = 0;
try
{
agencyIdAsInt = Int32.Parse(agencyId);
}
catch { }
return(DashBoardBLL.AgencyGetById(agencyIdAsInt));
}
protected void btnExport_Click(object sender, EventArgs e)
{
var document = new Document();
var builder = new DocumentBuilder(document);
var activities = GetRecentMeetings().OrderByDescending(a => a.DateMeeting).ToList();
var sales = activities.Select(x => x.User).Distinct().ToList();
for (int i = 0; i < sales.Count(); i++)
{
var needInsertSalesHeader = true;
for (int j = 0; j < activities.Count(); j++)
{
var activity = activities[j] as Activity;
var uniqueSales = sales[i];
var salesInActivity = activity.User;
if (uniqueSales.Id != salesInActivity.Id)
{
continue;
}
var contact = DashBoardBLL.AgencyContactGetById(activity.ObjectId);
var contactName = contact != null ? contact.Name : "";
var contactPosition = contact != null ? contact.Position : "";
var dateMeeting = activity.DateMeeting.ToString("dd/MM/yyyy");
var agencyId = 0;
try
{
agencyId = Int32.Parse(activity.Params);
}
catch { }
var agency = DashBoardBLL.AgencyGetById(agencyId);
var agencyName = agency != null ? agency.Name : "";
var note = activity.Note;
var salesName = uniqueSales.FullName;
InsertTableActivityToDocument(builder, needInsertSalesHeader, dateMeeting, salesName, contactName, contactPosition, agencyName, note);
needInsertSalesHeader = false;
}
}
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/ms-word";
Response.AppendHeader("content-disposition", "attachment; filename=" + string.Format("Meetings.doc"));
MemoryStream m = new MemoryStream();
document.Save(m, SaveFormat.Doc);
Response.OutputStream.Write(m.GetBuffer(), 0, m.GetBuffer().Length);
Response.OutputStream.Flush();
Response.OutputStream.Close();
m.Close();
Response.End();
}
protected void rptCruiseAvaibility_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
var cruises = DashBoardBLL.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>";
foreach (var cruise in cruises)
{
var numberOfRoomAvaiable = RoomsAvaiableDTO.Where(x => DateTimeUtil.EqualsUpToSeconds(x.Date, date) && x.CruiseId == cruise.Id).First().NoRAvaiable;
if (numberOfRoomAvaiable > 0)
{
rowItems += "<td class='" + className + "'>" + numberOfRoomAvaiable + "</td>";
}
else
{
rowItems += "<td class='td__not-avaiable'>" + numberOfRoomAvaiable + "</td>";
}
}
;
var row = string.Format("<tr>{0}</tr>", rowItems);
ltrRow.Text = row;
}
}
public IEnumerable <Activity> GetRecentMeetings()
{
var from = DateTime.Today.AddDays(-10);
try
{
from = DateTime.ParseExact(txtFromRecentMeetingSearch.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
catch { }
var to = DateTime.Today;
try
{
to = DateTime.ParseExact(txtToRecentMeetingSearch.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
catch { }
return(DashBoardBLL.ActivityGetAllRecentMeetingsInDateRange(CurrentUser, from, to));
}
protected void Page_Unload(object sender, EventArgs e)
{
if (dashBoardBLL != null)
{
dashBoardBLL.Dispose();
dashBoardBLL = null;
}
if (permissionBLL != null)
{
permissionBLL.Dispose();
permissionBLL = null;
}
if (userBLL != null)
{
userBLL.Dispose();
userBLL = null;
}
}
public static DashBoardBLL GetData(SessionDataBLL Obj)
{
using (var dbContext = new BSSDBEntities())
{
var Total = dbContext.SpTotalCount(Obj.DealerID, Obj.AccountId).FirstOrDefault();
var Delivered = dbContext.SpDeliveredCount(Obj.DealerID, Obj.AccountId).FirstOrDefault();
var Pending = dbContext.SpPendingCount(Obj.DealerID, Obj.AccountId).FirstOrDefault();
var Ready = dbContext.SpReadyCount(Obj.DealerID, Obj.AccountId).FirstOrDefault();
DashBoardBLL obj = new DashBoardBLL()
{
Total = Convert.ToInt64(Total),
Delivered = Convert.ToInt64(Delivered),
Pending = Convert.ToInt64(Pending),
Ready = Convert.ToInt64(Ready)
};
return(obj);
}
}
protected void Page_Load(object sender, EventArgs e)
{
CheckAccess();
if (!IsPostBack)
{
var todayBookings = DashBoardBLL.BookingGetAllTodayBookings(CurrentUser);
rptTodayBookings.DataSource = todayBookings;
rptTodayBookings.DataBind();
LoadCruiseAvaialability();
var newBookings = DashBoardBLL.BookingGetAllNewBookings(CurrentUser);
rptNewBookings.DataSource = newBookings;
rptNewBookings.DataBind();
LoadRecentMeetings();
var lastActivityOfAgenciesNotVisited = DashBoardBLL.AgencyGetAllAgenciesNotVisitedInLast2Month(CurrentUser);
rptAgencyNotVisited.DataSource = lastActivityOfAgenciesNotVisited;
rptAgencyNotVisited.DataBind();
var top10Agencies = DashBoardBLL.AgencyGetTop10(CurrentUser);
rptTop10Partner.DataSource = top10Agencies;
rptTop10Partner.DataBind();
var agenciesSendNoBookings = DashBoardBLL.AgencyGetAllAgenciesSendNoBookingsLast3Month(CurrentUser);
rptAgenciesSendNoBookings.DataSource = agenciesSendNoBookings;
rptAgenciesSendNoBookings.DataBind();
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();
LoadYourMonthArchivement();
ddlCruise.DataSource = DashBoardBLL.CruiseGetAll();
ddlCruise.DataTextField = "Name";
ddlCruise.DataValueField = "Id";
ddlCruise.DataBind();
ScriptManager.GetCurrent(this.Page).RegisterPostBackControl(btnExport);
}
}
public IEnumerable <Booking> BookingGetAllBookingsInMonth()
{
return(DashBoardBLL.BookingGetAllBookingsInMonth(CurrentUser));
}
protected void btnSave_Click(object sender, EventArgs e)
{
var uploadPath = "";
var contentType = "";
if (fuAttachment.HasFile)
{
var fileName = DateTime.Today.Year.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Day.ToString() + Guid.NewGuid().ToString();
var fileExtension = new FileInfo(fuAttachment.FileName).Extension;
var fullFileName = fileName + fileExtension;
uploadPath = Path.Combine(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Upload/"), fullFileName);
fuAttachment.SaveAs(uploadPath);
contentType = fuAttachment.PostedFile.ContentType;
}
var agencyContactId = 0;
try
{
agencyContactId = Int32.Parse(Request.Params["ddlContact"]);
}
catch { }
var agencyContact = DashBoardBLL.AgencyContactGetById(agencyContactId);
var dateMeeting = new DateTime();
try
{
dateMeeting = DateTime.ParseExact(txtDateMeeting.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
catch { }
var problems = "";
Cruise cruise = null;
if (ddlType.SelectedValue == "Problem Report")
{
if (chkBus.Checked)
{
problems += "Bus,";
}
if (chkCabin.Checked)
{
problems += "Cabin,";
}
if (chkGuide.Checked)
{
problems += "Guide,";
}
if (chkFood.Checked)
{
problems += "Food,";
}
if (chkOthers.Checked)
{
problems += "Others,";
}
problems = problems.TrimEnd(new char[] { ',' });
var cruiseId = 0;
try
{
cruiseId = Int32.Parse(ddlCruise.SelectedValue);
}
catch { }
cruise = DashBoardBLL.CruiseGetById(cruiseId);
if (cruise.Id == 0)
{
cruise = null;
}
}
var activityId = 0;
try
{
activityId = Int32.Parse(hidActivityId.Value);
}
catch { }
var activity = DashBoardBLL.ActivityGetById(activityId);
if (activity == null || activity.Id == 0)
{
activity = new Activity();
}
activity.UpdateTime = DateTime.Now;
activity.Time = DateTime.Now;
activity.Params = agencyContact != null && agencyContact.Agency != null?agencyContact.Agency.Id.ToString() : 0.ToString();
activity.DateMeeting = dateMeeting;
activity.Note = txtNote.Text;
activity.ObjectType = "MEETING";
activity.ObjectId = agencyContact != null ? agencyContact.Id : 0;
activity.Url = "AgencyView.aspx?NodeId=1&SectionId=15&agencyid=" + agencyContact != null && agencyContact.Agency != null?agencyContact.Agency.Id.ToString() : 0.ToString();
activity.User = CurrentUser;
activity.Level = ImportantLevel.Important;
activity.Type = ddlType.SelectedValue;
activity.NeedManagerAttention = chkNeedManagerAttention.Checked;
activity.Attachment = uploadPath == "" ? activity.Attachment : uploadPath;
activity.AttachmentContentType = contentType == "" ? activity.AttachmentContentType : contentType;
activity.Problems = problems;
activity.Cruise = cruise;
DashBoardBLL.ActivitySaveOrUpdate(activity);
Response.Redirect(Request.RawUrl);
}
public IEnumerable <Activity> ActivityGetAllActivityInMonth(int month, int year)
{
return(DashBoardBLL.ActivityGetAllActivityInMonth(month, year, CurrentUser));
}
public string GetTotalOfBookingsInMonth(int month, int year)
{
var totalRevenue = DashBoardBLL.BookingGetTotalRevenueInMonth(month, year, CurrentUser);
return(NumberUtil.FormatMoney(totalRevenue));
}
public int GetNumberOfBookingsInMonth(int month, int year)
{
return(DashBoardBLL.BookingGetNumberOfBookingsInMonth(month, year, CurrentUser));
}
public int GetNumberOfPaxInMonth(int month, int year)
{
return(DashBoardBLL.CustomerGetNumberOfCustomersInMonth(month, year, CurrentUser));
}
public AgencyContact AgencyContactGetById(int agencyContactId)
{
return(DashBoardBLL.AgencyContactGetById(agencyContactId));
}
public int GetNumberOfRoomAvaiable(Cruise cruise, DateTime date)
{
return(DashBoardBLL.GetNumberOfRoomAvaiable(cruise, date));
}
