public ActionResult <JobListing> GetJob(string jobId)
{
try
{
JobListing jobFound = FakeDB.Jobs.Find(c => c.Id == jobId);
if (jobFound == null)
{
throw new System.Exception("Job does not exist");
}
return(Ok(jobFound));
//NOTE can use exists to see if a list contains something, but it returns a bool so be cautious when returning.
// bool jobFound = FakeDB.Jobs.Exists(c => c.Id == jobId);
// if (jobFound == false)
// {
// throw new System.Exception("Job does not exist");
// }
}
catch (System.Exception err)
{
return(BadRequest(err.Message));
}
}
public string Put(JobListingModel editJobListing)
{
string success = "";
try
{
using (GetaJobContext db = new GetaJobContext())
{
JobListing dbJobListing = db.JobListings.Where(j => j.Id == editJobListing.Id).FirstOrDefault();
if (dbJobListing != null)
{
dbJobListing.PostedDate = DateTime.Parse(editJobListing.PostedDate);
dbJobListing.JobLocation = editJobListing.Location;
dbJobListing.JobTitle = editJobListing.JobTitle;
dbJobListing.AgentId = editJobListing.AgentId;
dbJobListing.TargetCompanyId = editJobListing.TargetCompanyId;
dbJobListing.Comments = editJobListing.Comments;
dbJobListing.ListingStatusRef = editJobListing.Status;
dbJobListing.Rate = editJobListing.Rate;
dbJobListing.EmploymentTypeRef = editJobListing.EmploymentType;
dbJobListing.Distance = editJobListing.Distance;
dbJobListing.ListingSourceRef = editJobListing.ListingSource;
dbJobListing.DesirabilityRef = editJobListing.Desirability;
dbJobListing.FitnessRef = editJobListing.Fit;
db.SaveChanges();
success = "ok";
}
else
{
success = "Id: " + editJobListing.Id + " not found";
}
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public async Task UpdateJobListingAsync(JobListing jobListing)
{
_applicationDbContext.JobListings.Update(jobListing);
await _applicationDbContext.SaveChangesAsync();
}
public async Task CreateJobListingAsync(JobListing jobListing)
{
await _applicationDbContext.JobListings.AddAsync(jobListing);
await _applicationDbContext.SaveChangesAsync();
}
/// NAME: Hassan Karar
/// DATE: 2020/3/7
/// CHECKED BY:
/// <summary>
/// This method for updating the job listing data access.
/// </summary>
/// <remarks>
/// UPDATED BY:
/// UPDATE DATE:
/// WHAT WAS CHANGED:
/// <param name="newJobListing"></param>
/// <param name="oldJobListing"></param>
/// </remarks>
///
public int UpdateJobListing(JobListing newJobListing, JobListing oldJobListing)
{
int rows = 0;
// connection
var conn = DBConnection.GetConnection();
// cmd
var cmd = new SqlCommand("sp_update_JobListing", conn);
cmd.CommandType = CommandType.StoredProcedure;
// parameters
cmd.Parameters.Add("@OldJobListingID", SqlDbType.Int);
cmd.Parameters.Add("@OldRoleID", SqlDbType.NVarChar);
cmd.Parameters.Add("@OldBenefits", SqlDbType.NVarChar);
cmd.Parameters.Add("@OldRequirements", SqlDbType.NVarChar);
cmd.Parameters.Add("@OldStartingWage", SqlDbType.Decimal);
cmd.Parameters.Add("@OldResponsibilities", SqlDbType.NVarChar);
cmd.Parameters.Add("@NewRoleID", SqlDbType.NVarChar);
cmd.Parameters.Add("@NewBenefits", SqlDbType.NVarChar);
cmd.Parameters.Add("@NewRequirements", SqlDbType.NVarChar);
cmd.Parameters.Add("@NewStartingWage", SqlDbType.Decimal);
cmd.Parameters.Add("@NewResponsibilities", SqlDbType.NVarChar);
// values
cmd.Parameters["@NewRoleID"].Value = newJobListing.RoleID;
cmd.Parameters["@NewBenefits"].Value = newJobListing.Benefits;
cmd.Parameters["@NewRequirements"].Value = newJobListing.Requirements;
cmd.Parameters["@NewStartingWage"].Value = newJobListing.StartingWage;
cmd.Parameters["@NewResponsibilities"].Value = newJobListing.Responsibilities;
cmd.Parameters["@OldJobListingID"].Value = oldJobListing.JobListingID;
cmd.Parameters["@OldRoleID"].Value = oldJobListing.RoleID;
cmd.Parameters["@OldBenefits"].Value = oldJobListing.Benefits;
cmd.Parameters["@OldRequirements"].Value = oldJobListing.Requirements;
cmd.Parameters["@OldStartingWage"].Value = oldJobListing.StartingWage;
cmd.Parameters["@OldResponsibilities"].Value = oldJobListing.Responsibilities;
// execute the command
try
{
conn.Open();
rows = cmd.ExecuteNonQuery();
if (rows == 0)
{
throw new ApplicationException("not found");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(rows);
}
public ActionResult Create(
[Bind(
"Title,Type,Position,Region,Location,Description,IsActive,CategoryId,CompanyId,WorkExperience,Education,Skills,OtherNotes")]
AddJobListingWithTemplateViewModel addJobListingWithTemplateViewModel)
{
int userIdCurrentlyLoggedIn = Int32.Parse(User.Claims.FirstOrDefault(uc => uc.Type == ClaimTypes.NameIdentifier).Value);
if (ModelState.IsValid)
{
JobListing jobListing = new JobListing
{
Title = addJobListingWithTemplateViewModel.Title,
Type = addJobListingWithTemplateViewModel.Type,
Position = addJobListingWithTemplateViewModel.Position,
Region = addJobListingWithTemplateViewModel.Region,
Location = addJobListingWithTemplateViewModel.Location,
Description = addJobListingWithTemplateViewModel.Description,
IsActive = Convert.ToByte(addJobListingWithTemplateViewModel.IsActive),
JobListingAddedAt = DateTime.Now,
UserId = userIdCurrentlyLoggedIn,
CompanyId = addJobListingWithTemplateViewModel.CompanyId,
CategoryId = addJobListingWithTemplateViewModel.CategoryId
};
int jobListingId = _jobListingsRepository.AddJobListing(jobListing, userIdCurrentlyLoggedIn);
if (jobListingId != 0)
{
Template template = new Template
{
WorkExperience = Convert.ToByte(addJobListingWithTemplateViewModel.WorkExperience),
Skills = Convert.ToByte(addJobListingWithTemplateViewModel.Skills),
Education = Convert.ToByte(addJobListingWithTemplateViewModel.Education),
OtherNotes = Convert.ToByte(addJobListingWithTemplateViewModel.OtherNotes),
JobListingId = jobListingId,
UserId = userIdCurrentlyLoggedIn,
TemplateAddedAt = DateTime.Now
};
_templatesRepository.AddTemplate(template);
}
ViewBag.SelectedNav = "Dashboard";
return(RedirectToAction(nameof(Index)));
}
List <Company> companiesAssignedToUserLoggedIn = _companiesRepository.GetCompaniesAssignedToUser(userIdCurrentlyLoggedIn);
List <Category> categories = _categoriesRepository.GetCategories();
List <string> regions = new List <string> {
"Africa", "Asia", "The Caribbean", "Central America", "Europe", "Oceania", "North America", "South America"
};
List <string> types = new List <string> {
"Full Time", "Part Time", "Remote", "Voluntary or carity acts"
};
ViewData["Companies"] = new SelectList(companiesAssignedToUserLoggedIn, "CompanyId", "Name");
ViewData["Categories"] = new SelectList(categories, "CategoryId", "Name");
ViewData["Regions"] = new SelectList(regions, regions);
ViewData["Types"] = new SelectList(types, types);
ViewBag.SelectedNav = "Dashboard";
return(View(addJobListingWithTemplateViewModel));
}
private void displayTable(object sender, EventArgs e, String s)
{
//initial set up...Counter for the number of rows, and
int countTotalJobs = 0;
String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection(connectionString);
sc.Open();
System.Data.SqlClient.SqlCommand countJobPostings = new System.Data.SqlClient.SqlCommand();
//This indicates that all interest groups were selected/default!
if (s.Equals(" "))
{
//default
countJobPostings.CommandText = "SELECT count( SchoolApproval.OpportunityEntityID) FROM OpportunityEntity INNER JOIN SchoolApproval ON " +
"OpportunityEntity.OpportunityEntityID = SchoolApproval.OpportunityEntityID where OpportunityEntity.OpportunityType = 'JOB' and schoolApproval.approvedflag = 'Y'" +
" and SchoolApproval.SchoolEntityID = " + Session["schoolID"];
}
//This indicates that there were some interest groups that were selected in the drop down menu
else
{
//have to utilize distinct due to the nature of data duplication with interest groups. Cannot have two cards that are exactly the same
countJobPostings.CommandText = "SELECT COUNT(DISTINCT OpportunityEntity.OpportunityEntityID) AS Expr1 FROM OpportunityEntity INNER JOIN " +
"OpportunityInterestGroups ON OpportunityEntity.OpportunityEntityID = OpportunityInterestGroups.OpportunityEntityID INNER JOIN " +
"InterestGroups ON OpportunityInterestGroups.InterestGroupID = InterestGroups.InterestGroupID INNER JOIN " +
"SchoolApproval ON OpportunityEntity.OpportunityEntityID = SchoolApproval.OpportunityEntityID WHERE(OpportunityEntity.OpportunityType = 'JOB') " +
"AND(SchoolApproval.SchoolEntityID = 12) AND(SchoolApproval.ApprovedFlag = 'Y') and (" + s + ")";
}
String test = s;
countJobPostings.Connection = sc;
System.Data.SqlClient.SqlDataReader reader = countJobPostings.ExecuteReader();
while (reader.Read())
{
countTotalJobs = reader.GetInt32(0);
}
sc.Close();
sc.Open();
System.Data.SqlClient.SqlCommand pullJobInfo = new System.Data.SqlClient.SqlCommand();
if (s.Equals(" "))
{
pullJobInfo.CommandText = "SELECT Organization.OrganizationName, JobListing.JobTitle, JobListing.JobDescription," +
" Organization.Image, Organization.ExternalLink, JobListing.Location, JobListing.Deadline, JobListing.NumOfApplicants, Organization.OrganizationDescription," +
" JobListing.JobListingID FROM SchoolApproval INNER JOIN OpportunityEntity ON SchoolApproval.OpportunityEntityID = OpportunityEntity.OpportunityEntityID INNER JOIN JobListing" +
" ON OpportunityEntity.OpportunityEntityID = JobListing.JobListingID INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID " +
"where SchoolApproval.ApprovedFlag = 'Y' and OpportunityEntity.OpportunityType = 'JOB' and SchoolApproval.SchoolEntityID = " + Session["schoolID"];
}
else
{
pullJobInfo.CommandText = "SELECT distinct Organization.OrganizationName, JobListing.JobTitle, JobListing.JobDescription, Organization.Image, " +
"Organization.ExternalLink, JobListing.Location, JobListing.Deadline, JobListing.NumOfApplicants, Organization.OrganizationDescription, " +
"JobListing.JobListingID FROM " +
"SchoolApproval INNER JOIN OpportunityEntity ON SchoolApproval.OpportunityEntityID = OpportunityEntity.OpportunityEntityID INNER JOIN JobListing ON " +
"OpportunityEntity.OpportunityEntityID = JobListing.JobListingID INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID INNER JOIN " +
" OpportunityInterestGroups ON OpportunityEntity.OpportunityEntityID = OpportunityInterestGroups.OpportunityEntityID WHERE(SchoolApproval.ApprovedFlag = 'Y') AND OpportunityEntity.OpportunityType = 'JOB' and " +
"(SchoolApproval.SchoolEntityID = 12) and (" + s + ")";
}
pullJobInfo.Connection = sc;
reader = pullJobInfo.ExecuteReader();
{
//Make the list
List <JobListing> jobs = new List <JobListing>();
int jobListingID;
String orgName;
String jobTitle;
String jobDescription;
String image;
String link;
String jobLocation;
int numOfApplicants;
String organizationDescription;
DateTime deadline;
int x = 0;
while (reader.Read())
{
orgName = reader.GetString(0);
jobTitle = reader.GetString(1);
jobDescription = reader.GetString(2);
image = reader.GetString(3);
link = reader.GetString(4);
jobLocation = reader.GetString(5);
deadline = reader.GetDateTime(6);
numOfApplicants = reader.GetInt32(7);
organizationDescription = reader.GetString(8);
jobListingID = reader.GetInt32(9);
x++;
JobListing job = new JobListing(jobTitle, jobDescription, jobLocation, deadline, numOfApplicants, orgName, organizationDescription,
image, link);
//Set this to be used later
job.setID(jobListingID);
//Make the object
//Add to list
jobs.Add(job);
}
sc.Close();
double doubleRows = countTotalJobs / 3.0;
int numrows = (int)(Math.Ceiling(doubleRows));
int numcells = 3;
int count = 0;
for (int j = 0; j < numrows; j++)
{
TableRow r = new TableRow();
for (int i = 0; i < numcells; i++)
{
if (count == countTotalJobs)
{
break;
}
TableCell c = new TableCell();
LinkButton referralLink = new LinkButton();
referralLink.ID = "referralLink" + count;
referralLink.CssClass = "far fa-paper-plane";
referralLink.CommandArgument += jobs[count].getID();
referralLink.Command += new CommandEventHandler(this.referralButton_Click);
c.Controls.Add(new LiteralControl("<div class='image-flip' ontouchstart='this.classList.toggle('hover');'>"));
c.Controls.Add(new LiteralControl("<div class='mainflip'>"));
c.Controls.Add(new LiteralControl("<div class='frontside'>"));
c.Controls.Add(new LiteralControl("<div class='card'>"));
c.Controls.Add(new LiteralControl("<div class='card-body text-center'>"));
c.Controls.Add(new LiteralControl("<p><img class='img-fluid' src='" + jobs[count].getOrgImage() + "' alt='card image'></p>"));
c.Controls.Add(new LiteralControl("<h4 class='card-title'>" + jobs[count].getOrgName() + "</h4>"));
c.Controls.Add(new LiteralControl("<p class='card-text'>" + jobs[count].getJobTitle() + "</p>"));
c.Controls.Add(new LiteralControl("<a href='#' class='btn btn-primary btn-sm'><i class='fa fa-plus'></i></a>"));
c.Controls.Add(new LiteralControl("</div>"));
c.Controls.Add(new LiteralControl("</div>"));
c.Controls.Add(new LiteralControl("</div>"));
c.Controls.Add(new LiteralControl("<div class='backside'>"));
c.Controls.Add(new LiteralControl("<div class='card'>"));
c.Controls.Add(new LiteralControl("<div class='card-body text-center'>"));
c.Controls.Add(new LiteralControl("<h4 class='card-title'>" + jobs[count].getOrgName() + "</h4>"));
c.Controls.Add(new LiteralControl("<p class='card-text'>" + jobs[count].getJobTitle() + "</p>"));
c.Controls.Add(new LiteralControl("<p class='card-text'> Location: " + jobs[count].getJobLocation() + "</p>"));
c.Controls.Add(new LiteralControl("<p class='card-text'> Deadline: " + jobs[count].getJobDeadline().ToString() + "</p>"));
c.Controls.Add(new LiteralControl("<p class='card-text'> Number of Applicants: " + jobs[count].getNumOfApplicants() + "</p>"));
c.Controls.Add(new LiteralControl("<ul class='list-inline'>"));
c.Controls.Add(new LiteralControl("<li class='list-inline-item'>"));
c.Controls.Add(new LiteralControl("<a class='social-icon text-xs-center' target='_blank' href='" + jobs[count].getOrgWebsite() + "'>"));
c.Controls.Add(new LiteralControl("<i class='fas fa-external-link-alt'></i> "));
//c.Controls.Add(referralLink);
c.Controls.Add(new LiteralControl("</a>"));
c.Controls.Add(new LiteralControl("</li>"));
c.Controls.Add(new LiteralControl("</ul>"));
c.Controls.Add(new LiteralControl("</div>"));
c.Controls.Add(new LiteralControl("</div>"));
c.Controls.Add(new LiteralControl("</div>"));
c.Controls.Add(new LiteralControl("</div>"));
c.Controls.Add(new LiteralControl("</div>"));
c.Style.Add("width", "33%");
r.Cells.Add(c);
count++;
}
jobPostingTable.Rows.Add(r);
}
}
}
public void EditJobListing(JobListing jobListing)
{
_dbContext.Update(jobListing);
_dbContext.SaveChanges();
}
public void DeleteJobListing(JobListing jobListing)
{
jobListing.IsActive = 0;
_dbContext.JobListings.Update(jobListing);
_dbContext.SaveChanges();
}
internal JobListing Create(JobListing newJob)
{
return(_repo.Create(newJob));
}
public int AddJobListing(JobListing jobListing, int userId)
{
_dbContext.JobListings.Add(jobListing);
_dbContext.SaveChanges();
return(jobListing.JobListingId);
}
public abstract void DeleteJobListing(JobListing listing);
public bool DeleteJobListing(JobListing jobListing)
{
db.JobListings.Remove(jobListing);
return(Save());
}
public bool UpdateJobListing(JobListing jobListing)
{
db.JobListings.Attach(jobListing);
db.Update(jobListing);
return(Save());
}
protected void Page_Load(object sender, EventArgs e)
{
// Card Arrays
JobListing[] JobCardsArray = new JobListing[5];
Student[] StudentCardsArray = new Student[5];
JobListing[] StudentCardJobInfoArray = new JobListing[5];
((Label)Master.FindControl("lblMaster")).Text = "Landing Page";
EmptyPostinglbl.Visible = false;
EmptyStudentslbl.Visible = false;
String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString);
sql.Open();
System.Data.SqlClient.SqlCommand RecentJobs = new System.Data.SqlClient.SqlCommand();
RecentJobs.Connection = sql;
RecentJobs.CommandText = "SELECT TOP (5) JobListing.JobListingID, JobListing.JobTitle, Organization.Image, Organization.OrganizationName, JobListing.JobType, JobListing.JobDescription, JobListing.Location, JobListing.NumOfApplicants, JobListing.Deadline, Organization.OrganizationDescription, Organization.ExternalLink FROM SchoolApproval INNER JOIN OpportunityEntity ON SchoolApproval.OpportunityEntityID = OpportunityEntity.OpportunityEntityID INNER JOIN JobListing" +
" ON OpportunityEntity.OpportunityEntityID = JobListing.JobListingID INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID " +
"where SchoolApproval.ApprovedFlag = 'P' and SchoolApproval.SchoolEntityID = " + Session["schoolID"] + " ORDER BY JobListing.JobListingID DESC";
System.Data.SqlClient.SqlDataReader reader = RecentJobs.ExecuteReader();
// Attempting OOP Stuff
int x = 0;
while (reader.Read())
{
String JobTitle = reader.GetString(1);
String JobDescription = reader.GetString(5);
String JobType = reader.GetString(4);
String JobLocation = reader.GetString(6);
DateTime JobDeadline = reader.GetDateTime(8);
int numOfApplicants = reader.GetInt32(7);
String OrgName = reader.GetString(3);
String OrgDescription = reader.GetString(9);
String OrgImage = reader.GetString(2);
String OrgWebsite = reader.GetString(10);
JobListing tempObject = new JobListing(JobTitle, JobDescription, JobType, JobLocation, JobDeadline, numOfApplicants, OrgName, OrgDescription, OrgImage, OrgWebsite);
JobCardsArray[x] = tempObject;
x++;
}
// OOP First Card
if (JobCardsArray[0] != null)
{
Image1.ImageUrl = JobCardsArray[0].getOrgImage();
CompanyNamelbl.Text = JobCardsArray[0].getOrgName();
JobTitlelbl.Text = JobCardsArray[0].getJobTitle();
CompanyNamelbl2.Text = JobCardsArray[0].getOrgName();
lblJOrganizationDescription.Text = JobCardsArray[0].getJobDescription();
lblJobType.Text = JobCardsArray[0].getJobType();
lblOrgDescription.Text = JobCardsArray[0].getOrgDescription();
JobLink1.NavigateUrl = JobCardsArray[0].getOrgWebsite();
}
// OOP Second Card
if (JobCardsArray[1] != null)
{
Image2.ImageUrl = JobCardsArray[1].getOrgImage();
CompanyNamelbl3.Text = JobCardsArray[1].getOrgName();
JobTitlelbl2.Text = JobCardsArray[1].getJobTitle();
CompanyNamelbl4.Text = JobCardsArray[1].getOrgName();
lblJOrganizationDescription2.Text = JobCardsArray[1].getJobDescription();
lblJobType2.Text = JobCardsArray[1].getJobType();
lblOrgDescription2.Text = JobCardsArray[1].getOrgDescription();
JobLink2.NavigateUrl = JobCardsArray[1].getOrgWebsite();
}
// OOP Third Card
if (JobCardsArray[2] != null)
{
Image3.ImageUrl = JobCardsArray[2].getOrgImage();
CompanyNamelbl5.Text = JobCardsArray[2].getOrgName();
JobTitlelbl3.Text = JobCardsArray[2].getJobTitle();
CompanyNamelbl6.Text = JobCardsArray[2].getOrgName();
lblJOrganizationDescription3.Text = JobCardsArray[2].getJobDescription();
lblJobType3.Text = JobCardsArray[2].getJobType();
lblOrgDescription3.Text = JobCardsArray[2].getOrgDescription();
JobLink3.NavigateUrl = JobCardsArray[2].getOrgWebsite();
}
// OOP Fourth Card
if (JobCardsArray[3] != null)
{
Image4.ImageUrl = JobCardsArray[3].getOrgImage();
CompanyNamelbl7.Text = JobCardsArray[3].getOrgName();
JobTitlelbl4.Text = JobCardsArray[3].getJobTitle();
CompanyNamelbl8.Text = JobCardsArray[3].getOrgName();
lblJOrganizationDescription4.Text = JobCardsArray[3].getJobDescription();
lblJobType4.Text = JobCardsArray[3].getJobType();
lblOrgDescription4.Text = JobCardsArray[3].getOrgDescription();
JobLink4.NavigateUrl = JobCardsArray[3].getOrgWebsite();
}
sql.Close();
if (JobCardsArray[0] == null)
{
card1.Visible = false;
card2.Visible = false;
card3.Visible = false;
card4.Visible = false;
EmptyPostinglbl.Visible = true;
}
else if (JobCardsArray[3] == null && JobCardsArray[2] == null && JobCardsArray[1] == null)
{
card4.Visible = false;
card3.Visible = false;
card2.Visible = false;
}
else if (JobCardsArray[3] == null && JobCardsArray[2] == null)
{
card4.Visible = false;
card3.Visible = false;
}
else if (JobCardsArray[3] == null)
{
card4.Visible = false;
}
else
{
}
// Team member queries and setting
sql.Open();
System.Data.SqlClient.SqlCommand RecentRequests = new System.Data.SqlClient.SqlCommand();
RecentRequests.Connection = sql;
RecentRequests.CommandText = "SELECT TOP (5) ApplicationRequest.ApplicationID, JobListing.JobTitle, Organization.OrganizationName, Student.StudentGPA, Student.StudentImage, Organization.ExternalLink, Student.FirstName, Student.LastName FROM ApplicationRequest INNER JOIN JobListing ON ApplicationRequest.JobListingID = JobListing.JobListingID INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID INNER JOIN Student ON ApplicationRequest.StudentEntityID = Student.StudentEntityID WHERE (ApplicationRequest.ApprovedFlag = 'P') AND (Student.SchoolEntityID = '12') ORDER BY ApplicationRequest.ApplicationID DESC";
System.Data.SqlClient.SqlDataReader result = RecentRequests.ExecuteReader();
int y = 0;
while (result.Read())
{
// Stopped here, query in google drive, need to change query so results are stored in a student and joblisting object and add them to arrays, then set lbls based on arrays, need to make first and last name separate labels on cards
int applicationID = result.GetInt32(0);
String firstName = result.GetString(6);
String lastName = result.GetString(7);
double studentGPA = result.GetDouble(3);
String studentImage = result.GetString(4);
String jobTitle = result.GetString(1);
String orgName = result.GetString(2);
String orgWebsite = result.GetString(5);
Student tempStudent = new Student(applicationID, firstName, lastName, studentGPA, studentImage);
JobListing tempJob = new JobListing(jobTitle, orgName, orgWebsite);
StudentCardsArray[y] = tempStudent;
StudentCardJobInfoArray[y] = tempJob;
y++;
}
// OOP First Student Request Card
if (StudentCardsArray[0] != null)
{
StudentImage.ImageUrl = StudentCardsArray[0].getStudentImage();
FrontStudentName.Text = StudentCardsArray[0].getFirstName() + " " + StudentCardsArray[0].getLastName();
BackStudentName.Text = StudentCardsArray[0].getFirstName() + " " + StudentCardsArray[0].getLastName();
StudentJobTitlelbl.Text = StudentCardJobInfoArray[0].getJobTitle();
OrgTitlelbl.Text = StudentCardJobInfoArray[0].getOrgName();
StudentGPAlbl.Text = StudentCardsArray[0].getStudentGPA().ToString();
StudentLink1.NavigateUrl = StudentCardJobInfoArray[0].getOrgWebsite();
}
// OOP Second Student Request Card
if (StudentCardsArray[1] != null)
{
StudentImage2.ImageUrl = StudentCardsArray[1].getStudentImage();
FrontStudentName2.Text = StudentCardsArray[1].getFirstName() + " " + StudentCardsArray[1].getLastName();
BackStudentName2.Text = StudentCardsArray[1].getFirstName() + " " + StudentCardsArray[1].getLastName();
StudentJobTitlelbl2.Text = StudentCardJobInfoArray[1].getJobTitle();
OrgTitlelbl2.Text = StudentCardJobInfoArray[1].getOrgName();
StudentGPAlbl2.Text = StudentCardsArray[1].getStudentGPA().ToString();
StudentLink2.NavigateUrl = StudentCardJobInfoArray[1].getOrgWebsite();
}
// OOP Third Student Request Card
if (StudentCardsArray[2] != null)
{
StudentImage3.ImageUrl = StudentCardsArray[2].getStudentImage();
FrontStudentName3.Text = StudentCardsArray[2].getFirstName() + " " + StudentCardsArray[2].getLastName();
BackStudentName3.Text = StudentCardsArray[2].getFirstName() + " " + StudentCardsArray[2].getLastName();
StudentJobTitlelbl3.Text = StudentCardJobInfoArray[2].getJobTitle();
OrgTitlelbl3.Text = StudentCardJobInfoArray[2].getOrgName();
StudentGPAlbl3.Text = StudentCardsArray[2].getStudentGPA().ToString();
StudentLink3.NavigateUrl = StudentCardJobInfoArray[2].getOrgWebsite();
}
// OOP Fourth Student Request Card
if (StudentCardsArray[3] != null)
{
StudentImage4.ImageUrl = StudentCardsArray[3].getStudentImage();
FrontStudentName4.Text = StudentCardsArray[3].getFirstName() + " " + StudentCardsArray[3].getLastName();
BackStudentName4.Text = StudentCardsArray[3].getFirstName() + " " + StudentCardsArray[3].getLastName();
StudentJobTitlelbl4.Text = StudentCardJobInfoArray[3].getJobTitle();
OrgTitle4.Text = StudentCardJobInfoArray[3].getOrgName();
StudentGPAlbl4.Text = StudentCardsArray[3].getStudentGPA().ToString();
StudentLink4.NavigateUrl = StudentCardJobInfoArray[3].getOrgWebsite();
}
sql.Close();
if (StudentCardsArray[0] == null)
{
StudentCard1.Visible = false;
StudentCard2.Visible = false;
StudentCard3.Visible = false;
StudentCard4.Visible = false;
EmptyStudentslbl.Visible = true;
}
else if (StudentCardsArray[3] == null && StudentCardsArray[2] == null && StudentCardsArray[1] == null)
{
StudentCard4.Visible = false;
StudentCard3.Visible = false;
StudentCard2.Visible = false;
}
else if (StudentCardsArray[3] == null && StudentCardsArray[2] == null)
{
StudentCard4.Visible = false;
StudentCard3.Visible = false;
}
else if (StudentCardsArray[3] == null)
{
StudentCard4.Visible = false;
}
else
{
}
// Start of Tableau Charts
if (Session["schoolID"].Equals(12))
{
LouisaDesktop.Visible = true;
LouisaTablet.Visible = true;
LousiaPhone.Visible = true;
}
else if (Session["schoolID"].Equals(15))
{
TurnerDesktop.Visible = true;
TurnerTablet.Visible = true;
TurnerPhone.Visible = true;
}
}
public override void DeleteJobListing(JobListing listing)
{
throw new NotSupportedException();
}
