public ActionResult Accept(ApplicantVm avm) { applicant applicant = new applicant() { id = avm.id, applicantState = "Applicant_Being_Recruted", username = avm.username, role = avm.role, picture = avm.picture, age = avm.age, arrival = avm.arrival, chanceOfSuccess = avm.chanceOfSuccess, country = avm.country.ToString(), demand = avm.demand, lastname = avm.lastname, name = avm.name, password = avm.password }; HttpClient client = new HttpClient(); client.BaseAddress = new Uri("http://localhost:18080"); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); client.PutAsJsonAsync <applicant>("/l4c_map-v2-web/rest/applicant/", applicant).ContinueWith((postTask) => postTask.Result.EnsureSuccessStatusCode()); return(RedirectToAction("Profile", "Applicant")); }
public void Remove(applicant applicant, string serverPath) { RemoveAll(applicant.ApplicantID); if ((System.IO.File.Exists(serverPath + applicant.Resume))) { System.IO.File.Delete(serverPath + applicant.Resume); } using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); RemoveUser(applicant, connection); StringBuilder sb = new StringBuilder(); sb.Append("DELETE FROM [careerfair].[applicant]"); sb.Append("WHERE [ApplicantID] = " + applicant.ApplicantID); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = System.Data.CommandType.Text; command.ExecuteNonQuery(); } } }
public ActionResult Create(ApplicantVm avm, HttpPostedFileBase File) { if (ModelState.IsValid) { if (File != null && File.ContentLength != 0) { applicant applicant = new applicant() { lastname = avm.lastname, name = avm.name, password = avm.password, picture = File.FileName, username = avm.username, age = avm.age, country = avm.country.ToString() }; HttpClient client = new HttpClient(); client.BaseAddress = new Uri("http://localhost:18080"); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); client.PostAsJsonAsync <applicant>("/l4c_map-v2-web/rest/inscription", applicant).ContinueWith((postTask) => postTask.Result.EnsureSuccessStatusCode()); if (File.ContentLength > 0) { var path = Path.Combine(Server.MapPath("~/images/"), File.FileName); File.SaveAs(path); } return(RedirectToAction("Login", "User")); } } return(View(avm)); }
public void Insert(applicant applicant) { int id = applicant.ApplicantID; using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [careerfair].[applicant]([Email],[FirstName],[LastName],[University],[Alumni],[Profile],[SocialMedia],[Resume],[YearsExperience],[Internship],[Active])"); string values = "VALUES(@param2, @param3, @param4, @param5, @param6, @param7, @param8, @param9, @param10, @param11, @param12); SELECT @ID = SCOPE_IDENTITY()"; sb.Append(values); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.Add("@param2", SqlDbType.NVarChar, 128).Value = (object)applicant.Email ?? DBNull.Value; command.Parameters.Add("@param3", SqlDbType.NVarChar, 50).Value = (object)applicant.FirstName ?? DBNull.Value; command.Parameters.Add("@param4", SqlDbType.NVarChar, 50).Value = (object)applicant.LastName ?? DBNull.Value; command.Parameters.Add("@param5", SqlDbType.NVarChar, 50).Value = (object)applicant.University ?? DBNull.Value; command.Parameters.Add("@param6", SqlDbType.Bit).Value = (object)applicant.Alumni ?? DBNull.Value; command.Parameters.Add("@param7", SqlDbType.NVarChar, int.MaxValue).Value = (object)applicant.Profile ?? DBNull.Value; command.Parameters.Add("@param8", SqlDbType.NVarChar, int.MaxValue).Value = (object)applicant.SocialMedia ?? DBNull.Value; command.Parameters.Add("@param9", SqlDbType.NVarChar, int.MaxValue).Value = (object)applicant.Resume ?? DBNull.Value; command.Parameters.Add("@param10", SqlDbType.TinyInt).Value = (object)applicant.YearsExperience ?? DBNull.Value; command.Parameters.Add("@param11", SqlDbType.Bit).Value = (object)applicant.Internship ?? DBNull.Value; command.Parameters.Add("@param12", SqlDbType.Bit).Value = (object)applicant.Active ?? DBNull.Value; command.Parameters.Add("@ID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; command.CommandType = System.Data.CommandType.Text; command.ExecuteNonQuery(); id = (int)command.Parameters["@ID"].Value; } } Insert(applicant.Fields, id); }
protected void subApply(object sender, RepeaterCommandEventArgs e) { switch (e.CommandName) { case "ApplyNow": applicantsDataContext objApplicantDC = new applicantsDataContext(); applicant objNewApplicant = new applicant(); TextBox txtFname = (TextBox)e.Item.FindControl("txt_fnameApp"); TextBox txtLname = (TextBox)e.Item.FindControl("txt_lnameApp"); TextBox txtEmail = (TextBox)e.Item.FindControl("txt_emailApp"); TextBox txtPhone = (TextBox)e.Item.FindControl("txt_phoneApp"); TextBox txtMsg = (TextBox)e.Item.FindControl("txt_msgBox"); Label lblConfirm = (Label)e.Item.FindControl("lbl_confirmApply"); HiddenField hdfJobID = (HiddenField)e.Item.FindControl("hdf_jobID"); objNewApplicant.firstname = txtFname.Text; objNewApplicant.lastname = txtLname.Text; objNewApplicant.email = txtEmail.Text; objNewApplicant.job_id = int.Parse(hdfJobID.Value.ToString()); objApplicantDC.applicants.InsertOnSubmit(objNewApplicant); objApplicantDC.SubmitChanges(); txtFname.Text = ""; txtLname.Text = ""; txtEmail.Text = ""; txtPhone.Text = ""; txtMsg.Text = ""; lblConfirm.Text = "Your applicantion was sent successfully!"; break; case "Refresh": //_subRefresh(); //Response.Redirect("Career.aspx?tabIndex=0"); break; } }
public List <applicant> ReadForAdmin() { List <applicant> applicants = new List <applicant>(); using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("SELECT [ApplicantID],[Email],[FirstName],[LastName],[Active]"); sb.Append("FROM [careerfair].[applicant]"); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { applicant applicant = new applicant(); applicant.ApplicantID = DatabaseHelper.CheckNullInt(reader, 0); applicant.Email = DatabaseHelper.CheckNullString(reader, 1); applicant.FirstName = DatabaseHelper.CheckNullString(reader, 2); applicant.LastName = DatabaseHelper.CheckNullString(reader, 3); applicant.Active = DatabaseHelper.CheckNullBool(reader, 4); applicants.Add(applicant); } } } } return(applicants); }
public List <applicant> ReadAccountInfo() { List <applicant> applicants = new List <applicant>(); using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("SELECT [ApplicantID],[Email]"); sb.Append("FROM [careerfair].[applicant]"); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { applicant app = new applicant(); app.ApplicantID = DatabaseHelper.CheckNullInt(reader, 0); app.Email = DatabaseHelper.CheckNullString(reader, 1); applicants.Add(app); } } } } return(applicants); }
public void Insert(applicant applicant) { //applicant.ApplicantID = NextIdValue(); //_applicants.Add(applicant); _ds.Insert(applicant); }
public ApplicantViewModel ToViewModel(applicant a) { return(new ApplicantViewModel { ApplicantID = a.ApplicantID, Email = a.Email, FirstName = a.FirstName, LastName = a.LastName, University = a.University, Alumni = a.Alumni, Profile = a.Profile, SocialMedia = a.SocialMedia, Resume = a.Resume, YearsExperience = a.YearsExperience, Internship = a.Internship, Active = a.Active, Fields = a.Fields }); }
private void BtnAdd_Click(object sender, RoutedEventArgs e) { if (TbFamilia.Text == "" || TbName.Text == "" || TbClientMiddlename.Text == "" || TbClientPass.Text == "") { MessageBox.Show("Заполните все обязательные поля", "Ошибка", MessageBoxButton.OK); } else { currentUser = new applicant { fist_name = TbFamilia.Text, name = TbName.Text, middle_name = TbClientMiddlename.Text, date_of_bth = DPDateBirth.SelectedDate.Value, gender = CbGender.SelectedItem.ToString(), edication = TbClientEducation.Text, post = TbClientPost.Text, roles = TbClientRole.Text, login = TbClientLogin.Text, password = TbClientPass.Text }; AppData.Context.applicant.Add(currentUser); MessageBox.Show("Пользователь успешно добавлен", "Сообщение", MessageBoxButton.OK); } AppData.Context.SaveChanges(); NavigationService.GoBack(); }
public async Task <IActionResult> Edit(int id, [Bind("ID,FirstName,LastName,City,State,Phone,Email,WebAddress,skillsId,educationID,referenceID")] applicant applicant) { if (id != applicant.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(applicant); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!applicantExists(applicant.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(applicant)); }
public ActionResult GetSearchUserType(int id, bool isApplicant) { ApplicantRepository ar = null; BusinessRepository br = null; applicant applicant = null; business business = null; if (isApplicant) { ar = new ApplicantRepository(); br = new BusinessRepository(); applicant = ar.SelectOne(id); } else { br = new BusinessRepository(); business = br.SelectOne(id); } if (applicant != null && User.IsInRole("Business") && (br.CheckApproved(User.Identity.GetUserName()) || User.IsInRole("Admin"))) { return(ApplicantViewProfile(ar.ToViewModel(applicant), null)); } else if (business != null && User.IsInRole("Applicant")) { return(BusinessSearchViewProfile(br.ToViewModel(business))); } else { return(View("Error")); } }
public IHttpActionResult Post(RegisterViewModel registrationForm) { if (ModelState.IsValid) { //Create entry in DB applicant applicant = new applicant { Name = registrationForm.Name, LastName = registrationForm.LastName, Address = registrationForm.Address, DateOfBirth = registrationForm.DateOfBirth, DateOfCreation = DateTime.Now }; db.applicant.Add(applicant); db.SaveChanges(); //Set up return model ApplicantRegistered registered = new ApplicantRegistered { FullName = registrationForm.Name + " " + registrationForm.LastName, isDOBFriday = ((int)registrationForm.DateOfBirth.DayOfWeek == 5) ? true : false //true if DOB is friday }; //Return status created + response data (Normally also returns the path to created object (CreatedAtRoute).) return(Created("", registered)); } else { return(BadRequest(ModelState)); } }
private string ApplicantToCSV(applicant a) { string formatted = string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10}", a.ApplicantID.ToString(), a.Email.Replace(",", string.Empty), a.FirstName.Replace(",", string.Empty), a.LastName.Replace(",", string.Empty), a.University.Replace(",", string.Empty), a.Alumni.ToString(), a.Profile.Replace(",", string.Empty), a.SocialMedia.Replace(",", string.Empty), a.YearsExperience.ToString(), a.Internship.ToString(), a.Active.ToString()); return(formatted); }
public ApplicantViewModel SelectOneAsViewModel(int id) { applicant app = _ds.Read(id); ApplicantViewModel selectedApplicant = ToViewModel(app); GetAccountInfoByUserID(selectedApplicant); return(selectedApplicant); }
private void Button_Click_2(object sender, RoutedEventArgs e) { //if (CurrentUser.type!=0) { try { AddNew = new applicant(); //fill applicant AddNew.idapplicant = int.Parse(this.AID.Text); if (this.AFIO.Text.Length > 20) { AddNew.FIO = this.AFIO.Text.Substring(0, 19); } else { AddNew.FIO = this.AFIO.Text; } AddNew.position = this.APOSITION.Text; AddNew.salary = int.Parse(this.ASALARY.Text); AddNew.hired = false; if (this.AINFO.Text.Length > 100) { AddNew.Info = this.AINFO.Text.Substring(0, 99); } else { AddNew.Info = this.AINFO.Text; } //fill R NewR.Idapplicant = AddNew.idapplicant; NewR2.Idapplicant = AddNew.idapplicant; rr2.InsertOnSubmit(NewR2); rr.InsertOnSubmit(NewR); ap.InsertOnSubmit(AddNew); try { db.SubmitChanges(); MessageBox.Show("Резюме успешно добавлено!"); this.Close(); } catch (Exception exx) { MessageBox.Show(exx.Message); db.SubmitChanges(); this.ASALARY.Text = "0"; } } catch (Exception ex) { MessageBox.Show(ex.Message); } } //else MessageBox.Show("Гости не могут добавлять резюме. Пожалуйста, залогиньтесь."); }
public void UpdateApplicantProfile(applicant applicant, string serverPath) { var oldApplicant = _ds.Read(applicant.ApplicantID); if (oldApplicant != null) { //_applicants.Remove(oldApplicant); //_applicants.Add(applicant); _ds.UpdateApplicantProfile(applicant, serverPath, oldApplicant.Resume); } }
public async Task <IActionResult> Create([Bind("ID,FirstName,LastName,City,State,Phone,Email,WebAddress,skillsId,educationID,referenceID")] applicant applicant) { if (ModelState.IsValid) { _context.Add(applicant); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(applicant)); }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { try { DataClasses1DataContext db = new DataClasses1DataContext(); if (e.CommandName.Equals("acceptreq") == true) { int maxValue; int id = Convert.ToInt32(e.CommandArgument.ToString()); acceptance n = new acceptance(); if (db.acceptances.Count() > 0) { maxValue = db.acceptances.Max(x => x.id); } else { maxValue = 0; } n.user_id = id; n.work_id = mywork.id; n.id = maxValue + 1; n.dead_time = DateTime.Now; n.detail = ":D"; n.cost = 100; var hj = from i in db.acceptances where i.user_id == n.user_id && i.work_id == n.work_id select i; if (hj.Count() > 0) { Exception c = new Exception("this user alredy accepted"); throw c; } db.acceptances.InsertOnSubmit(n); db.SubmitChanges(); } else if (e.CommandName.Equals("Delete") == true) { int id = Convert.ToInt32(e.CommandArgument.ToString()); var requestdelete = from i in db.applicants where i.user_id == id select i; applicant ap = requestdelete.First(); db.applicants.DeleteOnSubmit(ap); db.SubmitChanges(); } } catch (Exception ex) { HtmlGenericControl er = (HtmlGenericControl)this.Master.FindControl("error"); HtmlGenericControl al = (HtmlGenericControl)this.Master.FindControl("alert"); al.Visible = true; er.Visible = true; er.InnerText = ex.Message; } }
private void RemoveUser(applicant applicant, SqlConnection connection) { StringBuilder sb = new StringBuilder(); sb.Append("DELETE FROM [dbo].[AspNetUsers]"); sb.Append("WHERE [Email] = '" + applicant.Email + "'"); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = System.Data.CommandType.Text; command.ExecuteNonQuery(); } }
// this defines what will happen when admin chooses to insert a new applicant public bool commitInsert(int _jobID, string _fname, string _lname, string _email) { applicantsDataContext objApplicantDC = new applicantsDataContext(); using (objApplicantDC) { applicant objNewApplicant = new applicant(); objNewApplicant.firstname = _fname; objNewApplicant.lastname = _lname; objNewApplicant.email = _email; objNewApplicant.Id = _jobID; objApplicantDC.applicants.InsertOnSubmit(objNewApplicant); objApplicantDC.SubmitChanges(); return true; } }
// // GET: /Manage/Index public async Task <ActionResult> Index(ManageMessageId?message) { string applicantUserName = User.Identity.GetUserName(); string businessUserName = User.Identity.GetUserName(); ApplicantRepository ar = new ApplicantRepository(); applicant applicant = ar.SelectAll().Where(a => a.Email == applicantUserName).FirstOrDefault(); if (applicant != null) { ViewBag.ApplicantId = applicant.ApplicantID; } BusinessRepository br = new BusinessRepository(); business business = br.SelectAll().Where(a => a.Email == applicantUserName).FirstOrDefault(); if (business != null) { ViewBag.BusinessId = business.BusinessID; } ViewBag.StatusMessage = message == ManageMessageId.ChangePasswordSuccess ? "Your password has been changed." : message == ManageMessageId.SetPasswordSuccess ? "Your password has been set." : message == ManageMessageId.SetTwoFactorSuccess ? "Your two-factor authentication provider has been set." : message == ManageMessageId.Error ? "An error has occurred." : message == ManageMessageId.AddPhoneSuccess ? "Your phone number was added." : message == ManageMessageId.RemovePhoneSuccess ? "Your phone number was removed." : ""; var userId = User.Identity.GetUserId(); var model = new IndexViewModel { HasPassword = HasPassword(), PhoneNumber = await UserManager.GetPhoneNumberAsync(userId), TwoFactor = await UserManager.GetTwoFactorEnabledAsync(userId), Logins = await UserManager.GetLoginsAsync(userId), BrowserRemembered = await AuthenticationManager.TwoFactorBrowserRememberedAsync(userId) }; return(View(model)); }
private void InitApplicant(List <applicant> applicants, SqlConnection connection, int startRow, int numberOfRows) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT [ApplicantID],[Email],[FirstName],[LastName],[University],[Alumni],[Profile],[SocialMedia],[Resume],[YearsExperience],[Internship],[Active]"); sb.Append("FROM [careerfair].[applicant]"); if (startRow >= 0) { sb.Append("ORDER BY [ApplicantID] ASC OFFSET " + startRow + " ROWS FETCH NEXT " + numberOfRows + " ROWS ONLY;"); } String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { applicant app = new applicant(); app.ApplicantID = DatabaseHelper.CheckNullInt(reader, 0); app.Email = DatabaseHelper.CheckNullString(reader, 1); app.FirstName = DatabaseHelper.CheckNullString(reader, 2); app.LastName = DatabaseHelper.CheckNullString(reader, 3); app.University = DatabaseHelper.CheckNullString(reader, 4); app.Alumni = DatabaseHelper.CheckNullBool(reader, 5); app.Profile = DatabaseHelper.CheckNullString(reader, 6); app.SocialMedia = DatabaseHelper.CheckNullString(reader, 7); app.Resume = DatabaseHelper.CheckNullString(reader, 8); app.YearsExperience = DatabaseHelper.CheckNullByte(reader, 9); app.Internship = DatabaseHelper.CheckNullBool(reader, 10); app.Active = DatabaseHelper.CheckNullBool(reader, 11); applicants.Add(app); } } } foreach (applicant a in applicants) { AddFields(a, connection); } }
public applicant Read(string email) { applicant applicant = null; using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("SELECT [ApplicantID],[Email],[FirstName],[LastName],[University],[Alumni],[Profile],[SocialMedia],[Resume],[YearsExperience],[Internship],[Active]"); sb.Append("FROM [careerfair].[applicant]"); sb.Append("WHERE [Email] = '" + email + "'"); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { applicant = new applicant(); applicant.ApplicantID = DatabaseHelper.CheckNullInt(reader, 0); applicant.Email = DatabaseHelper.CheckNullString(reader, 1); applicant.FirstName = DatabaseHelper.CheckNullString(reader, 2); applicant.LastName = DatabaseHelper.CheckNullString(reader, 3); applicant.University = DatabaseHelper.CheckNullString(reader, 4); applicant.Alumni = DatabaseHelper.CheckNullBool(reader, 5); applicant.Profile = DatabaseHelper.CheckNullString(reader, 6); applicant.SocialMedia = DatabaseHelper.CheckNullString(reader, 7); applicant.Resume = DatabaseHelper.CheckNullString(reader, 8); applicant.YearsExperience = DatabaseHelper.CheckNullByte(reader, 9); applicant.Internship = DatabaseHelper.CheckNullBool(reader, 10); applicant.Active = DatabaseHelper.CheckNullBool(reader, 11); } } } AddFields(applicant, connection); } return(applicant); }
public void Update(applicant applicant, string serverPath, string oldResume) { RemoveAll(applicant.ApplicantID); Insert(applicant.Fields, applicant.ApplicantID); if (oldResume != applicant.Resume) { if ((System.IO.File.Exists(serverPath + oldResume))) { System.IO.File.Delete(serverPath + oldResume); } } using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("UPDATE [careerfair].[applicant]"); sb.Append("SET [Email] = @param2,[FirstName] = @param3,[LastName] = @param4,[University] = @param5,[Alumni] = @param6,[Profile] = @param7,[SocialMedia] = @param8,[Resume] = @param9,[YearsExperience] = @param10,[Internship] = @param11,[Active] = @param12"); sb.Append(" WHERE [ApplicantID] = " + applicant.ApplicantID); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.Add("@param2", SqlDbType.NVarChar, 128).Value = (object)applicant.Email ?? DBNull.Value; command.Parameters.Add("@param3", SqlDbType.NVarChar, 50).Value = (object)applicant.FirstName ?? DBNull.Value; command.Parameters.Add("@param4", SqlDbType.NVarChar, 50).Value = (object)applicant.LastName ?? DBNull.Value; command.Parameters.Add("@param5", SqlDbType.NVarChar, 50).Value = (object)applicant.University ?? DBNull.Value; command.Parameters.Add("@param6", SqlDbType.Bit).Value = (object)applicant.Alumni ?? DBNull.Value; command.Parameters.Add("@param7", SqlDbType.NVarChar, int.MaxValue).Value = (object)applicant.Profile ?? DBNull.Value; command.Parameters.Add("@param8", SqlDbType.NVarChar, int.MaxValue).Value = (object)applicant.SocialMedia ?? DBNull.Value; command.Parameters.Add("@param9", SqlDbType.NVarChar, int.MaxValue).Value = (object)applicant.Resume ?? DBNull.Value; command.Parameters.Add("@param10", SqlDbType.TinyInt).Value = (object)applicant.YearsExperience ?? DBNull.Value; command.Parameters.Add("@param11", SqlDbType.Bit).Value = (object)applicant.Internship ?? DBNull.Value; command.Parameters.Add("@param12", SqlDbType.Bit).Value = (object)applicant.Active ?? DBNull.Value; command.CommandType = System.Data.CommandType.Text; command.ExecuteNonQuery(); } } }
private void AddFields(applicant app, SqlConnection connection) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT [Name]"); sb.Append("FROM [careerfair].[field]"); sb.Append("JOIN [careerfair].[applicant2field] ON [applicant2field].[Field] = [field].[FieldID]"); sb.Append("JOIN [careerfair].[applicant] ON [applicant].[ApplicantID] = [applicant2field].[Applicant]"); sb.Append("WHERE [careerfair].[applicant2field].[Applicant] = " + app.ApplicantID); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { app.Fields.Add(DatabaseHelper.CheckNullString(reader, 0)); } } } }
public ActionResult GetUserType(ManageMessageId?message) { string userName = User.Identity.GetUserName(); if (User.IsInRole("Applicant")) { ApplicantRepository ar = new ApplicantRepository(); applicant applicant = ar.SelectOne(userName); if (applicant != null) { return(ApplicantViewProfile(ar.ToViewModel(applicant), message)); } else { return(View("Error")); } } else if (User.IsInRole("Business")) { BusinessRepository br = new BusinessRepository(); business business = br.SelectOne(userName); if (business != null) { return(BusinessViewProfile(br.ToViewModel(business), message)); } else { return(View("Error")); } } else { return(View("Error")); } }
partial void Deleteapplicant(applicant instance);
public new ActionResult Profile(ApplicantVm applicantvm) { var user = (user)Session["user"]; if (user != null && user.role.Equals("Responsable")) { user.id = applicantvm.id; } if (user != null) { HttpClient Client = new HttpClient(); Client.BaseAddress = new Uri("http://localhost:18080"); Client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = Client.GetAsync("/l4c_map-v2-web/rest/applicant/" + user.id).Result; if (response.IsSuccessStatusCode) { applicant applicant = response.Content.ReadAsAsync <applicant>().Result; ApplicantVm avm = new ApplicantVm() { id = applicant.id, age = applicant.age, applicantState = applicant.applicantState, chanceOfSuccess = applicant.chanceOfSuccess, country = (PaysVm)Enum.Parse(typeof(PaysVm), applicant.country), lastname = applicant.lastname, name = applicant.name, role = applicant.role, username = applicant.username, picture = applicant.picture, demand = applicant.demand, arrival = applicant.arrival }; ArrivalVm arrivalvm = new ArrivalVm() { arrivalDate = avm.arrival.arrivalDate, idArrival = avm.arrival.idArrival, flightNumber = avm.arrival.flightNumber }; avm.arrivalvm = arrivalvm; Client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response_test = Client.GetAsync("/l4c_map-v2-web/rest/test/").Result; if (response_test.IsSuccessStatusCode) { ICollection <test> alltest = (ICollection <test>)response_test.Content.ReadAsAsync <IEnumerable <test> >().Result; foreach (test test in alltest) { TestVm tvm = new TestVm() { dateOfPassing = test.dateOfPassing, difficulty = test.difficulty, //files = test.files, //idResponsable = test.idResponsable, idTest = test.idTest, mark = test.mark, name = test.name, specialty = test.specialty, }; Client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response_question = Client.GetAsync("/l4c_map-v2-web/rest/question/" + test.idTest).Result; ICollection <QuestionVm> allquestion = (ICollection <QuestionVm>)response_question.Content.ReadAsAsync <IEnumerable <QuestionVm> >().Result; foreach (QuestionVm question in allquestion) { tvm.questions.Add(new QuestionVm() { correct = question.correct, idQuestion = question.idQuestion, syn1 = question.syn1, syn2 = question.syn2, syn3 = question.syn3, task = question.task, test = question.test }); } avm.tests.Add(tvm); } Client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response_testpassed = Client.GetAsync("/l4c_map-v2-web/rest/test/" + user.id).Result; if (response_testpassed.IsSuccessStatusCode) { ICollection <test> testpassed = (ICollection <test>)response_testpassed.Content.ReadAsAsync <IEnumerable <test> >().Result; foreach (test test in testpassed) { avm.testpassed.Add(new TestVm() { dateOfPassing = test.dateOfPassing, difficulty = test.difficulty, idTest = test.idTest, mark = test.mark, name = test.name, specialty = test.specialty }); } } } foreach (var passed in avm.testpassed) { avm.tests.Remove(passed); } return(View(avm)); } } return(RedirectToAction("Error", "Shared")); }
public static void Initialize(ResumeContext context) { context.Database.EnsureCreated(); // Look for any applicants if (!context.applicant.Any()) { var applicants = new applicant[] { new applicant { FirstName = "Carson", LastName = "Alexander", City = "ABQ", State = "NM", Phone = "505-933-9799", Email = "*****@*****.**", WebAddress = "kellycockrell.net" } // new applicant {FirstName="Johnson",LastName="Joan",City="ABQ", State="NM", Phone="505-933-9799", Email="*****@*****.**", WebAddress="kellycockrell.net"}, // new applicant {FirstName="Raphael",LastName="Lobato",City="ABQ", State="NM", Phone="505-933-9799", Email="*****@*****.**", WebAddress="kellycockrell.net"}, // new applicant {FirstName="Elsa",LastName="Castillo",City="ABQ", State="NM", Phone="505-933-9799", Email="*****@*****.**", WebAddress="kellycockrell.net"}, // new applicant {FirstName="Cassiano",LastName="de Oliveira",City="ABQ", State="NM", Phone="505-933-9799", Email="*****@*****.**", WebAddress="kellycockrell.net"}, // new applicant {FirstName="Brendaleigh",LastName="Lobato",City="ABQ", State="NM", Phone="505-933-9799", Email="*****@*****.**", WebAddress="kellycockrell.net"}, }; foreach (applicant a in applicants) { context.applicant.Add(a); } context.SaveChanges(); } if (!context.education.Any()) { var education = new education[] { new education { degreeType = "Bachelors", subject = "Fine Arts", institution = "University of New Mexico", city = "Albuquerque", state = "NM", gradDate = "May 1994", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new education { degreeType = "Bachelors", subject = "Electrical Engineering", institution = "University of Texas", city = "Austin", state = "NM", gradDate = "May 1994", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new education { degreeType = "Masters", subject = "Physics", institution = "Boston College", city = "Boston", state = "MA", gradDate = "May 2016", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, //new education {degreeType = "PhD", subject = "Sociology", institution = "Harvard University", city = "Cambridge", state = "MA", gradDate = "December 2010",applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, //new education {degreeType = "PhD", subject = "Nuclear Engineering", institution = "Imperial College", city = "London", state = "UK", gradDate = "May 1989",applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, //new education {degreeType = "Associates", subject = "Business Administration", institution = "Santa Fe Community College", city = "Santa Fe", state = "NM", gradDate = "May 2018",applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, //new education {degreeType = "Bachelors", subject = "Biology", institution = "University of Colorado", city = "Boulder", state = "CO", gradDate = "December 1994",applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID } }; foreach (education e in education) { context.education.Add(e); } context.SaveChanges(); } if (!context.references.Any()) { var references = new references[] { new references { firstName = "Barack", lastName = "Obama", companyName = "Former President of the United States", mailingAddress = "P.O. Box 91000", city = "Washington DC", state = "", emailAddress = "*****@*****.**", phone = "212-444-5555", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new references { firstName = "Vladimir", lastName = "Putin", companyName = "President and DIctator of Russia", mailingAddress = "P.O. Box 666661", city = "Moscow", state = "Russia", emailAddress = "*****@*****.**", phone = "33-433-4424-09090", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new references { firstName = "Barack", lastName = "Obama", companyName = "Former President of the United States", mailingAddress = "P.O. Box 91000", city = "Washington DC", state = "", emailAddress = "*****@*****.**", phone = "212-444-5555", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, //new references {firstName= "Barack", lastName = "Obama", companyName = "Former President of the United States", mailingAddress = "P.O. Box 91000", city="Washington DC", state="", emailAddress= "*****@*****.**", phone = "212-444-5555" }, //new references {firstName= "Barack", lastName = "Obama", companyName = "Former President of the United States", mailingAddress = "P.O. Box 91000", city="Washington DC", state="", emailAddress= "*****@*****.**", phone = "212-444-5555" }, //new references {firstName= "Barack", lastName = "Obama", companyName = "Former President of the United States", mailingAddress = "P.O. Box 91000", city="Washington DC", state="", emailAddress= "*****@*****.**", phone = "212-444-5555" } }; foreach (references r in references) { context.references.Add(r); } context.SaveChanges(); } if (!context.skills.Any()) { var skills = new skills[] { new skills { skillName = "Javascript", experienceLevel = "Advanced", yearsUsed = "3", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new skills { skillName = "Adobe Photoshop", experienceLevel = "Expert", yearsUsed = "10", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new skills { skillName = "Adobe Illustrator", experienceLevel = "Advanced", yearsUsed = "8", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new skills { skillName = "C#", experienceLevel = "Novice", yearsUsed = "1", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new skills { skillName = "HTML/CSS", experienceLevel = "Expert", yearsUsed = "10", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new skills { skillName = "Microsoft Office", experienceLevel = "Advanced", yearsUsed = "20", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID } }; foreach (skills s in skills) { context.skills.Add(s); } context.SaveChanges(); } if (!context.experience.Any()) { var experience = new Experience[] { new Experience { jobName = "Internship Coordinator and Graphic Designer", placeWorked = "University of New Mexico", city = "Albuquerque", state = "NM", startDate = "June 2015", endDate = "present", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new Experience { jobName = "Teacher of Computer Science and Technology", placeWorked = "The Meadows School", city = "Las Vegas", state = "NV", startDate = "August 2013", endDate = "June 2015", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new Experience { jobName = "Director of Technology", placeWorked = "Steamboat Mountain School", city = "Steamboat Springs", state = "CO", startDate = "June 2012", endDate = "July 2013", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new Experience { jobName = "Technology Lab Coordinator", placeWorked = "Rowland Hall-St. Mark's School", city = "Salt Lake City", state = "UT", startDate = "August 2007", endDate = "June 2012", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new Experience { jobName = "Web and UX Designer", placeWorked = "University of Arkansas", city = "Fayetteville", state = "AR", startDate = "November 2006", endDate = "August 2007", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID }, new Experience { jobName = "Marketing Advertising Executive", placeWorked = "Lovely County Citizen", city = "Eureka Springs", state = "AR", startDate = "Jan 2005", endDate = "October 2006", applicantID = context.applicant.FirstOrDefault(y => y.FirstName == "Carson").ID } }; foreach (Experience e in experience) { context.experience.Add(e); } context.SaveChanges(); } if (!context.duties.Any()) { var duty = new duties[] { new duties { summary = "• Coordinates mentoring and internship program under a grant from the National Science Foundation.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "University of New Mexico").ID }, new duties { summary = "• Organizes and expedites mentoring events and meetings with faculty and students.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "University of New Mexico").ID }, new duties { summary = "• Advises and mentors students in meaningful development of careers. ", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "University of New Mexico").ID }, new duties { summary = "• Conceptualizes and designs advertising campaigns for School of Engineering.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "The Meadows School").ID }, new duties { summary = "• Photographs students, faculty, and departmental events, to be used for publication", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "The Meadows School").ID }, new duties { summary = "• Conceptualized, designed, and taught computer science and technology curriculum to students in a project-based environment at rigorous private middle school.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "The Meadows School").ID }, new duties { summary = "• Oversaw entire technology department for an independent boarding school,grades 9-12.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "Steamboat Mountain School").ID }, new duties { summary = "• Configured and administered firewall, wireless network, and Active Directory Server.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "Steamboat Mountain School").ID }, new duties { summary = "• Oversaw budget, recommended to and consulted with Head of School or purchases.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "Steamboat Mountain School").ID }, new duties { summary = "• Taught graphic design; advised and supervised students in the creation of theschool yearbook.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "Rowland Hall-St. Mark's School").ID }, new duties { summary = "• Managed the scheduling, maintenance, and security of computer labs.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "Rowland Hall-St. Mark's School").ID }, new duties { summary = "• Recommended hardware, software and learning resources to teachers.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "Rowland Hall-St. Mark's School").ID }, new duties { summary = "• First responder for end - user and technical support to faculty and students.", experienceID = context.experience.FirstOrDefault(y => y.placeWorked == "Rowland Hall-St. Mark's School").ID } }; foreach (duties d in duty) { context.duties.Add(d); } context.SaveChanges(); } }
public applicant SelectOne(int id) { applicant selectedApplicant = _ds.Read(id); return(selectedApplicant); }
public applicant SelectOne(string email) { applicant selectedApplicant = _ds.Read(email); return(selectedApplicant); }
partial void Updateapplicant(applicant instance);
static void Main(string[] args) { applicant applicant1 = new applicant() { name = "amr rizk", Email = "*****@*****.**", Phonenumber = "00201114566722" }; List <skill> myskills = new List <skill> { new skill() { SkillName = "ASP.NET", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.Programming }, new skill() { SkillName = "ASP.NET MVC", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.Programming }, new skill() { SkillName = "C #", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.Programming }, new skill() { SkillName = "Minimum 3 years experience", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Talking and writing Danish", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Relevant Education from KU, ITU or similar", SkillLevel = SkillLevel.Average, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Takes Responsibility for Own Projects from Ide to Implementation", SkillLevel = SkillLevel.Average, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Entity Framework", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.Programming }, new skill() { SkillName = "SQL", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.Programming }, new skill() { SkillName = "HTML / CSS", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.Programming }, new skill() { SkillName = "jQuery", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.Programming }, new skill() { SkillName = "Backend", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.Programming }, new skill() { SkillName = "Frontend", SkillLevel = SkillLevel.Pro, SkillCategory = skillcategory.Programming }, new skill() { SkillName = "Trives in a young and dynamic environment", SkillLevel = SkillLevel.Average, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Curious and Learning", SkillLevel = SkillLevel.Average, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Enjoy working closely with other developers and claimants", SkillLevel = SkillLevel.Average, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Want to work in a small .NET team with senior and junior developers", SkillLevel = SkillLevel.Average, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Has humor and lots of good mood", SkillLevel = SkillLevel.Average, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Preferring delicious food from a canteen to boring food packages", SkillLevel = SkillLevel.Average, SkillCategory = skillcategory.meta }, new skill() { SkillName = "Looking forward to nice social events with colleagues", SkillLevel = SkillLevel.Average, SkillCategory = skillcategory.meta } }; string addmotivation = "freelancer web developer with experience, project samples on github:github.com/amrahmedrizk"; JobApplication jobapp = new JobApplication(applicant1, addmotivation, myskills); Console.WriteLine(jobapp.ApplicationAnalysis()); }
partial void Insertapplicant(applicant instance);