public Business GetBusinessDetails()
        {
            Business business = null;

            using (DataTable table = DBHelper.ExecuteSelectCommand("sp_GetBusinessDetails", CommandType.StoredProcedure))
            {
                if (table.Rows.Count >= 1)
                {
                    DataRow row = table.Rows[0];
                    business = new Business();

                    business.BusinessID = Convert.ToInt32(row["BusinessID"]);
                    business.Name = row["Name"].ToString();
                    business.PhoneNo = row["PhoneNo"].ToString();
                    business.Email = row["Email"].ToString();
                    business.EmailPassword = row["EmailPassword"].ToString();
                    business.EmailServer = row["EmailServer"].ToString();
                    business.EmailPort = Convert.ToInt32(row["EmailPort"]);
                    business.AddressLine1 = row["AddressLine1"].ToString();
                    business.AddressLine2 = row["AddressLine2"].ToString();
                    business.DepositPercent = Convert.ToInt32(row["DepositPercent"]);
                    business.BankName = row["BankName"].ToString();
                    business.AccountNo = row["BankAccountNo"].ToString();
                    business.BranchCode = row["BranchCode"].ToString();
                }
            }
            return business;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            BusinessHandler businessHandler = new BusinessHandler();
            Business business = new Business();

            business = businessHandler.GetBusinessDetails();

            lblBusinessName.Text = business.Name;
            /*lblEmail.Text = business.Email;
            lblAddress1.Text = business.AddressLine1;
            lblAddress2.Text = business.AddressLine2;*/
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            BusinessHandler businessHandler = new BusinessHandler();
            Business business = new Business();
            business = businessHandler.GetBusinessDetails();

            lblName.Text = business.Name;
            lblPhoneNo.Text = business.PhoneNo;
            lblEmail.Text = business.Email;
            lblServer.Text = business.EmailServer;
            lblPort.Text = Convert.ToString(business.EmailPort);
            lblAddressLine1.Text = business.AddressLine1;
            lblAddressLine2.Text = business.AddressLine2;
            lblPercentage.Text = Convert.ToString(business.DepositPercent);
            lblBankName.Text = business.BankName;
            lblAccountNo.Text = business.AccountNo;
            lblBranchCode.Text = business.BranchCode;
        }
        public bool UpdateBusinessDetails(Business business)
        {
            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@Name", business.Name),
                new SqlParameter("@PhoneNo", business.PhoneNo),
                new SqlParameter("@Email", business.Email),
                new SqlParameter("@Server", business.EmailServer),
                new SqlParameter("@Port", business.EmailPort),
                new SqlParameter("@EmailPassword", business.EmailPassword),
                new SqlParameter("@Address1", business.AddressLine1),
                new SqlParameter("@Address2", business.AddressLine2),
                new SqlParameter("@Percentage", business.DepositPercent),
                new SqlParameter("@BankName", business.BankName),
                new SqlParameter("@AccountNo", business.AccountNo),
                new SqlParameter("@BranchCode", business.BranchCode)
            };

            return DBHelper.ExecuteNonQuery("sp_UpdateBusinessDetails", CommandType.StoredProcedure, parameters);
        }
        public Business GetBusinessDetails()
        {
            Business business = null;

            using (DataTable table = DBHelper.ExecuteSelectCommand("sp_GetBusinessDetails", CommandType.StoredProcedure))
            {
                if (table.Rows.Count >= 1)
                {
                    DataRow row = table.Rows[0];
                    business = new Business();

                    business.BusinessID = Convert.ToInt32(row["BusinessID"]);
                    business.Name = row["Name"].ToString();
                    business.Email = row["Email"].ToString();
                    business.EmailPassword = row["EmailPassword"].ToString();
                    business.EmailServer = row["EmailServer"].ToString();
                    business.EmailPort = Convert.ToInt32(row["EmailPort"]);
                }
            }
            return business;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            lblPercentageIsNumberValidator.Visible = false;

            business = businessHandler.GetBusinessDetails();
            if (IsPostBack == false)
            {
                txtName.Text = business.Name;
                txtPhone.Text = business.PhoneNo;
                txtEmail.Text = business.Email;
                txtServer.Text = business.EmailServer;
                txtPort.Text = Convert.ToString(business.EmailPort);
                hiddenPassword.Value = Convert.ToString(business.EmailPassword);
                txtAddressLine1.Text = business.AddressLine1;
                txtAddressLine2.Text = business.AddressLine2;
                txtPercentage.Text = Convert.ToString(business.DepositPercent);
                txtBankName.Text = Convert.ToString(business.BankName);
                txtAccountNo.Text = Convert.ToString(business.AccountNo);
                txtBranchCode.Text = Convert.ToString(business.BranchCode);
            }
        }
        protected void btnEdit_Click(object sender, EventArgs e)
        {
            business = new Business();

            string option = "";
            int num = 0;
            option = txtPercentage.Text.Trim();

            if (int.TryParse(option, out num) == true)
            {
                lblPercentageIsNumberValidator.Visible = false;
                business.Name = txtName.Text;
                business.PhoneNo = txtPhone.Text;
                business.Email = txtEmail.Text;
                business.EmailServer = txtServer.Text;
                business.EmailPort = Convert.ToInt32(txtPort.Text);
                business.EmailPassword = hiddenPassword.Value;
                if (txtPassword.Text != "")
                {
                    business.EmailPassword = txtPassword.Text;
                }
                business.AddressLine1 = txtAddressLine1.Text;
                business.AddressLine2 = txtAddressLine2.Text;
                business.DepositPercent = Convert.ToInt32(txtPercentage.Text);
                business.BankName = txtBankName.Text;
                business.AccountNo = txtAccountNo.Text;
                business.BranchCode = txtBranchCode.Text;

                businessHandler.UpdateBusinessDetails(business);
                Response.Redirect("Settings.aspx");
            }
            else
            {
                lblPercentageIsNumberValidator.Visible = true;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            //get dynamic page info
            BusinessHandler businessHandler = new BusinessHandler();
            Business business = new Business();

            business = businessHandler.GetBusinessDetails();
            lblBusinessEmail.Text = business.Email;
            lblDepositPercent.Text = business.DepositPercent.ToString();
        }
        protected void btnRecoverPassword_Click(object sender, EventArgs e)
        {
            LecturerHandler lecturerHandler = new LecturerHandler();
            Lecturer lecturer = null;
            BusinessHandler businessHandler = null;
            Business business = null;

            string destinationEmail = txtEmail.Value;

            //check email exists
            if (lecturerHandler.ValidateEmail(destinationEmail) == false)
            {
                //email doesn't exist in DB
                litAlert.Text = "<div class='alert alert-danger'>Invalid Email Address</div>";
            }

            else
            {
                //get business email and password
                string name, email, password, emailServer, newPassword;
                int port;

                businessHandler = new BusinessHandler();
                business = new Business();
                business = businessHandler.GetBusinessDetails();

                name = business.Name;
                email = business.Email;
                password = business.EmailPassword;
                emailServer = business.EmailServer;
                port = business.EmailPort;

                //generate new password
                newPassword = Membership.GeneratePassword(7, 0);

                //update database
                lecturer = new Lecturer();
                lecturer.Email = destinationEmail;
                lecturer.Password = newPassword;

                //send email
                try
                {
                    MailMessage mail = new MailMessage();
                    SmtpClient smtpClient = new SmtpClient(emailServer);
                    mail.From = new MailAddress(email);
                    mail.To.Add(destinationEmail);
                    mail.Subject = name + " 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(email, password);
                    smtpClient.EnableSsl = true;

                    smtpClient.Send(mail);
                    lecturerHandler.UpdateLecturerPassword(lecturer);

                    litAlert.Text = "<div class='alert alert-success'>An email was sent, check you email for your new password.</div>";

                    //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)
                {
                    litAlert.Text = "<div class='alert alert-warning'>Failed to send an email</div>";
                }
            }
        }
        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>");
            */
        }
 public bool UpdateBusinessDetails(Business business)
 {
     return businessDB.UpdateBusinessDetails(business);
 }