//==================================================================================// // 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; } }
//==================================================================================// // 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; } }
//==================================================================================// // 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 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; } }
//==================================================================================// // 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; } }
//==================================================================================// // 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; } }