public List <Interviews> getInterviews(int candidateId)
{
_param = new SqlParameter[] { new SqlParameter("@candidateId", candidateId) };
_dt = _sf.returnDTWithProc_executeReader("p_tblInterviews_get", _param);
List <Interviews> listInterviews = new List <Interviews>();
if (_dt.Rows.Count > 0)
{
foreach (DataRow row in _dt.Rows)
{
Interviews i = new Interviews();
i.interviewId = Convert.ToInt32(row["interviewId"]);
i.imId = Convert.ToInt32(row["imId"]);
i.candidateId = Convert.ToInt32(row["candidateId"]);
i.clientId = Convert.ToInt32(row["clientId"]);
i.joiId = Convert.ToInt32(row["joiId"]);
i.c_amId = Convert.ToInt32(row["c_amId"]);
i.toDate = Convert.ToDateTime(row["toDate"]);
i.toTime = Convert.ToString(row["toTime"]);
i.interviewStatus = Convert.ToString(row["interviewStatus"]);
i.location = Convert.ToString(row["location"]);
i.scheduleComments = Convert.ToString(row["scheduleComments"]);
i.others_Photo_Doc = Convert.ToString(row["others_Photo_Doc"]);
i.positionTitle = Convert.ToString(row["positionTitle"]);
i.clientName = Convert.ToString(row["clientName"]);
i.candidateName = Convert.ToString(row["firstName"]);
i.accountManager = Convert.ToString(row["accountManager"]);
i.interviewName = Convert.ToString(row["interviewName"]);
listInterviews.Add(i);
}
}
return(listInterviews);
}
public async Task <ActionResult> Create(Interviews model)
{
try
{
//var c = Request["CandidateId"];
var stime = Request["Stime"];
var sdate = Request["Sdate"];
DateTime time = Convert.ToDateTime(DateTime.ParseExact(sdate, "MM/dd/yyyy", null) + DateTime.Parse(stime).TimeOfDay);
ModelState.Remove("Id");
ModelState.Remove("ScheduleTime");
if (ModelState.IsValid)
{
model.ScheduleTime = time;
if (model.Id == Guid.Empty)
{
await APIHelpers.PostAsync <Interviews>("api/Interview/Post", model);
TempData["sucess"] = InterviewResources.create;
}
else
{
await APIHelpers.PutAsync <Interviews>("api/Interview/Put", model);
TempData["sucess"] = InterviewResources.update;
}
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View());
}
}
public async Task <IActionResult> DeleteInterview(int id)
{
Interviews interview = await _repo.Get(id);
_repo.RemoveInterviews(interview);
await _unitofwork.CompleteAsync();
return(Ok(id));
}
public Interviews Put(Interviews model)
{
try
{
return(_repository.Update(model));
}
catch (Exception ex)
{
throw;
}
}
public Interviews Post(Interviews model)
{
try
{
model.Id = Guid.NewGuid();
var data = _repository.Insert(model);
return(data);
}
catch (Exception ex)
{
throw;
}
}
public JsonResult saveInterviews(Interviews i)
{
string msg = null;
int interviewId = 0;
try
{
i.crtUserId = MySession.userId;
interviewId = _interviewSer.saveInterviews(i);
msg = interviewId > 0 ? "s" : "f";
}
catch (Exception ex)
{
msg = "Error:" + ex.Message;
}
return(Json(new { interviewId = interviewId, msg = msg }, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> UpdateInterview(int id, [FromBody] InterviewsResource interviewResource)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Interviews interview = await _repo.Get(id);
if (interview == null)
{
return(NotFound());
}
_mapper.Map <InterviewsResource, Interviews>(interviewResource, interview);
await _unitofwork.CompleteAsync();
return(StatusCode(202));
}
internal bool IsAuthorized(IPrincipal user)
{
try
{
List <string> authorizedUsers = new List <string>();
authorizedUsers.Add(Recruiter);
authorizedUsers.Add(Manager);
Interviews.ToList().ForEach(x => authorizedUsers.Add(x.Organizer));
Interviews.ToList().ForEach(x => authorizedUsers.Add(x.Interviewer));
return(authorizedUsers.Contains(user.Identity.Name));
}
catch (Exception)
{
return(false);
}
}
public int saveInterviews(Interviews i)
{
_param = new SqlParameter[] { new SqlParameter("@interviewId", i.interviewId), new SqlParameter("@imId", i.imId), new SqlParameter("@candidateId", i.candidateId), new SqlParameter("@clientId", i.clientId), new SqlParameter("@joiId", i.joiId), new SqlParameter("@c_amId", i.c_amId), new SqlParameter("@toDate", i.toDate), new SqlParameter("@toTime", i.toTime), new SqlParameter("@interviewStatus", i.interviewStatus), new SqlParameter("@location", i.location), new SqlParameter("@scheduleComments", i.scheduleComments), new SqlParameter("@crtUserId", i.crtUserId) };
return(Convert.ToInt32(_sf.executeScalerWithProc("p_tblInterviews_save", _param)));
}
public void ClickInterviews()
{
Interviews.WaitAndClick(_driver);
}
public IEnumerable <Interview> PaginatedInterview()
{
int start = (CurrentPage - 1) * InterviewPerPage;
return(Interviews.OrderBy(b => b.InterviewId).Skip(start).Take(InterviewPerPage));
}
public int PageCount()
{
return(Convert.ToInt32(Math.Ceiling(Interviews.Count() / (double)InterviewPerPage)));
}
/// <summary>
/// Click the Interviews link on the main menu
/// </summary>
public void ClickInterviews()
{
Interviews.WaitRetry(_driver).Click();
}
