//==================================================================================//
// Get Academic information //
// //
// Gets the academic information if it is not empty. //
// //
// Note: If the User ID is -1 then it is being checked out by the user. //
// If not then it is being checked by the admin. //
//==================================================================================//
public static AcademicModel GetAcademicdData(AcademicModel academic, int UserId)
{
// If the User ID is -1 then it is being checked out by the user. We will then
// get the current user ID.
if (UserId == -1)
{
UserId = WebSecurity.CurrentUserId;
}
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var ExistingAcademic = from r in context.ProspectiveAcademic
where r.AcademicId == UserId
select r;
// If the user has some information then edit it.
// Otherwise return nothing.
if (ExistingAcademic.Count() > 0)
{
academic.AccountStatus = ExistingAcademic.FirstOrDefault().Status;
academic.AcademyName = ExistingAcademic.FirstOrDefault().AcademyName;
academic.AcademyAddress = ExistingAcademic.FirstOrDefault().AcademyAddress;
academic.PrimaryContactName = ExistingAcademic.FirstOrDefault().PrimaryContactName;
academic.PrimaryTitle = ExistingAcademic.FirstOrDefault().PrimaryTitle;
academic.PrimaryTelephone = ExistingAcademic.FirstOrDefault().PrimaryTelephone;
academic.PrimaryEmailAddress = ExistingAcademic.FirstOrDefault().PrimaryEmailAddress;
academic.SecondaryContactName = ExistingAcademic.FirstOrDefault().SecondaryContactName;
academic.SecondaryTitle = ExistingAcademic.FirstOrDefault().SecondaryTitle;
academic.SecondaryTelephone = ExistingAcademic.FirstOrDefault().SecondaryTelephone;
academic.SecondaryEmailAddress = ExistingAcademic.FirstOrDefault().SecondaryEmailAddress;
academic.ImageUploaded = ExistingAcademic.FirstOrDefault().ImageUploaded;
academic.AcademicInstitutionTextField = ExistingAcademic.FirstOrDefault().AcademicInstitutionTextField;
// Return the modal that is filled with information from the database.
return (academic);
}
else
{
return (null);
}
}
}
catch
{
return (null);
}
}
//==================================================================================//
// Store Admin information //
// //
// Register the admin information if it is empty. Otherwise edit it. //
// //
// Note: If the edit is true then the account is being edited. //
// Otherwise it is being registered. //
//==================================================================================//
public static bool StoreAdminData(RegisterModel regAdmin, ref bool edit)
{
int UserId = WebSecurity.GetUserId(regAdmin.EmailAddress);
edit = false;
try
{
SiteAdmin CurrentAdmin;
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var AdminData = from r in context.SiteAdmin
where r.UserId == UserId
select r;
// If the user has some information then edit it.
// Otherwise register the account.
if (AdminData.Count() > 0 && UserId > 0)
{
CurrentAdmin = AdminData.FirstOrDefault();
CurrentAdmin.Status = regAdmin.AccountStatus;
CurrentAdmin.Company = regAdmin.CompanyName;
CurrentAdmin.EmailAddress = regAdmin.EmailAddress;
CurrentAdmin.Name = regAdmin.Name;
CurrentAdmin.Telephone = regAdmin.Telephone;
CurrentAdmin.UserId = UserId;
// Store the avatar if it is supplied.
if (regAdmin.ImageFile != null)
{
UserImage image = new UserImage();
using (MemoryStream ms = new MemoryStream())
{
regAdmin.ImageFile.InputStream.CopyTo(ms);
image.FileContent = ms.ToArray();
image.FileName = Path.GetFileName(regAdmin.ImageFile.FileName);
image.ContentType = regAdmin.ImageFile.ContentType;
image.ContentLength = regAdmin.ImageFile.ContentLength;
DatabaseHelper.UploadImage(image, CurrentAdmin.UserId);
CurrentAdmin.ImageUploaded = "Yes";
regAdmin.ImageUploaded = "Yes";
}
}
edit = true;
}
else
{
CurrentAdmin = new SiteAdmin();
CurrentAdmin.Status = regAdmin.AccountStatus;
CurrentAdmin.Company = regAdmin.CompanyName;
CurrentAdmin.Name = regAdmin.Name;
CurrentAdmin.EmailAddress = regAdmin.EmailAddress;
CurrentAdmin.Telephone = regAdmin.Telephone;
context.AddToSiteAdmin(CurrentAdmin);
}
try
{
// If the account is edited then save changes. Otherwise register the account.
if (edit == false)
{
WebSecurity.CreateUserAndAccount(regAdmin.EmailAddress, regAdmin.Password);
DatabaseHelper.AddUserToRole(regAdmin.EmailAddress, "Admin");
CurrentAdmin.UserId = WebSecurity.GetUserId(regAdmin.EmailAddress);
// Store the avatar if it is supplied.
if (regAdmin.ImageFile != null)
{
UserImage image = new UserImage();
using (MemoryStream ms = new MemoryStream())
{
regAdmin.ImageFile.InputStream.CopyTo(ms);
image.FileContent = ms.ToArray();
image.FileName = Path.GetFileName(regAdmin.ImageFile.FileName);
image.ContentType = regAdmin.ImageFile.ContentType;
image.ContentLength = regAdmin.ImageFile.ContentLength;
DatabaseHelper.UploadImage(image, CurrentAdmin.UserId);
CurrentAdmin.ImageUploaded = "Yes";
regAdmin.ImageUploaded = "Yes";
}
}
else
{
CurrentAdmin.ImageUploaded = "No";
regAdmin.ImageUploaded = "No";
}
}
context.SaveChanges();
return true;
}
catch (Exception ex)
{
string errorMessage = ex.Message;
return false;
}
}
}
catch (Exception ex)
{
string exMessage = ex.Message;
return false;
}
}
//==================================================================================//
// Store Academic information //
// //
// Register the academic information if it is empty. Otherwise edit it. //
// //
// Note: If the edit is true then the account is being edited. //
// Otherwise it is being registered. //
//==================================================================================//
public static bool StoreAcademicData(AcademicModel academic, ref bool edit)
{
int UserId = WebSecurity.GetUserId(academic.PrimaryEmailAddress);
edit = false;
try
{
ProspectiveAcademic CurrentAcademic;
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var AcademicData = from r in context.ProspectiveAcademic
where r.AcademicId == UserId
select r;
// If the user has some information then edit it.
// Otherwise register the account.
if (AcademicData.Count() > 0 && UserId > 0)
{
CurrentAcademic = AcademicData.FirstOrDefault();
CurrentAcademic.Status = academic.AccountStatus;
CurrentAcademic.AcademyAddress = academic.AcademyAddress;
CurrentAcademic.AcademyName = academic.AcademyName;
CurrentAcademic.PrimaryContactName = academic.PrimaryContactName;
CurrentAcademic.PrimaryEmailAddress = academic.PrimaryEmailAddress;
CurrentAcademic.PrimaryTitle = academic.PrimaryTitle;
CurrentAcademic.PrimaryTelephone = academic.PrimaryTelephone;
CurrentAcademic.SecondaryContactName = academic.SecondaryContactName;
CurrentAcademic.SecondaryEmailAddress = academic.SecondaryEmailAddress;
CurrentAcademic.SecondaryTitle = academic.SecondaryTitle;
CurrentAcademic.SecondaryTelephone = academic.SecondaryTelephone;
CurrentAcademic.AcademicInstitutionTextField = academic.AcademicInstitutionTextField;
CurrentAcademic.AcademicId = UserId;
// Store the avatar if it is supplied.
if (academic.ImageFile != null)
{
UserImage image = new UserImage();
using (MemoryStream ms = new MemoryStream())
{
academic.ImageFile.InputStream.CopyTo(ms);
image.FileContent = ms.ToArray();
image.FileName = Path.GetFileName(academic.ImageFile.FileName);
image.ContentType = academic.ImageFile.ContentType;
image.ContentLength = academic.ImageFile.ContentLength;
DatabaseHelper.UploadImage(image, CurrentAcademic.AcademicId);
CurrentAcademic.ImageUploaded = "Yes";
academic.ImageUploaded = "Yes";
}
}
edit = true;
}
else
{
CurrentAcademic = new ProspectiveAcademic();
CurrentAcademic.Status = academic.AccountStatus;
CurrentAcademic.AcademyAddress = academic.AcademyAddress;
CurrentAcademic.AcademyName = academic.AcademyName;
CurrentAcademic.PrimaryContactName = academic.PrimaryContactName;
CurrentAcademic.PrimaryEmailAddress = academic.PrimaryEmailAddress;
CurrentAcademic.PrimaryTitle = academic.PrimaryTitle;
CurrentAcademic.PrimaryTelephone = academic.PrimaryTelephone;
CurrentAcademic.SecondaryContactName = academic.SecondaryContactName;
CurrentAcademic.SecondaryEmailAddress = academic.SecondaryEmailAddress;
CurrentAcademic.SecondaryTitle = academic.SecondaryTitle;
CurrentAcademic.SecondaryTelephone = academic.SecondaryTelephone;
CurrentAcademic.AcademicInstitutionTextField = academic.AcademicInstitutionTextField;
context.AddToProspectiveAcademic(CurrentAcademic);
}
try
{
// If the account is edited then save changes. Otherwise register the account.
if (edit == false)
{
WebSecurity.CreateUserAndAccount(academic.PrimaryEmailAddress, academic.Password);
WebSecurity.Login(academic.PrimaryEmailAddress, academic.Password);
DatabaseHelper.AddUserToRole(academic.PrimaryEmailAddress, "Educator");
CurrentAcademic.AcademicId = WebSecurity.GetUserId(academic.PrimaryEmailAddress);
// Store the avatar if it is supplied.
if (academic.ImageFile != null)
{
UserImage image = new UserImage();
using (MemoryStream ms = new MemoryStream())
{
academic.ImageFile.InputStream.CopyTo(ms);
image.FileContent = ms.ToArray();
image.FileName = Path.GetFileName(academic.ImageFile.FileName);
image.ContentType = academic.ImageFile.ContentType;
image.ContentLength = academic.ImageFile.ContentLength;
DatabaseHelper.UploadImage(image, CurrentAcademic.AcademicId);
CurrentAcademic.ImageUploaded = "Yes";
academic.ImageUploaded = "Yes";
}
}
else
{
CurrentAcademic.ImageUploaded = "No";
academic.ImageUploaded = "No";
}
}
context.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
catch
{
return false;
}
}
//==================================================================================//
// Remove Prospect Student Transcript. //
// //
// Removes the prospective student transcript if it is not empty. //
//==================================================================================//
public static bool RemoveTranscript(int UserId)
{
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var UserTranscript = from r in context.ProspectiveStudentTranscripts
where r.UserId == UserId
select r;
// If the user has a transcript then update it.
// Otherwise make a new row in the database.
if (UserTranscript.Count() > 0 && UserId > 0)
{
context.DeleteObject(UserTranscript.FirstOrDefault());
}
else
{
return false;
}
try
{
context.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
catch (Exception ex)
{
string exMessage = ex.Message;
return false;
}
}
//==================================================================================//
// Remove Sponsor information //
// //
// Removes the sponsor information if it is not empty. //
// //
// Note: If the User ID is -1 then it is being checked out by the user. //
// If not then it is being checked by the admin. //
//==================================================================================//
public static bool RemoveSponsorData(int UserId)
{
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var SponsorData = from r in context.ProspectiveCorporateSponsor
where r.SponsorId == UserId
select r;
// If the user has some information then remove it.
// Otherwise return false.
if (SponsorData.Count() > 0 && UserId > 0)
{
context.DeleteObject(SponsorData.FirstOrDefault());
}
else
{
return false;
}
try
{
context.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
catch (Exception ex)
{
string exMessage = ex.Message;
return false;
}
}
//==================================================================================//
// Get Prospect Student Transcript. //
// //
// Gets the prospective student transcript if it is not empty. //
//==================================================================================//
public static ProspectiveStudentTranscript GetTranscript(int UserId)
{
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var transcript = from r in context.ProspectiveStudentTranscripts
where r.UserId == UserId
select r;
// If the user has a transcript then return it.
// Otherwise return nothing.
if (transcript.Count() > 0)
{
return (transcript.FirstOrDefault());
}
else
{
return null;
}
}
}
catch
{
return (null);
}
}
//==================================================================================//
// Get Prospect Student Resume. //
// //
// Gets the prospective student resume if it is not empty. //
//==================================================================================//
public static ProspectiveStudentResume GetResume(int UserId)
{
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var resume = from r in context.ProspectiveStudentResumes
where r.UserId == UserId
select r;
// If the user has a resume then return it.
// Otherwise return nothing.
if (resume.Count() > 0)
{
//return File(resume.FirstOrDefault().FileContent, resume.FirstOrDefault().ContentType);
return (resume.FirstOrDefault());
}
else
{
return null;
}
}
}
catch
{
return (null);
}
}
//==================================================================================//
// Get Sponsor information //
// //
// Gets the sponsor information if it is not empty. //
// //
// Note: If the User ID is -1 then it is being checked out by the user. //
// If not then it is being checked by the admin. //
//==================================================================================//
public static SponsorModel GetSponsorData(SponsorModel spons, int UserId)
{
// If the User ID is -1 then it is being checked out by the user. We will then
// get the current user ID.
if (UserId == -1)
{
UserId = WebSecurity.CurrentUserId;
}
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var corporatesponsor = from r in context.ProspectiveCorporateSponsor
where r.SponsorId == UserId
select r;
// If the user has some information then edit it.
// Otherwise return nothing.
if (corporatesponsor.Count() > 0)
{
spons.AccountStatus = corporatesponsor.FirstOrDefault().Status;
spons.CompanyName = corporatesponsor.FirstOrDefault().CompanyName;
spons.CompanyAddress = corporatesponsor.FirstOrDefault().CompanyAddress;
spons.ContactName = corporatesponsor.FirstOrDefault().ContactName;
spons.Title = corporatesponsor.FirstOrDefault().Title;
spons.Telephone = corporatesponsor.FirstOrDefault().Telephone;
spons.EmailAddress = corporatesponsor.FirstOrDefault().EmailAddress;
spons.Reason = corporatesponsor.FirstOrDefault().Reason;
spons.ImageUploaded = corporatesponsor.FirstOrDefault().ImageUploaded;
spons.SponsorTextField = corporatesponsor.FirstOrDefault().SponsorPageTextField;
// Return the modal that is filled with information from the database.
return (spons);
}
else
{
return (null);
}
}
}
catch
{
return (null);
}
}
//==================================================================================//
// Get Prospect Student Image. //
// //
// Gets the prospective student image if it is not empty. //
//==================================================================================//
public static UserImage GetImage(int UserId)
{
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var image = from r in context.UserImage
where r.UserID == UserId
select r;
// If the user has an image then return it.
// Otherwise return nothing.
if (image.Count() > 0)
{
return (image.FirstOrDefault());
}
else
{
return null;
}
}
}
catch
{
return (null);
}
}
//==================================================================================//
// Get Prospect Student information //
// //
// Gets the prospect student information if it is not empty. //
// //
// Note: If the User ID is -1 then it is being checked out by the user. //
// If not then it is being checked by the admin. //
//==================================================================================//
public static ProspectModel GetProspectData(ProspectModel prospect, int UserId)
{
// If the User ID is -1 then it is being checked out by the user. We will then
// get the current user ID.
if (UserId == -1)
{
UserId = WebSecurity.CurrentUserId;
}
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var ExistingProspect = from r in context.ProspectiveStudent
where r.UserId == UserId
select r;
// If the user has some information then edit it.
// Otherwise return nothing.
if (ExistingProspect.Count() > 0)
{
prospect.AccountStatus = ExistingProspect.FirstOrDefault().Status;
prospect.Name = ExistingProspect.FirstOrDefault().Name;
prospect.Telephone = ExistingProspect.FirstOrDefault().Telephone;
prospect.EmailAddress = ExistingProspect.FirstOrDefault().EmailAddress;
prospect.DesiredCareerPath = ExistingProspect.FirstOrDefault().DesiredCareerPath;
prospect.Gender = ExistingProspect.FirstOrDefault().Gender;
prospect.ResumeUploaded = ExistingProspect.FirstOrDefault().ResumeUploaded;
prospect.TranscriptUploaded = ExistingProspect.FirstOrDefault().TranscriptUploaded;
prospect.ImageUploaded = ExistingProspect.FirstOrDefault().ImageUploaded;
prospect.ProspectiveStudentTextField = ExistingProspect.FirstOrDefault().ProspectiveStudentTextField;
// Return the modal that is filled with information from the database.
return (prospect);
}
else
{
return (null);
}
}
}
catch
{
return (null);
}
}
//==================================================================================//
// Upload Prospect Student Transcript. //
// //
// Uploads the prospective student transcript if it is not empty. //
//==================================================================================//
public static bool UploadTranscript(ProspectiveStudentTranscript f, ProspectModel prospect)
{
int UserId = WebSecurity.GetUserId(prospect.EmailAddress);
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var UserTranscript = from r in context.ProspectiveStudentTranscripts
where r.UserId == UserId
select r;
// If the user has a transcript then update it.
// Otherwise make a new row in the database.
if (UserTranscript.Count() > 0)
{
ProspectiveStudentTranscript currentTranscript = UserTranscript.FirstOrDefault();
currentTranscript.UserId = UserId;
currentTranscript.FileContent = f.FileContent;
currentTranscript.FileName = f.FileName;
currentTranscript.ContentLength = f.ContentLength;
context.SaveChanges();
return true;
}
else
{
f.UserId = UserId;
context.AddToProspectiveStudentTranscripts(f);
context.SaveChanges();
return true;
}
}
}
catch (Exception)
{
return false;
}
}
//==================================================================================//
// Upload Prospect Student Image. //
// //
// Uploads the prospective student image if it is not empty. //
//==================================================================================//
public static bool UploadImage(UserImage image, int UserId)
{
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var UserImage = from r in context.UserImage
where r.UserID == UserId
select r;
// If the user has an image then update it.
// Otherwise make a new row in the database.
if (UserImage.Count() > 0)
{
UserImage currentImage = UserImage.FirstOrDefault();
currentImage.UserID = UserId;
currentImage.FileContent = image.FileContent;
currentImage.FileName = image.FileName;
currentImage.ContentLength = image.ContentLength;
context.SaveChanges();
return true;
}
else
{
image.UserID = UserId;
context.AddToUserImage(image);
context.SaveChanges();
return true;
}
}
}
catch (Exception)
{
return false;
}
}
//==================================================================================//
// Store Sponsor information //
// //
// Register the sponsor information if it is empty. Otherwise edit it. //
// //
// Note: If the edit is true then the account is being edited. //
// Otherwise it is being registered. //
//==================================================================================//
public static bool StoreSponsorData(SponsorModel sponsor, ref bool edit)
{
int UserId = WebSecurity.GetUserId(sponsor.EmailAddress);
edit = false;
try
{
ProspectiveCorporateSponsor CurrentSponsor;
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var SponsorData = from r in context.ProspectiveCorporateSponsor
where r.SponsorId == UserId
select r;
// If the user has some information then edit it.
// Otherwise register the account.
if (SponsorData.Count() > 0 && UserId > 0)
{
CurrentSponsor = SponsorData.FirstOrDefault();
CurrentSponsor.Status = sponsor.AccountStatus;
CurrentSponsor.CompanyAddress = sponsor.CompanyAddress;
CurrentSponsor.CompanyName = sponsor.CompanyName;
CurrentSponsor.ContactName = sponsor.ContactName;
CurrentSponsor.EmailAddress = sponsor.EmailAddress;
CurrentSponsor.Title = sponsor.Title;
CurrentSponsor.Telephone = sponsor.Telephone;
CurrentSponsor.Reason = sponsor.Reason;
CurrentSponsor.SponsorPageTextField = sponsor.SponsorTextField;
CurrentSponsor.SponsorId = UserId;
// Store the avatar if it is supplied.
if (sponsor.ImageFile != null)
{
UserImage image = new UserImage();
using (MemoryStream ms = new MemoryStream())
{
sponsor.ImageFile.InputStream.CopyTo(ms);
image.FileContent = ms.ToArray();
image.FileName = Path.GetFileName(sponsor.ImageFile.FileName);
image.ContentType = sponsor.ImageFile.ContentType;
image.ContentLength = sponsor.ImageFile.ContentLength;
DatabaseHelper.UploadImage(image, CurrentSponsor.SponsorId);
CurrentSponsor.ImageUploaded = "Yes";
sponsor.ImageUploaded = "Yes";
}
}
edit = true;
}
else
{
CurrentSponsor = new ProspectiveCorporateSponsor();
CurrentSponsor.Status = sponsor.AccountStatus;
CurrentSponsor.CompanyAddress = sponsor.CompanyAddress;
CurrentSponsor.CompanyName = sponsor.CompanyName;
CurrentSponsor.ContactName = sponsor.ContactName;
CurrentSponsor.EmailAddress = sponsor.EmailAddress;
CurrentSponsor.Title = sponsor.Title;
CurrentSponsor.Telephone = sponsor.Telephone;
CurrentSponsor.Reason = sponsor.Reason;
CurrentSponsor.SponsorPageTextField = sponsor.SponsorTextField;
context.AddToProspectiveCorporateSponsor(CurrentSponsor);
}
try
{
// If the account is edited then save changes. Otherwise register the account.
if (edit == false)
{
WebSecurity.CreateUserAndAccount(sponsor.EmailAddress, sponsor.Password);
// User is automatically logged in here.
WebSecurity.Login(sponsor.EmailAddress, sponsor.Password);
DatabaseHelper.AddUserToRole(sponsor.EmailAddress, "Sponsor");
CurrentSponsor.SponsorId = WebSecurity.GetUserId(sponsor.EmailAddress);
// Store the avatar if it is supplied.
if (sponsor.ImageFile != null)
{
UserImage image = new UserImage();
using (MemoryStream ms = new MemoryStream())
{
sponsor.ImageFile.InputStream.CopyTo(ms);
image.FileContent = ms.ToArray();
image.FileName = Path.GetFileName(sponsor.ImageFile.FileName);
image.ContentType = sponsor.ImageFile.ContentType;
image.ContentLength = sponsor.ImageFile.ContentLength;
DatabaseHelper.UploadImage(image, CurrentSponsor.SponsorId);
CurrentSponsor.ImageUploaded = "Yes";
sponsor.ImageUploaded = "Yes";
}
}
else
{
CurrentSponsor.ImageUploaded = "No";
sponsor.ImageUploaded = "No";
}
}
context.SaveChanges();
return true;
}
catch (Exception e)
{
string errorMessage = e.Message;
return false;
}
}
}
catch (Exception ex)
{
string exMessage = ex.Message;
return false;
}
}
//==================================================================================//
// Get Admin information //
// //
// Gets the admin information if it is not empty. //
// //
// Note: If the User ID is -1 then it is being checked out by the user. //
// If not then it is being checked by the admin. //
//==================================================================================//
public static RegisterModel GetAdminData(RegisterModel regAdmin, int UserId)
{
// If the User ID is -1 then it is being checked out by the user. We will then
// get the current user ID.
if (UserId == -1)
{
UserId = WebSecurity.CurrentUserId;
}
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var currentAdmin = from r in context.SiteAdmin
where r.UserId == UserId
select r;
// If the user has some information then edit it.
// Otherwise return nothing.
if (currentAdmin.Count() > 0)
{
regAdmin.Name = currentAdmin.FirstOrDefault().Name;
regAdmin.AccountStatus = currentAdmin.FirstOrDefault().Status;
regAdmin.EmailAddress = currentAdmin.FirstOrDefault().EmailAddress;
regAdmin.CompanyName = currentAdmin.FirstOrDefault().Company;
regAdmin.Telephone = currentAdmin.FirstOrDefault().Telephone;
regAdmin.EmailAddress = currentAdmin.FirstOrDefault().EmailAddress;
regAdmin.ImageUploaded = currentAdmin.FirstOrDefault().ImageUploaded;
// Return the modal that is filled with information from the database.
return (regAdmin);
}
else
{
return (null);
}
}
}
catch
{
return (null);
}
}
//==================================================================================//
// Store Prospect Student information //
// //
// Register the prospective student information if it is //
// empty. Otherwise edit it. //
// //
// Note: If the edit is true then the account is being edited. //
// Otherwise it is being registered. //
//==================================================================================//
public static bool StoreProspectData(ProspectModel prospect, ref bool edit)
{
int UserId = WebSecurity.GetUserId(prospect.EmailAddress);
ProspectiveStudent CurrentStudent;
edit = false;
try
{
using (ITintheDTestTableEntities context = new ITintheDTestTableEntities())
{
// Put everything we find in the database in the var variable. All the
// information will be gotten using the User ID.
var ProspectData = from r in context.ProspectiveStudent
where r.UserId == UserId
select r;
// If the user has some information then edit it.
// Otherwise register the account.
if (ProspectData.Count() > 0 && UserId > 0)
{
edit = true;
CurrentStudent = ProspectData.FirstOrDefault();
CurrentStudent.Status = prospect.AccountStatus;
CurrentStudent.UserId = UserId;
CurrentStudent.Name = prospect.Name;
CurrentStudent.Telephone = prospect.Telephone;
CurrentStudent.EmailAddress = prospect.EmailAddress;
CurrentStudent.DesiredCareerPath = prospect.DesiredCareerPath;
CurrentStudent.Gender = prospect.Gender;
CurrentStudent.ProspectiveStudentTextField = prospect.ProspectiveStudentTextField;
// Store the avatar if it is supplied.
if (prospect.ImageFile != null)
{
UserImage image = new UserImage();
using (MemoryStream ms = new MemoryStream())
{
prospect.ImageFile.InputStream.CopyTo(ms);
image.FileContent = ms.ToArray();
image.FileName = Path.GetFileName(prospect.ImageFile.FileName);
image.ContentType = prospect.ImageFile.ContentType;
image.ContentLength = prospect.ImageFile.ContentLength;
DatabaseHelper.UploadImage(image, CurrentStudent.UserId);
CurrentStudent.ImageUploaded = "Yes";
prospect.ImageUploaded = "Yes";
}
}
// Store the new resume if it is supplied and not empty.
if (prospect.ResumeFile != null && prospect.ResumeFile.ContentLength > 0)
{
ProspectiveStudentResume Resume = new ProspectiveStudentResume();
using (MemoryStream ms = new MemoryStream())
{
prospect.ResumeFile.InputStream.CopyTo(ms);
Resume.FileContent = ms.ToArray();
Resume.FileName = Path.GetFileName(prospect.ResumeFile.FileName);
Resume.ContentType = prospect.ResumeFile.ContentType;
Resume.ContentLength = prospect.ResumeFile.ContentLength;
DatabaseHelper.UploadResume(Resume, prospect);
CurrentStudent.ResumeUploaded = "Yes";
prospect.ResumeUploaded = "Yes";
}
}
// Store the new transcript if it is supplied and not empty.
if (prospect.TranscriptFile != null && prospect.TranscriptFile.ContentLength > 0)
{
ProspectiveStudentTranscript Transcript = new ProspectiveStudentTranscript();
using (MemoryStream ts = new MemoryStream())
{
prospect.TranscriptFile.InputStream.CopyTo(ts);
Transcript.FileContent = ts.ToArray();
Transcript.FileName = Path.GetFileName(prospect.TranscriptFile.FileName);
Transcript.ContentType = prospect.TranscriptFile.ContentType;
Transcript.ContentLength = prospect.TranscriptFile.ContentLength;
DatabaseHelper.UploadTranscript(Transcript, prospect);
CurrentStudent.TranscriptUploaded = "Yes";
prospect.TranscriptUploaded = "Yes";
}
}
}
else
{
CurrentStudent = new ProspectiveStudent();
CurrentStudent.Status = prospect.AccountStatus;
CurrentStudent.Name = prospect.Name;
CurrentStudent.Telephone = prospect.Telephone;
CurrentStudent.EmailAddress = prospect.EmailAddress;
CurrentStudent.DesiredCareerPath = prospect.DesiredCareerPath;
CurrentStudent.Gender = prospect.Gender;
CurrentStudent.ProspectiveStudentTextField = prospect.ProspectiveStudentTextField;
context.AddToProspectiveStudent(CurrentStudent);
}
try
{
// If the account is edited then save changes. Otherwise register the account.
if (edit == false)
{
WebSecurity.CreateUserAndAccount(prospect.EmailAddress, prospect.Password);
// User is automatically logged in here.
WebSecurity.Login(prospect.EmailAddress, prospect.Password);
DatabaseHelper.AddUserToRole(prospect.EmailAddress, "Student");
CurrentStudent.UserId = WebSecurity.GetUserId(prospect.EmailAddress);
// Store the avatar if it is supplied.
if (prospect.ImageFile != null)
{
UserImage image = new UserImage();
using (MemoryStream ms = new MemoryStream())
{
prospect.ImageFile.InputStream.CopyTo(ms);
image.FileContent = ms.ToArray();
image.FileName = Path.GetFileName(prospect.ImageFile.FileName);
image.ContentType = prospect.ImageFile.ContentType;
image.ContentLength = prospect.ImageFile.ContentLength;
DatabaseHelper.UploadImage(image, CurrentStudent.UserId);
CurrentStudent.ImageUploaded = "Yes";
prospect.ImageUploaded = "Yes";
}
}
else
{
CurrentStudent.ImageUploaded = "No";
prospect.ImageUploaded = "No";
}
// Store the resume if it is supplied and not empty.
if (prospect.ResumeFile != null && prospect.ResumeFile.ContentLength > 0)
{
ProspectiveStudentResume Resume = new ProspectiveStudentResume();
using (MemoryStream ms = new MemoryStream())
{
prospect.ResumeFile.InputStream.CopyTo(ms);
Resume.FileContent = ms.ToArray();
Resume.FileName = Path.GetFileName(prospect.ResumeFile.FileName);
Resume.ContentType = prospect.ResumeFile.ContentType;
Resume.ContentLength = prospect.ResumeFile.ContentLength;
DatabaseHelper.UploadResume(Resume, prospect);
CurrentStudent.ResumeUploaded = "Yes";
prospect.ResumeUploaded = "Yes";
}
}
else
{
CurrentStudent.ResumeUploaded = "No";
prospect.ResumeUploaded = "No";
}
// Store the resume if it is supplied and not empty.
if (prospect.TranscriptFile != null && prospect.TranscriptFile.ContentLength > 0)
{
ProspectiveStudentTranscript Transcript = new ProspectiveStudentTranscript();
using (MemoryStream ts = new MemoryStream())
{
prospect.TranscriptFile.InputStream.CopyTo(ts);
Transcript.FileContent = ts.ToArray();
Transcript.FileName = Path.GetFileName(prospect.TranscriptFile.FileName);
Transcript.ContentType = prospect.TranscriptFile.ContentType;
Transcript.ContentLength = prospect.TranscriptFile.ContentLength;
DatabaseHelper.UploadTranscript(Transcript, prospect);
CurrentStudent.TranscriptUploaded = "Yes";
prospect.TranscriptUploaded = "Yes";
}
}
else
{
CurrentStudent.TranscriptUploaded = "No";
prospect.TranscriptUploaded = "No";
}
}
context.SaveChanges();
return true;
}
catch
{
return false;
}
}
}
catch
{
return false;
}
}
