private void AssertCandidate(CandidateModel model, EmployerMemberView view) { Assert.AreEqual(view.Id, model.Id); Assert.AreEqual(view.GetCandidateTitle(), model.FullName); Assert.AreEqual(view.Status, model.Status); Assert.AreEqual(_memberStatusQuery.GetLastUpdatedTime(view, view, view.Resume).ToUniversalTime(), model.LastUpdatedTime); Assert.AreEqual(view.Address.Location.ToString(), model.Location); var salary = view.DesiredSalary == null ? null : view.DesiredSalary.ToRate(SalaryRate.Year); Assert.AreEqual(salary == null ? null : salary.LowerBound, model.DesiredSalary == null ? null : model.DesiredSalary.LowerBound); Assert.AreEqual(salary == null ? null : salary.UpperBound, model.DesiredSalary == null ? null : model.DesiredSalary.UpperBound); Assert.AreEqual(view.DesiredJobTitle, model.DesiredJobTitle); Assert.AreEqual(view.DesiredJobTypes, model.DesiredJobTypes); Assert.AreEqual(view.Resume == null ? null : view.Resume.Summary, model.Summary); if (view.Resume == null || view.Resume.Jobs == null || view.Resume.Jobs.Count == 0) { Assert.IsNull(model.Jobs); } else { for (var index = 0; index < view.Resume.Jobs.Count; ++index) { AssertJob(view.Resume.Jobs[index], model.Jobs[index]); } } }
public static bool IsNotAlreadyLogged(StateResultsModel stateResults, CandidateModel bernieResult, CandidateModel clintonResult) { using ( SqlConnection sqlCon = new SqlConnection( System.Configuration.ConfigurationManager.ConnectionStrings["local"].ConnectionString)) { sqlCon.Open(); SqlCommand duplicateCheck = new SqlCommand { CommandText = "SELECT [BernieVotes], [ClintonVotes],[UpdatedAt] FROM dbo.[CaStateResults] WHERE BernieVotes = @BernieVotes AND ClintonVotes = @ClintonVotes AND UpdatedAt = @UpdatedAt", Connection = sqlCon }; duplicateCheck.Parameters.AddWithValue("@BernieVotes", bernieResult.Votes); duplicateCheck.Parameters.AddWithValue("@ClintonVotes", clintonResult.Votes); duplicateCheck.Parameters.AddWithValue("@UpdatedAt", stateResults.UpdatedAt); SqlDataReader reader = duplicateCheck.ExecuteReader(); return(reader.HasRows); } }
public async Task <ActionResult <CandidateModel> > PostCandidateModel(CandidateModel candidateModel) { _context.CandidateModels.Add(candidateModel); await _context.SaveChangesAsync(); return(CreatedAtAction("GetCandidateModel", new { id = candidateModel.ID }, candidateModel)); }
private CandidateViewModel MapToCandidateViewModel(CandidateModel domainModel) { return(new CandidateViewModel { ID = domainModel.ID, FirstName = domainModel.FirstName, LastName = domainModel.LastName, MiddleName = domainModel.MiddleName, FinCode = domainModel.FinCode, Mail = domainModel.Mail, Birthdate = domainModel.Birthdate, ExamDate = domainModel.ExamDate, ExamTime = domainModel.ExamTime, FamilyStatusId = domainModel.FamilyStatusId, GenderId = domainModel.GenderId, Profession = domainModel.Profession, ProfessionId = domainModel.ProfessionId, ExamProfessionId = domainModel.ExamProfessionId, Mobile = domainModel.Mobile, Status = domainModel.Status, Description = domainModel.Description, LocalCandidateStatus = domainModel.LocalCandidateStatus, Finish = domainModel.Finish, TicketId = domainModel.TicketID }); }
private async void btnEdit_Click(object sender, EventArgs e) { Opacity = 0.5; var editCandidate = new CandidateForm(); editCandidate.EditingCandidate = CurrentCandidate; editCandidate.Owner = this; editCandidate.ShowDialog(); var candidate = await editCandidate.GetNewDataAsync(); if (candidate != null) { IsUpdated = true; CurrentCandidate = candidate; SetCandidate(); await _window.LoadCandidatesAsync(); _candidateParty = (await _candidateService.GetCandidateDetailsListByPartyAsync(CurrentCandidate.PartyId)).ToList(); _index = _candidateParty.FindIndex(c => c.Id == candidate.Id); lblCandidatePage.Text = (_index + 1) + " of " + (_candidateParty.Count); btnNext.Enabled = _index != _candidateParty.Count - 1; btnPrev.Enabled = _index != 0; } Opacity = 1; }
public ActionResult <CandidateModel> GetCandidate(int id) { var candidateEntity = _interviewService.GetCandidate(id); if (candidateEntity == null) { return(NotFound($"No Candidate of id {id} exists")); } var retVal = new CandidateModel() { Id = id, FirstName = candidateEntity.FirstName, LastName = candidateEntity.LastName, PositionType = candidateEntity.PositionType, Created = candidateEntity.Created }; if (candidateEntity.Tests.Any()) { retVal.Tests = new List <CandidateTestModel>(); foreach (var test in candidateEntity.Tests) { retVal.Tests.Add(new CandidateTestModel(test)); } } return(retVal); }
public ActionResult AddNameSubmit(CandidateModel cm) { try { cm.BidCount = 0; cm.Hidden = 1; cm.Priority = 0; cm.BidAdjust = 0; CandidateRepository cr = new CandidateRepository(); int duplicateId = cr.CheckDuplicate(cm); if (duplicateId == -2) { return(Json(new { success = false, message = "提名失败,被提名对象已经存在。如果在投票页面上没有见到,可能处于审核状态。" })); } if (duplicateId != -1) { cm.Type = cm.Type + 10 * duplicateId; } cr.Insert(cm); cr.Save(); return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } }
// POST: api/Candidates public ResponseModel Post([FromBody] CandidateModel Candidate) { try { if (ModelState.IsValid) { ResponseModel Response = _ICandidatesRepository.CreateCandidate(Candidate); if (Response.ID > 0) { return(Response); } else { return(Helpers.ResponseFactory.Create(false)); } } else { ResponseModel ErrorResponse = Helpers.ResponseFactory.Create(false); ErrorResponse.Message = "Candidate information is incorrect. Please take a look at the details."; ErrorResponse.Object = ModelState.Values.SelectMany(v => v.Errors); return(ErrorResponse); } } catch (Exception ex) { Helpers.Utils.RegisterException("Candidates: Post", ex.Message); return(Helpers.ResponseFactory.Create(false)); } }
public bool CreateNewCandidate(int[] skills, CandidateModel candidate) { bool result = true; var NewCandidate = new Candidate() { FirstName = candidate.FirstName, LastName = candidate.LastName, }; work.Candidates.Add(NewCandidate); if (skills != null) { for (int i = 0; i < skills.Length; i++) { var skill = new Candidate_Skills() { CandidateId = NewCandidate.Id, SkillId = skills[i] }; work.CandidateSkills.Add(skill); } } work.Commit(); return(result); }
public static void LogChanges(StateResultsModel stateResults, CandidateModel bernieResult, CandidateModel clintonResult) { using ( SqlConnection sqlCon = new SqlConnection( System.Configuration.ConfigurationManager.ConnectionStrings["local"].ConnectionString)) { sqlCon.Open(); SqlCommand sqlCmd1 = new SqlCommand { CommandText = "INSERT INTO dbo.[CaStateResults] ([BernieVotes], [ClintonVotes], [UpdatedAt]) VALUES (@BernieVotes, @ClintonVotes, @UpdatedAt)", Connection = sqlCon }; sqlCmd1.Parameters.AddWithValue("@BernieVotes", bernieResult.Votes); sqlCmd1.Parameters.AddWithValue("@ClintonVotes", clintonResult.Votes); sqlCmd1.Parameters.AddWithValue("@UpdatedAt", stateResults.UpdatedAt); sqlCmd1.ExecuteNonQuery(); sqlCon.Close(); } Console.WriteLine("New votes recorded"); }
// GET: Candidate/Details/5 public ActionResult DetailsCandidate(int id) { CandidateModel cm = new CandidateModel(); candidate can = new candidate(); HttpClient client = new HttpClient(); client.BaseAddress = new Uri("http://*****:*****@"""" + s + @""""; can.dateNaissance = cm.dateNaissance; } Console.WriteLine(can); return(View(can)); }
public ActionResult CandidateDelete(string id) { CandidateModel comm = new CandidateModel(); bool statuss = comm.DeleteCandidate(id); return(RedirectToAction("Candidate", "Candidate")); }
public async Task ValidateAsync(int electionId, CandidateModel candidate) { if (string.IsNullOrWhiteSpace(candidate.FirstName)) { throw new ArgumentException("No first name provided"); } if (string.IsNullOrWhiteSpace(candidate.LastName)) { throw new ArgumentException("No last name provided"); } if (candidate.YearLevel < 1 || candidate.YearLevel > 12) { throw new ArgumentOutOfRangeException("Year level must be from 1 to 12"); } if (string.IsNullOrWhiteSpace(candidate.Section)) { throw new ArgumentException("No section provided"); } if (string.IsNullOrWhiteSpace(candidate.Alias)) { throw new ArgumentException("No alias provided"); } if (await IsAliasExistingAsync(electionId, candidate.Alias, null)) { throw new InvalidOperationException($"Alias '{ candidate.Alias }' already exists"); } }
public ActionResult Create( CandidateModel candidateModel, HttpPostedFileBase imageUrl) { var campaignIds = dao.GetAllCampaignID(); candidateModel.CampaignIds = GetSelectListItems(campaignIds); int count = 0; if (ModelState.IsValid) { var fileName = Path.GetFileName(imageUrl.FileName); var directory = Server.MapPath(Url.Content("~/Content/Images")); var path = Path.Combine(directory, fileName); imageUrl.SaveAs(path); candidateModel.ImageUrl = fileName; count = dao.InsertCandidate(candidateModel); if (count == 1) { ViewBag.Message = "Candidate added!"; return(View("Success")); } else { ViewBag.Message = $"Error {dao.message}"; return(View("Error")); } } else { return(View(candidateModel)); } }
public ActionResult EditApply(int id) { CandidateRepository cr = new CandidateRepository(); CandidateModel cm = cr.GetInfoById(id); return(View(cm)); }
public ActionResult Save(CandidateModel Candidate) { if (ModelState.IsValid) { using (MyDbContext dc = new MyDbContext()) { if (Candidate.ID > 0) { //Edit var v = dc.tblCandidate.Where(a => a.ID == Candidate.ID).FirstOrDefault(); if (v != null) { v.FirstName = Candidate.FirstName; v.SecondName = Candidate.SecondName; v.LastName = Candidate.LastName; v.Region = Candidate.Region; v.District = Candidate.District; v.Party = Candidate.Party; v.Election = Candidate.Election; } } else { //Save dc.tblCandidate.Add(Candidate); } dc.SaveChanges(); return(RedirectToAction("Index")); } } return(View()); }
public ActionResult Candidate() { CandidateModel candiModel = new CandidateModel(); candiModel.GetCountry(); candiModel.GetCandidateList(); return(View(candiModel)); }
// GET: Create public ActionResult Create() { var campaignIds = dao.GetAllCampaignID(); var model = new CandidateModel(); model.CampaignIds = GetSelectListItems(campaignIds); return(View(model)); }
/// <summary> /// Service Method To Get All The Candidates /// </summary> /// <param name="candidate"></param> /// <returns></returns> public static async Task <List <CandidateModel> > GetCandidates(CandidateModel candidate) { List <CandidateModel> Candidates = new List <CandidateModel>(); using (SqlConnection dbConn = new SqlConnection(selectConnection(candidate.Location))) { var Query = "SELECT * from Candidate"; SqlDataReader reader; try { dbConn.Open(); SqlCommand cmd = new SqlCommand(Query, dbConn); reader = await cmd.ExecuteReaderAsync(); if (reader.HasRows) { while (reader.Read()) { CandidateModel candidateItem = new CandidateModel(); candidateItem.ID = reader.GetInt32(0); candidateItem.Name = reader.GetString(1); candidateItem.PartyID = reader.GetInt32(2); candidateItem.DistrictID = reader.GetInt32(3); candidateItem.Votes = reader.GetInt32(4); Candidates.Add(candidateItem); } } } catch (Exception ex) { reader = null; ActionLogService.LogAction(new ActionLogModel() { UserID = candidate.UserID, ActionPerformed = "Candidates Error : " + ex.Message, MethodName = "GetCandidates", IsError = true }, candidate.Location); } finally { dbConn.Close(); ActionLogService.LogAction(new ActionLogModel() { UserID = candidate.UserID, ActionPerformed = "Get All Existing Candidates ", MethodName = "GetCandidates", IsError = false }, candidate.Location); } return(Candidates); } }
/// <summary> /// Service Method To Get All The Candidates (Since All The Locations Will Have The Same candidates, Can Get Them From One Location) /// </summary> /// <param name="location"></param> /// <param name="userID"></param> /// <returns></returns> public static List <CandidateModel> GetCandidates(string location, int userID) { List <CandidateModel> candidates = new List <CandidateModel>(); using (SqlConnection dbConn = new SqlConnection(selectConnection(location))) { string query = @"SELECT * FROM Candidate"; SqlDataReader reader; try { dbConn.Open(); SqlCommand cmd = new SqlCommand(query, dbConn); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { CandidateModel candidate = new CandidateModel(); candidate.ID = reader.GetInt32(0); candidate.Name = reader.GetString(1); candidate.Votes = reader.GetInt32(2); candidates.Add(candidate); } } } catch (Exception ex) { reader = null; ActionLogService.LogAction(new ActionLogModel() { UserID = userID, ActionPerformed = " Error In Consolidating Votes : " + ex.Message, MethodName = "ConsolidateVotes", IsError = true }, location); } finally { dbConn.Close(); ActionLogService.LogAction(new ActionLogModel() { UserID = userID, ActionPerformed = "Consolidate Votes", MethodName = "ConsolidateVotes", IsError = false }, location); } return(candidates); } }
public static void Put(int id, CandidateModel candidateModel) { TestOnlineEntities entities = new TestOnlineEntities(); var updatedCandidate = entities.Candidate.FirstOrDefault(c => c.Id == id); updatedCandidate.LastName = candidateModel.LastName; updatedCandidate.FirstName = candidateModel.FirstName; entities.SaveChanges(); }
public ActionResult Create(CandidateModel model) { try { var newPerson = new Person { Email = model.Email, PhoneNo = model.Phone, FirstName = !string.IsNullOrEmpty(model.FirstName) ? model.FirstName : "Unknown", LastName = !string.IsNullOrEmpty(model.LastName) ? model.LastName : "Unknown" }; _personRepository.Create(newPerson); var newCandidate = new Candidate { Source = model.Source, Status = CandidateStatus.New, PersonId = newPerson.Id, RecievedOn = DateTime.UtcNow, CreatedByUserId = model.CreatedByUserId, Comments = model.Comments }; _candidateRepository.Create(newCandidate); _unitOfWork.Commit(); // Update the Candidate Code. var selectedCandidate = _candidateRepository.Get(newCandidate.Id); if (selectedCandidate != null) { selectedCandidate.Code = $"LA{selectedCandidate.Id.ToString("D" + 6)}"; _candidateRepository.Update(selectedCandidate); _unitOfWork.Commit(); } var result = new ApiResult <bool> { Status = true, Message = "Success" }; return(Json(result)); } catch (Exception ex) { var result = new ApiResult <bool> { Status = false, Message = ex.Message }; return(Json(result)); } }
public ActionResult GetEditBase(int id) { CandidateRepository cr = new CandidateRepository(); CandidateModel cm = cr.GetInfoById(id); if (HttpContext.User.Identity.Name != "Super") { cm.BidAdjust = 0; } return(Json(cm)); }
public async Task UpdateCandidateAsync(CandidateModel model) { using (var context = new StudentElectionContext()) { var candidate = await context.Candidates.SingleOrDefaultAsync(c => c.Id == model.Id); _mapper.Map(model, candidate); await context.SaveChangesAsync(); } }
public async Task SaveCandidateAsync(CandidateModel candidate) { if (candidate.Id == 0) { await _candidateRepository.InsertCandidateAsync(candidate); } else { await _candidateRepository.UpdateCandidateAsync(candidate); } }
public async Task DeleteCandidateAsync(CandidateModel model) { using (var context = new StudentElectionContext()) { var candidate = await context.Candidates.SingleOrDefaultAsync(c => c.Id == model.Id); context.Candidates.Remove(candidate); await context.SaveChangesAsync(); } }
public ActionResult AddNewCandidate(CandidateMV candiate, int[] skills) { var createNew = new CandidateModel() { FirstName = candiate.FirstName, LastName = candiate.LastName }; var result = crsService.CreateNewCandidate(skills, createNew); return(RedirectToAction("Index")); }
public async Task DeleteCandidateAsync(CandidateModel candidate) { await Task.CompletedTask; using (var tableAdapter = new CandidateTableAdapter()) { tableAdapter.Delete( candidate.Id ); } }
public int SaveCandidate(CandidateModel model) { int candId = this.DataContext.SaveCandidate(model.Candidate); if (!string.IsNullOrWhiteSpace(model.Resume.ResumePath)) { model.Resume.CandidateID = candId; return(this.DataContext.SaveResume(model.Resume)); } return(candId); }
public async Task <HttpResponseMessage> Add() { if (!Request.Content.IsMimeMultipartContent()) { throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType); } var root = HttpContext.Current.Server.MapPath("~/Assets/Uploads"); Directory.CreateDirectory(root); var provider = new CustomMultipartFormDataStreamProvider(root); var result = await Request.Content.ReadAsMultipartAsync(provider); if (result.FormData["model"] == null) { throw new HttpResponseException(HttpStatusCode.BadRequest); } var model = result.FormData["model"]; var serializer = new JavaScriptSerializer(); CandidateModel modelToAdd = serializer.Deserialize <CandidateModel>(model); string pattern = @"^[A-Za-z ]+$"; Regex regex = new Regex(pattern); if (!regex.IsMatch(modelToAdd.name)) { HttpResponseMessage response = this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Name must only contains letters and white space"); throw new HttpResponseException(response); } if (!regex.IsMatch(modelToAdd.sur_name)) { HttpResponseMessage response = this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Surname must only contains letters and white space"); throw new HttpResponseException(response); } candidate obj = new candidate(); obj.name = modelToAdd.name; obj.sur_name = modelToAdd.sur_name; obj.position = modelToAdd.position; //get the files //TODO: Do something with each uploaded file foreach (var file in result.FileData) { obj.curriculum = Path.GetFileName(file.LocalFileName); } obj.Insert(); return(Request.CreateResponse(HttpStatusCode.OK, obj)); }