public async Task <IActionResult> PuttApplicant([FromRoute] int id, [FromBody] tApplicant tApplicant) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tApplicant.applicant_id) { return(BadRequest()); } _context.Entry(tApplicant).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tApplicantExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> GettApplicant([FromRoute] int clientID, int?batchID) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } List <tApplicant> applicant = null; if (batchID is null) { applicant = new List <tApplicant>(); tApplicant a = await _context.tApplicant.SingleOrDefaultAsync(m => m.client_id == clientID); applicant.Add(a); } else { applicant = new List <tApplicant>(); var applicantPrograms = await _context.tApplicantProgram.Where(ap => ap.batch_id == batchID).ToListAsync(); for (int i = 0; i < applicantPrograms.Count; i++) { tApplicant a = await _context.tApplicant.SingleOrDefaultAsync(m => m.client_id == clientID && m.applicant_id == applicantPrograms[i].applicant_id); applicant.Add(a); } } if (applicant == null) { return(NotFound()); } return(Ok(applicant)); }
public async Task <IActionResult> OnPostApproveAsync(int ID) { tApplicant applicant = await _context.tApplicant.SingleOrDefaultAsync(a => a.applicant_id == ID); _context.Attach(applicant).State = EntityState.Modified; applicant.status = "Approved"; await _context.SaveChangesAsync(); return(RedirectToPage("./Index")); }
public async Task <IActionResult> PosttApplicant([FromBody] tApplicant tApplicant) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.tApplicant.Add(tApplicant); await _context.SaveChangesAsync(); return(CreatedAtAction("GettApplicant", new { id = tApplicant.applicant_id }, tApplicant)); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } tApplicant = await _context.tApplicant.SingleOrDefaultAsync(m => m.applicant_id == id); if (tApplicant == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } tApplicant = await _context.tApplicant.FindAsync(id); if (tApplicant != null) { _context.tApplicant.Remove(tApplicant); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnGetAsync(int?id) { ViewData["client"] = new SelectList(_context.tClient, "client_id", "client_name"); ViewData["city"] = new SelectList(_context.tCity, "city_id", "city_name"); if (id == null) { return(NotFound()); } tApplicant = await _context.tApplicant.SingleOrDefaultAsync(m => m.applicant_id == id); if (tApplicant == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnGetAsync(int?id, int?app) { if (id == null && app == null) { return(NotFound()); } applicantProgram = await _context.tApplicantProgram.Where(m => m.applicant_program_id == id).SingleOrDefaultAsync(); ap = applicantProgram; types = await _context.tType.ToListAsync(); domains = await _context.tDomain.ToListAsync(); answers = await _context.tApplicantAnswer .Include(t => t.answer.question) .Include(t => t.answer.question.domain) .Include(t => t.answer.question.type) .Include(t => t.answer) .Include(t => t.applicant_program) .Include(t => t.applicant_program.batch) .Include(t => t.applicant_program.batch.client) .Where(ap => ap.applicant_program.applicant_program_id == id && ap.applicant_id == app).ToListAsync(); history = await _context.tAnswerHistory .Include(t => t.answer) .Include(t => t.answer.question) .Where(h => h.applicant_program.applicant_id == app && h.applicant_program.applicant_program_id == id).ToListAsync(); applicant = await _context.tApplicant.Include(t => t.client).Where(a => a.applicant_id == app).SingleOrDefaultAsync(); // ranking process int sort = 1; rangkings = new List <rangking>(); foreach (tType t in types) { List <tAppllicantAnswer> lap = answers.Where(a => a.answer.question.type_name == t.type_name).ToList(); rangking r = new rangking(); r.rankID = sort; foreach (tAppllicantAnswer ap in lap) { r.rawScore += ap.answer.score; } r.type = new tType(); r.type = t; r.zScore = (r.rawScore - t.substractor) / t.divider; r.domainCount = new List <domainCount>(); foreach (tDomain d in domains) { domainCount dc = new domainCount(); dc.count = answers.Where(a => a.answer.question.type_name == t.type_name && a.answer.question.domain.domain_id == d.domain_id && a.answer.score > 2).Count(); dc.domain = new tDomain(); dc.domain = d; r.domainCount.Add(dc); } rangkings.Add(r); sort++; } rangkings = rangkings.OrderByDescending(o => o.zScore).ToList(); if (answers == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> PosttApplicantProgram([FromBody] tApplicantProgram tApplicantProgram) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } tApplicantProgram.report_description = "<h1 style=\"text-align: center;\">LAPORAN HASIL PROFILING</h1><table style=\"border-collapse: collapse;\"><tbody><tr><td style=\"width: 50%;\">Nama</td><td style=\"width: 50%;\">: {applicant_name}</td></tr><tr><td style=\"width: 50%;\">Jenis Kelamin</td><td style=\"width: 50%;\">: {gender}</td></tr><tr><td style=\"width: 50%;\">Usia</td><td style=\"width: 50%;\">: {age}</td></tr><tr><td style=\"width: 50%;\">Jabatan</td><td style=\"width: 50%;\">: {title}</td></tr></tbody></table><p><strong>I. Hasil Assestment Awal</strong></p><table style=\"border-collapse: collapse;\"><tbody><tr><td style=\"width: 50%;\">Metode </td><td style=\"width: 50%;\">:</td></tr><tr><td style=\"width: 50%;\">Tujuan</td><td style=\"width: 50%;\">:</td></tr></tbody></table><p>{graphic}</p><p><<fill in here>></p><table style=\"height: 558px; border-color: #000000; width: 781px; border-style: solid; margin-left: auto; margin-right: auto;\" border=\"1\" width=\"781\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">No</td><td style=\"height: 18px; width: 376px;\">Perilaku</td><td style=\"height: 18px; width: 68px;\">1</td><td style=\"height: 18px; width: 68px;\">2</td><td style=\"height: 18px; width: 68px;\">3</td><td style=\"height: 18px; width: 68px;\">4</td><td style=\"height: 18px; width: 70px;\">5</td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 757px;\" colspan=\"7\">Favorable</td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 757px;\" colspan=\"7\">Sikap kerja</td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">1</td><td style=\"height: 18px; width: 376px;\">Bekerja dengan detail</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">2</td><td style=\"height: 18px; width: 376px;\">Bertanggung jawab</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">3</td><td style=\"height: 18px; width: 376px;\">Kemandirian bekerja</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">4</td><td style=\"height: 18px; width: 376px;\">Keteraturan dalam bekerja</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">5</td><td style=\"height: 18px; width: 376px;\">Kepatuhan terhadap aturan</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 36px;\"><td style=\"height: 36px; width: 27px;\">6</td><td style=\"height: 36px; width: 376px;\">Pembuatan perencanaan sebelum melaksanakan sesuatu</td><td style=\"height: 36px; width: 68px;\"> </td><td style=\"height: 36px; width: 68px;\"> </td><td style=\"height: 36px; width: 68px;\"> </td><td style=\"height: 36px; width: 68px;\"> </td><td style=\"height: 36px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">7</td><td style=\"height: 18px; width: 376px;\">Disiplin</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">8</td><td style=\"height: 18px; width: 376px;\">Loyalitas</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">9</td><td style=\"height: 18px; width: 376px;\">Motivasi kerja</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">10</td><td style=\"height: 18px; width: 376px;\">Daya saing</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 757px;\" colspan=\"7\">Kognitif</td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">11</td><td style=\"height: 18px; width: 376px;\">Inisiatif</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">12</td><td style=\"height: 18px; width: 376px;\">Kreatifitas</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">13</td><td style=\"height: 18px; width: 376px;\">Kemampuan berpikir kritis</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 757px;\" colspan=\"7\">Sikap menghadapi masalah</td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">14</td><td style=\"height: 18px; width: 376px;\">Keberanian menghadapi masalah</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">15</td><td style=\"height: 18px; width: 376px;\">Keberanian untuk mengungkapkan pendapat</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">16</td><td style=\"height: 18px; width: 376px;\">Kecepatan dalam membuat keputusan</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">17</td><td style=\"height: 18px; width: 376px;\">Kemampuan menerima kritik</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">18</td><td style=\"height: 18px; width: 376px;\">Kemampuan kontrol emosi</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 757px;\" colspan=\"7\">Kemampuan sosial</td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">19</td><td style=\"height: 18px; width: 376px;\">Kepercayaan diri</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">20</td><td style=\"height: 18px; width: 376px;\">Kemampuan untuk mempercayai orang lain</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">21</td><td style=\"height: 18px; width: 376px;\">Keterbukaan</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">22</td><td style=\"height: 18px; width: 376px;\">Kemampuan persuasif</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">23</td><td style=\"height: 18px; width: 376px;\">Kemampuan bersosialisasi</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"height: 18px; width: 27px;\">24</td><td style=\"height: 18px; width: 376px;\">Kemampuan berempati</td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 68px;\"> </td><td style=\"height: 18px; width: 70px;\"> </td></tr></tbody></table><p> </p><table style=\"border-style: solid; width: 781px; border-color: #000000; margin-left: auto; margin-right: auto; height: 118px;\" border=\"1\" width=\"693\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"height: 18px;\"><td style=\"width: 26px; height: 18px;\">No</td><td style=\"width: 384px; height: 18px;\">Perilaku</td><td style=\"width: 71px; height: 18px;\">1</td><td style=\"width: 71px; height: 18px;\">2</td><td style=\"width: 71px; height: 18px;\">3</td><td style=\"width: 71px; height: 18px;\">4</td><td style=\"width: 71px; height: 18px;\">5</td></tr><tr style=\"height: 18px;\"><td style=\"width: 777px; height: 18px;\" colspan=\"7\">Unfavorable</td></tr><tr style=\"height: 18px;\"><td style=\"width: 26px; height: 18px;\">1</td><td style=\"width: 384px; height: 18px;\">Potensi emosi meledak-ledak (borderline)</td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"width: 26px; height: 18px;\">2</td><td style=\"width: 384px; height: 18px;\">Sensitivitas emosi</td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"width: 26px; height: 18px;\">3</td><td style=\"width: 384px; height: 18px;\">Impulsivitas (bekerja tanpa pertimbangan matang)</td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td></tr><tr style=\"height: 18px;\"><td style=\"width: 26px; height: 18px;\">4</td><td style=\"width: 384px; height: 18px;\">Tingkat kecemasan</td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td><td style=\"width: 71px; height: 18px;\"> </td></tr><tr style=\"height: 10px;\"><td style=\"width: 26px; height: 10px;\">5</td><td style=\"width: 384px; height: 10px;\">Superioritas (Merasa lebih superior dari orang lain)</td><td style=\"width: 71px; height: 10px;\"> </td><td style=\"width: 71px; height: 10px;\"> </td><td style=\"width: 71px; height: 10px;\"> </td><td style=\"width: 71px; height: 10px;\"> </td><td style=\"width: 71px; height: 10px;\"><p> </p><p> </p></td></tr></tbody></table>"; _context.tApplicantProgram.Add(tApplicantProgram); await _context.SaveChangesAsync(); #region send email try { tApplicant applicant = await _context.tApplicant.Where(a => a.applicant_id == tApplicantProgram.applicant_id).SingleOrDefaultAsync(); //// send email using mailjet //SmtpClient smtp = new SmtpClient(); //NetworkCredential cre = new NetworkCredential(); //cre.UserName = "******"; //cre.Password = "******"; //smtp.Credentials = cre; //smtp.UseDefaultCredentials = false; //smtp.Host = "in-v3.mailjet.com"; //smtp.Port = 587; //smtp.DeliveryMethod = SmtpDeliveryMethod.Network; //smtp.EnableSsl = true; //MailMessage msg = new MailMessage(); //MailAddress mailAddress = new MailAddress("*****@*****.**", "Test"); //msg.From = mailAddress; //msg.Body = "test"; //msg.IsBodyHtml = true; //msg.Priority = MailPriority.High; //msg.Sender = mailAddress; //msg.Subject = "Test"; //msg.To.Add(new MailAddress("*****@*****.**", "Ahmad Zakki Bolt")); //smtp.Send(msg); //// end sending email using mailjet // send email using google SmtpClient smtp = new SmtpClient(); NetworkCredential cre = new NetworkCredential(); cre.UserName = "******"; cre.Password = "******"; smtp.Credentials = cre; smtp.UseDefaultCredentials = false; smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.EnableSsl = true; MailMessage msg = new MailMessage(); MailAddress mailAddress = new MailAddress("*****@*****.**", "Demo Account"); msg.From = mailAddress; if (applicant.gender == tApplicant.Gender.Female) { msg.Body = "Yang terhormat ibu " + applicant.full_name + ","; } else { msg.Body = "Yang terhormat"; } msg.IsBodyHtml = true; msg.Priority = MailPriority.High; msg.Sender = mailAddress; msg.Subject = "Test"; msg.To.Add(new MailAddress("*****@*****.**", "Ahmad Zakki Bolt")); smtp.Send(msg); //end sending email } catch (Exception ex) { return(BadRequest(ex)); } #endregion return(CreatedAtAction("GettApplicantProgram", new { id = tApplicantProgram.applicant_program_id }, tApplicantProgram)); }