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");
}
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));
}
}
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");
}
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);
}
}
}