protected void btnUpdateProfile_Click(object sender, EventArgs e)
{
int memberID = 0;
try
{
memberID = Convert.ToInt32(Request.QueryString["id"]);
}
catch (NullReferenceException)
{
}
MemberHandler memberHandler = new MemberHandler();
Member member = new Member();
member = memberHandler.GetMemberDetails(memberID);
member.MemberID = memberID;
member.FirstName = txtFirstName.Text;
member.Surname = txtSurname.Text;
member.AddressLine1 = txtAddressLine1.Text;
member.AddressLine2 = txtAddressLine2.Text;
member.Suburb = txtSuburb.Text;
member.PostalCode = txtPostalCode.Text;
member.City = txtCity.Text;
member.PhoneNo = txtPhoneNo.Text;
member.Email = txtEmail.Text;
member.Password = txtPassword.Text;
member.Role = Convert.ToInt32(ddlRole.SelectedValue);
if (txtPassword.Text == "")
memberHandler.UpdateMember(member);
else if (txtPassword.Text != "")
memberHandler.UpdateMemberWithPassword(member);
Response.Redirect("Profile.aspx?id=" + memberID.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
int myRole = 2;
bool loggedIn = false;
if (Session["MemberID"] != null)
loggedIn = true;
if (loggedIn == false)
Response.Redirect("Login.aspx");
if (loggedIn == true)
{
MemberHandler memberHandler = new MemberHandler();
myRole = memberHandler.GetRole((int)Session["MemberID"]);
if (myRole > 2)
{
litOwnerHeader.Visible = true;
btnListRooms.Visible = true;
btnListRoomTypes.Visible = true;
btnFindMember.Visible = true;
btnBusinessSettings.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int myRole = 1;
bool loggedIn = false;
int memberID = 0;
bool intTest = false;
intTest = int.TryParse(Request.QueryString["id"], out memberID);
if (memberID == 0)
Response.Redirect("Default.aspx");
if (Session["MemberID"] != null)
loggedIn = true;
if (loggedIn == false)
Response.Redirect("Login.aspx");
MemberHandler memberHandler = new MemberHandler();
Member member = new Member();
member = memberHandler.GetMemberDetails(memberID);
//Begin check to see if this is a members own profile or if owner is viewing it
myRole = memberHandler.GetRole((int)Session["MemberID"]);
if (myRole != 3 && (int)Session["MemberID"] != memberID)
{
Response.Redirect("Default.aspx");
}
//End check
if (loggedIn == true)
{
try
{
Page.Title = "EASiBOOK :: Profile for " + member.FirstName + " " + member.Surname;
}
catch (NullReferenceException)
{
Response.Redirect("Default.aspx");
}
litCustomerName.Text = "Profile for " + member.FirstName + " " + member.Surname;
lblFirstName.Text = member.FirstName;
lblSurname.Text = member.Surname;
lblAddressLine1.Text = member.AddressLine1;
lblAddressLine2.Text = member.AddressLine2;
lblSuburb.Text = member.Suburb;
lblPostalCode.Text = member.PostalCode;
lblCity.Text = member.City;
lblPhoneNo.Text = member.PhoneNo;
lblEmail.Text = member.Email;
if (member.Role == 1)
lblRole.Text = "Customer";
else if (member.Role == 2)
lblRole.Text = "Booking Admin";
if (member.Role == 3)
lblRole.Text = "Owner";
}
}
protected void Page_Load(object sender, EventArgs e)
{
int myRole = 1;
bool loggedIn = false;
int memberID = 0;
bool intTest = false;
intTest = int.TryParse(Request.QueryString["id"], out memberID);
if (memberID == 0)
Response.Redirect("Default.aspx");
if (Session["MemberID"] != null)
loggedIn = true;
if (loggedIn == false)
Response.Redirect("Login.aspx");
MemberHandler memberHandler = new MemberHandler();
Member member = new Member();
member = memberHandler.GetMemberDetails(memberID);
//Begin check to see if this is a members own profile or if owner is viewing it
myRole = memberHandler.GetRole((int)Session["MemberID"]);
if (myRole != 3 && (int)Session["MemberID"] != memberID)
{
Response.Redirect("Default.aspx");
}
//End check
if (myRole >= 3 && memberID != (int)Session["MemberID"])
ddlRole.Enabled = true;
if (!IsPostBack)
{
try
{
txtEmail.Text = member.Email;
txtFirstName.Text = member.FirstName;
txtSurname.Text = member.Surname;
txtAddressLine1.Text = member.AddressLine1;
txtAddressLine2.Text = member.AddressLine2;
txtSuburb.Text = member.Suburb;
txtPostalCode.Text = member.PostalCode;
txtCity.Text = member.City;
txtPhoneNo.Text = member.PhoneNo;
if (member.Role == 1)
ddlRole.SelectedIndex = 0;
else if (member.Role == 2)
ddlRole.SelectedIndex = 1;
else if (member.Role == 3)
ddlRole.SelectedIndex = 2;
}
catch (NullReferenceException)
{
Response.Redirect("Default.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
MemberHandler memberHandler = new MemberHandler();
if (!Page.IsPostBack)
{
//populate typeID drop down list (dlTypeID) with every TypeID
lstMembers.DataSource = memberHandler.GetMemberNameList();
lstMembers.DataTextField = "Name";
lstMembers.DataValueField = "MemberID";
lstMembers.DataBind();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
//search the database for the given search string (includes partial matches)
lstMembers.Items.Clear();
string searchQuery = txtSearch.Text.Replace(" ", "%");
searchQuery = searchQuery.Trim();
MemberHandler memberHandler = new MemberHandler();
lstMembers.DataSource = memberHandler.GetMemberSearchList(searchQuery);
lstMembers.DataTextField = "Name";
lstMembers.DataValueField = "MemberID";
lstMembers.DataBind();
}
protected void btnYes_Click(object sender, EventArgs e)
{
int myRole = 1;
int bookingID = 0;
bool intTest = false;
intTest = int.TryParse(Request.QueryString["id"], out bookingID);
int returnID = 0;
intTest = false;
intTest = int.TryParse(Request.QueryString["return"], out returnID);
if (bookingID == 0)
Response.Redirect("Default.aspx");
bool loggedIn = false;
//Checks for a login
if (Session["MemberID"] != null)
loggedIn = true;
if (loggedIn == false)
{
Session["LoginRedirect"] = "CancelBooking.aspx?id=" + bookingID.ToString() + "&return=" + returnID.ToString();
Response.Redirect("Login.aspx");
}
//End of login check
BookingHandler bookingHandler = new BookingHandler();
bookingHandler.CancelBooking(bookingID);
int memberID = bookingHandler.GetBookingOwner(bookingID);
//Checks if role is high enough
MemberHandler memberHandler = new MemberHandler();
myRole = memberHandler.GetRole((int)Session["MemberID"]);
if (myRole != 3 && (int)Session["MemberID"] != memberID)
{
Response.Redirect("Default.aspx");
}
//End check for role
}
protected void Page_Load(object sender, EventArgs e)
{
int myRole = 0;
string welcomeMessage = " ";
if ((string)Request.QueryString["logout"] == "1")
{
welcomeMessage = "You have been logged out successfully<br /><br />";
lblWelcome.Visible = true;
lblWelcome.Text = welcomeMessage;
}
if (Session["FirstName"] != null && Session["Surname"] != null)
{
welcomeMessage = "Welcome to EASiBOOK, " + Session["FirstName"] + " " + Session["Surname"] + "!<br /><br />";
lblWelcome.Visible = true;
lblWelcome.Text = welcomeMessage;
MemberHandler memberHandler = new MemberHandler();
myRole = memberHandler.GetRole((int)Session["MemberID"]);
if (myRole > 1)
btnStaffTools.Visible = true;
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string loginResult = " ";
string email = txtEmail.Text;
string password = txtPassword.Text;
int memberID = 0;
string redirectURL = "Default.aspx";
if ((string)Session["LoginRedirect"] != null)
{
redirectURL = (string)Session["LoginRedirect"];
}
MemberHandler memberHandler = new MemberHandler();
Member member = new Member();
member = memberHandler.ValidateLogin(email, password);
try
{
loginResult = member.MemberID.ToString() + " " + member.Role.ToString();
memberID = member.MemberID;
Session["MemberID"] = memberID;
Session["FirstName"] = member.FirstName;
Session["Surname"] = member.Surname;
Response.Redirect(redirectURL);
}
catch (NullReferenceException)
{
loginResult = "The username or password you entered is incorrect<br /><br />";
}
lblSuccessfullRegistration.Text = loginResult;
lblSuccessfullRegistration.ForeColor = Color.Red;
lblSuccessfullRegistration.Visible = true;
}
protected void SendMail(int bookingID, bool confirmed)
{
//get member who created the booking
BookingHandler bookingHandler = new BookingHandler();
int memberID = bookingHandler.GetBookingOwner(bookingID);
//the get members email
MemberHandler memberHandler = new MemberHandler();
Member member = new Member();
member = memberHandler.GetMemberDetails(memberID);
BusinessHandler businessHandler = null;
Business business = null;
//get business email and password
string businessName, businessEmail, businessPassword, emailServer;
int port;
businessHandler = new BusinessHandler();
business = new Business();
business = businessHandler.GetBusinessDetails();
businessName = business.Name;
businessEmail = business.Email;
businessPassword = business.EmailPassword;
emailServer = business.EmailServer;
port = business.EmailPort;
//send email
MailMessage mail = new MailMessage();
SmtpClient smtpClient = new SmtpClient(emailServer);
mail.From = new MailAddress(businessEmail);
mail.To.Add(member.Email);
if (confirmed)
{
mail.Subject = businessName + " Booking Confirmed";
mail.Body = "We are pleased to inform you, your booking at " + businessName + " has been confirmed. Please supply the following booking referance number when checking in: " + bookingID.ToString();
}
else
{
mail.Subject = businessName + " Booking Declined";
mail.Body = "We are sad to inform you, your booking at " + businessName + " has been declined. If you have any queries please contact us for assistance.";
}
smtpClient.Port = port;
smtpClient.Credentials = new NetworkCredential(businessEmail, businessPassword);
smtpClient.EnableSsl = true;
smtpClient.Send(mail);
memberHandler.UpdateMemberPassword(member);
/*
lblProgress.CssClass = "label label-success";
lblProgress.Text = "An email was sent, check you email for your new password.";
//delay redirect to alert user of page change
lblRedirect.Text = "Redirecting to log in, in 5 seconds.";
Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"Login.aspx\"; }, 5000);</script>");
*/
}
protected void Page_Load(object sender, EventArgs e)
{
int myRole = 1;
int bookingID = 0;
bool intTest = false;
intTest = int.TryParse(Request.QueryString["id"], out bookingID);
int returnID = 0;
intTest = false;
intTest = int.TryParse(Request.QueryString["return"], out returnID);
if (bookingID == 0)
Response.Redirect("Default.aspx");
if (IsPostBack)
{
litHeader.Text = "The booking has been cancelled sucessfully!";
btnYes.Visible = false;
btnNo.Visible = false;
btnBack.Visible = true;
}
else
{
litHeader.Text = "You are about to cancel booking number " + bookingID.ToString() + "<br /><br />Once this booking has been cancelled, this process can't be undone. Are you sure you want to continue?";
}
bool loggedIn = false;
//Checks for a login
if (Session["MemberID"] != null)
loggedIn = true;
if (loggedIn == false)
{
Session["LoginRedirect"] = "CancelBooking.aspx?id=" + bookingID.ToString() + "&return=" + returnID.ToString();
Response.Redirect("Login.aspx");
}
//End of login check
BookingHandler bookingHandler = new BookingHandler();
int memberID = bookingHandler.GetBookingOwner(bookingID);
//Checks if role is high enough
MemberHandler memberHandler = new MemberHandler();
myRole = memberHandler.GetRole((int)Session["MemberID"]);
if (myRole != 3 && (int)Session["MemberID"] != memberID)
{
Response.Redirect("Default.aspx");
}
//End check for role
}
protected void btnRegister_Click(object sender, EventArgs e)
{
string option = "";
double num = 0;
option = txtPhoneNo.Text.Trim();
PhoneIsNumberValidator.Visible = false;
string city = "";
string suburb = "";
if (rdoOtherCity.Checked == true)
{
city = txtCity.Text;
suburb = txtSuburb.Text;
}
else
{
city = cmbCity.SelectedItem.Text;
suburb = cmbSuburb.SelectedItem.Text;
}
Member member = new Member();
member.Email = txtEmail.Text;
member.Password = txtPassword.Text;
member.FirstName = txtFirstName.Text;
member.Surname = txtSurname.Text;
member.AddressLine1 = txtAddressLine1.Text;
member.AddressLine2 = txtAddressLine2.Text;
member.Suburb = suburb;
member.PostalCode = txtPostalCode.Text;
member.City = city;
member.PhoneNo = txtPhoneNo.Text;
MemberHandler memberHandler = new MemberHandler();
if (memberHandler.ValidateEmail(txtEmail.Text) == false && double.TryParse(option, out num) == true)
{
if (memberHandler.AddNewMember(member) == false)
Response.Redirect("Login.aspx?registered=1");
}
else if (memberHandler.ValidateEmail(txtEmail.Text) == true)
{
litInvalidEmail.Text = "<h3 style=\"color:red\">This E-Mail address is already in use</h3><br />";
txtPassword.Attributes.Add("value", txtPassword.Text);
txtConfirmPassword.Attributes.Add("value", txtConfirmPassword.Text);
if (rdoOtherCity.Checked == false)
{
RequiredCityValidator.Enabled = false;
RequiredSuburbValidator.Enabled = false;
}
}
else if (double.TryParse(option, out num) == false)
{
litInvalidEmail.Text = "";
txtPassword.Attributes.Add("value", txtPassword.Text);
txtConfirmPassword.Attributes.Add("value", txtConfirmPassword.Text);
PhoneIsNumberValidator.Visible = true;
RequiredCityValidator.Enabled = false;
RequiredSuburbValidator.Enabled = false;
}
}
protected void btnResetPassword_Click(object sender, EventArgs e)
{
MemberHandler memberHandler = new MemberHandler();
Member member = null;
BusinessHandler businessHandler = null;
Business business = null;
string destinationEmail = txtEmail.Text;
//check email exists
if (memberHandler.ValidateEmail(destinationEmail) == false)
{
//email doesn't exist in DB
lblProgress.Text = "Invalid Email Address";
}
else
{
//get business email and password
string businessName, businessEmail, businessPassword, emailServer, newPassword;
int port;
businessHandler = new BusinessHandler();
business = new Business();
business = businessHandler.GetBusinessDetails();
businessName = business.Name;
businessEmail = business.Email;
businessPassword = business.EmailPassword;
emailServer = business.EmailServer;
port = business.EmailPort;
//generate new password
newPassword = Membership.GeneratePassword(7, 0);
//update database
member = new Member();
member.Email = destinationEmail;
member.Password = newPassword;
//send email
try
{
MailMessage mail = new MailMessage();
SmtpClient smtpClient = new SmtpClient(emailServer);
mail.From = new MailAddress(businessEmail);
mail.To.Add(destinationEmail);
mail.Subject = businessName + " Password Reset";
mail.Body = "Your password has been reset. Please use the following phrase as your new password when you log in: " + newPassword;
//code to include an attatchment
//System.Net.Mail.Attachment attachment;
//attachment = new System.Net.Mail.Attachment("attatchment.jpg");
//mail.Attachments.Add(attachment);
smtpClient.Port = port;
smtpClient.Credentials = new NetworkCredential(businessEmail, businessPassword);
smtpClient.EnableSsl = true;
smtpClient.Send(mail);
memberHandler.UpdateMemberPassword(member);
lblProgress.CssClass = "label label-success";
lblProgress.Text = "An email was sent, check you email for your new password.";
//delay redirect to alert user of page change
lblRedirect.Text = "Redirecting to log in, in 5 seconds.";
Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"Login.aspx\"; }, 5000);</script>");
}
catch (Exception ex)
{
lblProgress.Text = "Failed to send an email." + ex.ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int myRole = 1;
bool loggedIn = false;
int memberID = 0;
bool intTest = false;
intTest = int.TryParse(Request.QueryString["id"], out memberID);
if (memberID == 0)
Response.Redirect("Default.aspx");
//Checks for a login
if (Session["MemberID"] != null)
loggedIn = true;
if (loggedIn == false)
{
Session["LoginRedirect"] = "BookingHistory.aspx?id=";
Response.Redirect("Login.aspx");
}
//End of login check
MemberHandler memberHandler = new MemberHandler();
Member member = memberHandler.GetMemberDetails(memberID);
try
{
litMemberName.Text = member.FirstName + ' ' + member.Surname;
}
catch (NullReferenceException)
{
Response.Redirect("Default.aspx");
}
//Checks if role is high enough
myRole = memberHandler.GetRole((int)Session["MemberID"]);
if (myRole != 3 && (int)Session["MemberID"] != memberID)
{
Response.Redirect("Default.aspx");
}
//End check for role
BookingHandler bookingHandler = new BookingHandler();
List<Booking> bookingHistory = bookingHandler.GetBookingHistory(memberID);
if (bookingHistory == null)
litError.Text = "<h3 style=\"color:red\">There are no previous or current bookings</h3><br />";
else
{
int bookingID = 0;
string htmlOutput = "";
string proofOfPayment = "No";
string arriveDate = "";
string departDate = "";
string uploadProofText = "Upload";
string colour = "blue";
string status = "";
string cancelButton = "";
for (int i = 0; i < bookingHistory.Count; i++)
{
bookingID = bookingHistory[i].BookingID;
arriveDate = bookingHistory[i].ArriveDate.Year.ToString() + '-' + bookingHistory[i].ArriveDate.Month.ToString() + '-' + bookingHistory[i].ArriveDate.Day.ToString();
departDate = bookingHistory[i].DepartDate.Year.ToString() + '-' + bookingHistory[i].DepartDate.Month.ToString() + '-' + bookingHistory[i].DepartDate.Day.ToString();
if (bookingHistory[i].ProofOfPayment == null || bookingHistory[i].ProofOfPayment == "")
{
proofOfPayment = "No";
uploadProofText = "Upload";
}
else
{
proofOfPayment = "Yes";
uploadProofText = "Re-Upload";
}
switch (bookingHistory[i].Status)
{
case "P": colour = "#FF6600";
status = "Provisional";
break;
case "C": colour = "#00C0FF";
status = "Cancelled";
break;
case "D": colour = "#FF3300";
status = "Declined";
break;
case "A": colour = "#66FF66";
status = "Confirmed";
break;
default: colour = "#66CCFF";
break;
}
if (bookingHistory[i].Status != "C" && bookingHistory[i].Status != "D" && bookingHistory[i].ArriveDate > DateTime.Now.AddDays(-1))
cancelButton = "<a class=\"btn btn-danger\" style=\"width:130px;height:30px;\" href=\"CancelBooking.aspx?id=" + bookingID.ToString() + "&return=" + memberID.ToString() + "\">Cancel Booking</a>";
else
cancelButton = "<strong>Unavailable</strong>";
htmlOutput += "<tr style=\"background-color:" + colour + "\"><td>" + bookingID.ToString() + "</td><td>" + arriveDate + "</td><td>" + departDate + "</td><td>" + status + "</td><td>" + proofOfPayment + "</td><td>" + "<a class=\"btn btn-success\" style=\"width:100px;height:30px;\" href=\"UploadProof.aspx?id=" + bookingID.ToString() + "\">" + uploadProofText + "</a>" + "</td><td><a class=\"btn btn-warning\" style=\"width:100px;height:30px;\" href=\"Invoice.aspx?id=" + bookingID.ToString() + "\">Invoice</a></td><td>" + cancelButton + "</td></tr>\n";
}
litBookingHistory.Text = htmlOutput;
}
}
