Ejemplo n.º 1
0
        protected void btnFinish_Click(object sender, EventArgs e)
        {
            Qaelo.Models.StudentModel.Student student = (Qaelo.Models.StudentModel.Student)Session["STUDENT"];

            new AccommodationConnection().postRoomAd(new Models.AccommodationModel.RoomAd(student.Id, ddlArragement.SelectedItem.Value, DateTime.Now, ddlGender.SelectedItem.Value, txtPhone.Text, ddlPaymentType.SelectedItem.Value, Convert.ToDouble(txtPrice.Text)));

            lblSuccess.Text = "Successfully Submitted Ad";

            Response.Redirect("students-advertise-on-landloards-profile.aspx");
        }
Ejemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["STUDENT"] == null)
            {
                Response.Redirect("~/Web/Account/tempLogin.aspx?page=Users/Student/students-add-work.aspx");
            }

            //load previous work images
            Qaelo.Models.StudentModel.Student student = (Qaelo.Models.StudentModel.Student)(Session["STUDENT"]);

            PreviousWork work = connection.getPortfolio(student.Id);

            if (work != null && !IsPostBack)
            {
                //Load the previous work
                string[] pictures = work.Pictures.Split(';');
                txtLink.Text = work.Links;
                string[] videos = work.Videos.Split(';');
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["STUDENT"] == null)
            {
                Response.Redirect("~/Web/Account/tempLogin.aspx?page=Users/Student/students-profile.aspx");
            }

            if (!IsPostBack)
            {
                //Check if user owns this book otherwise redirect them to student profile
                Qaelo.Models.StudentModel.Student student = (Qaelo.Models.StudentModel.Student)Session["STUDENT"];
                Book book   = null;
                int  bookId = -1;
                try
                {
                    //Get the book
                    book = connection.getBookById(Convert.ToInt32(Request.QueryString["id"]));
                    //Check if its the owner
                    if (student.Id != book.StudentId)
                    {
                        Response.Redirect("students-profile.aspx");
                    }
                }
                catch
                {
                    Response.Redirect("students-profile.aspx");
                }

                //Populate Textboxes
                txtDescription.Text = book.Description;
                txtPrice.Text       = book.Price.ToString();
                txtTitle.Text       = book.Name;
                image1.Src          = "../../../Images/Book/" + book.Image;

                //work on dropdown
                ddlField.SelectedIndex = ddlField.Items.IndexOf(ddlField.Items.FindByValue(book.Field));
                ddlYear.SelectedIndex  = ddlYear.Items.IndexOf(ddlYear.Items.FindByValue(book.YearOfStudy));
            }
        }
Ejemplo n.º 4
0
        protected void btnFinish_Click(object sender, EventArgs e)
        {
            string name = "";

            Qaelo.Models.StudentModel.Student student = (Qaelo.Models.StudentModel.Student)Session["STUDENT"];

            string f1 = "default.jpg";
            string f2 = "default.jpg";
            string f3 = "default.jpg";
            string f4 = "default.jpg";
            string f5 = "default.jpg";
            string f6 = "default.jpg";


            if (file1.HasFile)
            {
                try
                {
                    f1 = student.Id + Path.GetFileName(file1.FileName);
                    file1.SaveAs(Server.MapPath("~/Images/Freelancer/") + f1);
                }
                catch (Exception ex)
                {
                    f1 = "default.jpg";
                    lblErrorMessage.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
                }
            }
            else
            {
                f1 = "default.jpg";
            }

            if (file2.HasFile)
            {
                try
                {
                    f2 = student.Id + Path.GetFileName(file2.FileName);
                    file2.SaveAs(Server.MapPath("~/Images/Freelancer/") + f2);
                }
                catch (Exception ex)
                {
                    f2 = "default.jpg";
                    lblErrorMessage.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
                }
            }
            else
            {
                f2 = "default.jpg";
            }

            if (file3.HasFile)
            {
                try
                {
                    f3 = student.Id + Path.GetFileName(file3.FileName);
                    file3.SaveAs(Server.MapPath("~/Images/Freelancer/") + f3);
                }
                catch (Exception ex)
                {
                    f3 = "default.jpg";
                    lblErrorMessage.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
                }
            }
            else
            {
                f3 = "default.jpg";
            }


            if (file4.HasFile)
            {
                try
                {
                    f4 = student.Id + Path.GetFileName(file4.FileName);
                    file4.SaveAs(Server.MapPath("~/Images/Freelancer/") + f4);
                }
                catch (Exception ex)
                {
                    f4 = "default.jpg";
                    lblErrorMessage.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
                }
            }
            else
            {
                f4 = "default.jpg";
            }

            if (file5.HasFile)
            {
                try
                {
                    f5 = student.Id + Path.GetFileName(file5.FileName);
                    file5.SaveAs(Server.MapPath("~/Images/Freelancer/") + f5);
                }
                catch (Exception ex)
                {
                    f5 = "default.jpg";
                    lblErrorMessage.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
                }
            }
            else
            {
                f5 = "default.jpg";
            }


            if (file6.HasFile)
            {
                try
                {
                    f6 = student.Id + Path.GetFileName(file6.FileName);
                    file6.SaveAs(Server.MapPath("~/Images/Freelancer/") + f6);
                }
                catch (Exception ex)
                {
                    f6 = "default.jpg";
                    lblErrorMessage.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
                }
            }
            else
            {
                f6 = "default.jpg";
            }

            string pictures = f1 + ";" + f2 + ";" + f3;
            string videos   = f4 + ";" + f5 + ";" + f6;

            PreviousWork previousWork = new PreviousWork(student.Id, pictures, videos, txtLink.Text);

            connection.postPortfolio(previousWork);

            lblSuccess.Text = "Sucessfully Saved previous work";

            Response.Redirect("students-profile.aspx?page=previousWork");
        }
Ejemplo n.º 5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["STUDENT"] == null)
            {
                Response.Redirect("~/Web/Account/tempLogin.aspx?page=Users/Student/students-profile.aspx");
            }

            Qaelo.Models.StudentModel.Student student = (Qaelo.Models.StudentModel.Student)Session["STUDENT"];

            string html = "";

            if (Request.QueryString["page"] != null)
            {
                if (Request.QueryString["page"] == "sellbooks")
                {
                    lblSuccess.Text = "You have successfully Posted your used textbook";
                }
                else if (Request.QueryString["page"] == "freelancer")
                {
                    lblSuccess.Text = "You have successfully registered yourself as a freelancer";
                }
                else if (Request.QueryString["page"] == "profile")
                {
                    lblSuccess.Text = "You have successfully updated your profile";
                }
                else if (Request.QueryString["page"] == "editbook")
                {
                    lblSuccess.Text = "You have successfully updated your book";
                }
                else if (Request.QueryString["page"].Equals("previousWork"))
                {
                    lblSuccess.Text = "Successfully added your previous work";
                }
            }
            //Make Profile Public or private
            if (Request.QueryString["disable"] != null)
            {
                //Delete Profile From Societies table
                connection.deleteStudentProfile(Convert.ToInt32(Request.QueryString["disable"].ToString()));
                lblSuccess.Text      = lblSuccess.Text = "";
                lblErrorMessage.Text = "Your Profile is now Private";
            }
            else if (Request.QueryString["enable"] != null)
            {
                //Insert Profile into Societies table
                if (!connection.isProfilePublic(Convert.ToInt32(Request.QueryString["enable"])))
                {
                    connection.uploadStudentProfile(student);
                }

                lblSuccess.Text      = lblSuccess.Text = "Your Profile is now Public";
                lblErrorMessage.Text = "";
            }

            //removeAd
            if (Request.QueryString["removeAd"] != null)
            {
                int id = Convert.ToInt32(Request.QueryString["removeAd"]);
                //delete
                new AccommodationConnection().deleteRoomAd(id, student);
                lblSuccess.Text = "Successfully deleted room advert";
            }

            //delete book
            if (Request.QueryString["remove"] != null)
            {
                int id = Convert.ToInt32(Request.QueryString["remove"]);
                //delete
                connection.deleteBook(id, student);
                lblSuccess.Text = "Successfully deleted book";
            }
            else if (Request.QueryString["edit"] != null)
            {
                //Edit book
                Response.Redirect("students-edit-books.aspx?id=" + Convert.ToInt32(Request.QueryString["edit"]));
            }

            if (connection.isProfilePublic(student.Id))
            {
                //if a student is a freelancer then include it here
                Qaelo.Models.StudentModel.Freelancer fl = connection.Freelancer(student.Id);
                string freelancer = "";

                if (fl != null)
                {
                    freelancer = "<h6>Freelancer :</h6><small style='font-size:12px'>" + fl.Work.Replace(';', '\n') + "</small>";
                }

                string proficePic = "../../../Images/Users/Students/" + student.ProfileImage;

                if (student.ProfileImage.Contains("http"))
                {
                    proficePic = student.ProfileImage;
                }

                html += string.Format(@"
                <div class='thumbnail'>
                  <div class='w3-card-12'>
                                <figure >
                                  <img src='{0}' style='height:245px;width:245px' />
                          <figcaption style = 'background-image: url('')'>
                                {1}                  
                          </figcaption>
                           </figure>
                    <div class='w3-container' style='margin:10px'>
                        <h6 style='margin-bottom:10px'><b>{2}- <small style='font-size:12px'>{3}</small></b></h6>
                        <h6 style='margin-bottom:10px'>Course Enrolled:<small style='font-size:12px'>{4}</small></h6>
                        <h6 style='margin-bottom:10px'>Year Of Study : <small style='font-size:12px'>{5}</small></h6>
                        <h6 style='margin-bottom:10px'>Email :<small style='font-size:12px'>{6}</small></h6>
                        {7}<br/><br/>
                      <a href='students-profile.aspx?disable={8}' class='btn btn-danger pull-right form-control'>Go Private!</a>
                        <br /><br/>
                    </div>
                  </div>
                </div>
                    
            ", proficePic, student.Description, student.FirstName + " " + student.LastName, student.Institution, student.QualificationEnrolled, student.YearOfStudy, student.Email, freelancer, student.Id);
            }
            else
            {
                Qaelo.Models.StudentModel.Freelancer fl = connection.Freelancer(student.Id);
                string freelancer = "";

                if (fl != null)
                {
                    freelancer = "<h6>Freelancer :</h6><small style='font-size:12px'>" + fl.Work.Replace(';', '\n') + "</small>";
                }


                string proficePic = "../../../Images/Users/Students/" + student.ProfileImage;

                if (student.ProfileImage.Contains("http"))
                {
                    proficePic = student.ProfileImage;
                }

                html += string.Format(@"
                <div class='thumbnail'>
                  <div class='w3-card-12'>
                                <figure >
                                  <img src='{0}' style='height:245px;width:245px' />
                          <figcaption style = 'background-image: url('')'>
                                {1}                  
                          </figcaption>
                           </figure>
                    <div class='w3-container' style='margin:10px'>
                        <h6 style='margin-bottom:10px'><b>{2}- <small style='font-size:12px'>{3}</small></b></h6>
                        <h6 style='margin-bottom:10px'>Course Enrolled:<small style='font-size:12px'>{4}</small></h6>
                        <h6 style='margin-bottom:10px'>Year Of Study : <small style='font-size:12px'>{5}</small></h6>
                        <h6 style='margin-bottom:10px'>Email :<small style='font-size:12px'>{6}</small></h6>
                        {7}<br/><br/>
                      <a href='students-profile.aspx?enable={8}' class='btn btn-success pull-right form-control'>Go Public!</a>
                        <br /><br/>
                    </div>
                  </div>
                </div>
                   
            ", proficePic, student.Description, student.FirstName + " " + student.LastName, student.Institution, student.QualificationEnrolled, student.YearOfStudy, student.Email, freelancer, student.Id);
            }
            lblProfileView.Text = html;

            //Become a freelancer
            //if(!connection.isAllowedToPost(student.Id))
            //{
            //    lblFreelance.Text = "<a href='#cannotBecomeFreelancer'data-toggle='modal' class='btn btn-submit' >Freelancing</a>";
            //}
            //else
            //    lblFreelance.Text = "<a href='Freelancer.aspx' class='btn btn-submit' >Freelancing</a>";
            /*** load rooms ads ***/


            List <RoomAd> ads = new AccommodationConnection().getRoomAds(student.Id);

            //set what to appear on advertise on landlords
            if (ads.Count > 0)
            {
                //Fill in
                lblRoomAds.Text = "";
                foreach (RoomAd item in ads)
                {
                    lblRoomAds.Text += string.Format(@"<tr>
                                                <td>{0}</td>
                                                <td>{1}</td>
                                                <td>{2}</td>
                                                <td>{3}</td>
                                                <td>{4}</td>
                                                <td><a href='students-profile.aspx?removeAd={5}' class='btn btn-danger'>remove</a></td>
                                            </tr>", General.getDateString(item.DatePosted), item.Arrangement, item.Gender, item.PaymentType, item.RentAmount, item.Id);
                }
                lblNumAdds.Text = ads.Count.ToString();
                //Set view to be current ads
                setView.HRef = "#viewAdd";
            }
            else
            {
                //Fill some fields
                txtPhone.Text = student.Number;

                setView.HRef = "#share";
            }

            //Check if the student has already some books sold
            List <Book> books = new StudentConnection().getAllStudentBoks(student.Id);

            lblPublished.Text = "";
            if (books.Count > 0)
            {
                if (books.Count >= 8)
                {
                    addNew.Visible = false;
                }

                foreach (Book book in books)
                {
                    string desc = "";

                    if (book.Description.Length > 65)
                    {
                        desc = book.Description.Substring(0, 65);
                    }
                    else
                    {
                        desc = book.Description;
                    }

                    lblPublished.Text += string.Format(@"<div class='col-sm-4' style='margin:30px'>
                                        <div class='col-sm-6'>
                                            <img src='../../../Images/Book/{0}' class='img-thumbnail' style='height:150px;width:100%' id='image1'/>
                                        </div>
                                        <div class='col-sm-6'>
                                            <label><strong>Title: {1}</strong></label><br/>
                                            <label><strong>Price:R{2}.00</strong></label><br/>
                                            <label><strong><a href='students-profile.aspx?remove={3}' class='btn btn-danger'>Delete</a></strong> <a href='students-profile.aspx?edit={3}' class='btn btn-finish btn-fill btn-warning btn-wd'>Edit</a></strong></label>
                                        </div>
                                    </div>
                                ", book.Image, book.Name, book.Price, book.Id);
                }

                lblsellbooks.Text = "<a href='#sellbooks'  data-toggle='modal'>My Store</a>";
            }
            else
            {
                //Check if the student is allowed to post
                if (!connection.isAllowedToPost(student.Id))
                {
                    lblsellbooks.Text = "<a href='#cannotsellbooks'data-toggle='modal'> My Store</a>";
                }
                else
                {
                    lblsellbooks.Text = "<a href='students-sell-textbooks.aspx'> My Store</a>";
                }
            }

            lblSuccess.Text = "";

            /******** Specials view **********/
            foreach (Qaelo.Models.ShopOwnerModel.ShopAds shop in new ShopConnection().getAllSpecials())
            {
                //create card view for specials
                lblSpecialLinks.Text += string.Format(@"<div class='col-sm-3'>
                    <div class='thumbnail'>
                      <div class='w3-card-12'>
                          <figure class=''>
                          <img src='../../../Images/Shops/Specials/{0}' class='' style='height:220px;width:100%'/>
                              <figcaption style = 'background-image: url('')'>{1}
                                   </figcaption>
                               </figure>
                        <div class='w3-container' style='margin:10px'>
                            <h6><b>{2} - <small>{3}</small></b></h6>
                            <strong>Shop No:<small>{4}</small></strong><br />
                           <strong> Open: <small>{5}</small></strong><br />
                            <strong>Call:<small>{6}</small>
                                <a href='#shopSpecial{7}' data-toggle='modal' class='btn btn-default pull-right'>View Special</a>
                            </strong><br />
                        </div><br />
                      </div>
                    </div>
                </div>", shop.Image, "", shop.Name, shop.University, shop.ShopNo, shop.TradingHours, new ShopConnection().getShopOwner(shop.ShopOwnerId).Number, shop.Id);


                //Generate links for individual Special
                //lblSpecialLinks.Text += string.Format("<a href='#shopSpecial{0}' data-toggle='modal'>View Special</a>",shop.Id);
                lblSpecials.Text += string.Format(@"<div class='modal fade' id='shopSpecial{4}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>
                        <div class='modal-dialog modal-lg'>
                        <div class='modal-content'>
                                    <div class='modal-body'>
                                        <div class='col-md-12' style='margin:20px'>
                                        <div class='col-md-6'>
                                            <img src='../../../Images/Shops/Specials/{0}' class='img-thumbnail' />
                                        </div>
                                        <div class='col-md-6'>
                                            <h4>Special Name</h4>
                                            <p>{1}</p>
                                            <br/><h4>Description</h4>
                                            <p>{2}</p>
                                            <br/><h4>Price:</h4>{3}
                                        </div>
                                    
                                        </div>
                                    <div class='modal-footer'>
                                        <button  class='btn btn-danger pull-right' data-dismiss='modal'>Back</button>
                                    </div>
                                    </div>
                                </div>
                            </div>
                            </div>", shop.Image, shop.Name, shop.Description.Replace(char.ConvertFromUtf32(13), "<br/>"), shop.Campus, shop.Id);
            }
        }
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            //load
            StudentConnection connection = new StudentConnection();

            //Get all students from selected varsity
            string query = " Institution = " + "'" + txtText.Text + "'";
            List <Qaelo.Models.StudentModel.Student> students = connection.getAllStudents(query);

            // Get the books made by these students
            List <Book> books = new List <Book>();

            foreach (Qaelo.Models.StudentModel.Student student in students)
            {
                //check if they have books and add to list

                List <Book> studentBooks = connection.getAllStudentBoks(student.Id);

                foreach (Book book in studentBooks)
                {
                    // check whether the books match the search filter

                    if (book.Field == ddlField.SelectedItem.Value && book.YearOfStudy == ddlYear.SelectedItem.Value)
                    {
                        books.Add(book);
                    }
                }
            }

            //List<Book> books = connection.getAllBooks();

            lblBooks.Text = "";
            int count = 0;

            foreach (Book book in books)
            {
                if (connection.isProfilePublic(book.StudentId))
                {
                    count++;
                    string desc = "";

                    if (book.Description.Length > 65)
                    {
                        desc = book.Description.Substring(0, 65);
                    }
                    else
                    {
                        desc = book.Description;
                    }

                    lblBooks.Text += string.Format(@"<div class='col-sm-6' style='margin-bottom:20px'>
                                                  <div class='col-sm-6'>
                                                    <img src = '../../../Images/Book/{0}' class='img-thumbnail' style='height:150px;width:100%' id='image1'/>
                                                  <br/><br/>
                                                </div>
                                                <div class='col-sm-6'>
                                                    <p style='font-size:smaller;font-style:normal'><strong>Title: <strong style='color:red'>{1}</strong></strong></p>
                                                    <p style='font-size:smaller;font-style:normal'><strong>Study Field: <strong style='color:dimgrey'>{2}</strong></strong></p>
                                                    <p style='font-size:smaller;font-style:normal'><strong>Year of Study: <strong style='color:dimgrey'>{3}</strong></strong></p>
                                                    <p style='font-size:smaller;font-style:normal'><strong>Price: R<strong style='color:dimgrey'>{4}.00</strong></strong></p>
                                                    <a href='#book{5}' class='btn btn-default btn-md' data-toggle='modal' style='background:#d89b4e'>More info</a>
                                                </div>
                                            </div>", book.Image, book.Name, book.Field, book.YearOfStudy, book.Price, book.Id);

                    //Modal

                    //get student
                    Qaelo.Models.StudentModel.Student student = connection.getStudent(book.StudentId);
                    lblBooks.Text += string.Format(@"<div class='modal fade' id='book{7}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel{1}' aria-hidden='true'>
                    <div class='modal-dialog modal-lg'>
                        <div class='modal-content'>
                                    <div class='modal-body'>
                                        <div class='container'>
                                            <div class='col-sm-10'>
                                                <div class='col-sm-4'>
                                                    <h2>Book Image</h2>
                                                    <img src = '../../../Images/Book/{0}' class='img-thumbnail' style='height:350px;width:100%' id='image1'/><br/><br/>
                                                </div>
                                                <div class='col-sm-4'>
                                                    <h2>About the book</h2>
                                                    <label><strong>Title:</strong></label>{1}<br />
                                                    <label><strong>Description:</strong></label>{2}<br/><br />
                                                    <label><strong>Price:</strong> {3}</label><br/><br />
                                                </div>
                                                <div class='col-sm-3'>
                                                    <h2>Seller info</h2>
                                                    <label><strong>Seller Name:</strong></label>{4}<br/>
                                                    <label><strong>Seller Number:</strong></label>{5}<br/>
                                                    <label><strong>University:</strong></label>{6}<br/>
                                                </div>
                                             </div>
                                            </div>
                                        </div>
                                    <div class='modal-footer'>
                                        <button  class='btn btn-default pull-left' data-dismiss='modal'>Cancel</button>
                                    </div>
                                    </div>
                                </div>
                            </div>", book.Image, book.Name, book.Description, book.Price, student.FirstName, student.Number, student.Institution, book.Id);
                }
            }
        }