protected void GridActionWaitingList(object sender, GridViewCommandEventArgs e)
{
int tripId = Convert.ToInt32(Request.QueryString["tripId"]);
GridViewRow row = GridViewRegistered.SelectedRow;
string RegisterID = e.CommandArgument.ToString();
int staffId = Convert.ToInt32(Session["StaffId"]);
if (e.CommandName == "Shortlist")
{
TripDAO TripDAO = new TripDAO();
Trip TripList = new Trip();
int TRIPPYLIST;
TRIPPYLIST = TripDAO.updateShortlisted(RegisterID, tripId);
InterviewDAO intDao = new InterviewDAO();
string adminNo = intDao.exchangeRegIdForAdminNo(RegisterID);
int updateStuds = intDao.selectForInterview(adminNo, staffId, tripId);
Response.Redirect(Request.RawUrl);
}
else if (e.CommandName == "Move to pending")
{
TripDAO TripDAO = new TripDAO();
Trip TripList = new Trip();
int TRIPPYLIST;
TRIPPYLIST = TripDAO.updateRegistered(RegisterID, tripId);
Response.Redirect(Request.RawUrl);
}
}
public static string emailStudent(string emailDate, string emailTime, string intId)
{
System.Diagnostics.Debug.WriteLine(emailDate + " this is tripId@@@ ");
System.Diagnostics.Debug.WriteLine(emailTime + " this is adminNo@@@ ");
InterviewDAO interviewDao = new InterviewDAO();
interviewDao.insertDateTime(intId, emailDate, emailTime);
string adminNo = interviewDao.exchangeIntIdForAdminNo(intId);
SmtpClient client = new SmtpClient();
client.Port = 25;
client.Host = "smtp-mail.outlook.com";
client.EnableSsl = true;
client.Timeout = 10000;
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "msJasmine1");
//string recipient = adminNo + "@mymail.nyp.edu.sg";
MailMessage mail = new MailMessage("*****@*****.**", "*****@*****.**");
mail.Subject = "You are scheduled for an interview!";
mail.Body = "The interview will be on " + emailDate + ", " + emailTime;
client.Send(mail);
return(emailDate + emailTime);
}
protected void Button1_Click(object sender, EventArgs e)
{
sessionId = Request.QueryString["sessionId"];
token = Request.QueryString["token"];
string remarks = remarksTb.Text;
InterviewDAO intDao = new InterviewDAO();
intDao.submitRemarks(token, sessionId, remarks);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Adminno"] == null)
{
Response.Redirect("./loginStudent.aspx");
}
else
{
string adminNo = Session["AdminNo"].ToString();
InterviewDAO interviewDao = new InterviewDAO();
intSessions = interviewDao.fetchSession(adminNo);
}
}
public bool PostInterview(InterviewDAO interview)
{
InterviewServiceClient client = new InterviewServiceClient();
try
{
bool result = client.CreateInterview(interview);
return result;
}
catch (FaultException<KaskServiceException> e)
{
throw new HttpException(e.Message);
}
}
public static string createSession(int intId)
{
int apiKey = 46243942;
string apiSecret = "f12c7bc2592d9b613b3e2fadae2cbbf0bc32cb2d";
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
var OpenTok = new OpenTok(apiKey, apiSecret);
var session = OpenTok.CreateSession();
string sessionId = session.Id;
string token = session.GenerateToken();
InterviewDAO interviewDao = new InterviewDAO();
interviewDao.createSession(sessionId, token, intId);
return(token + "__________" + sessionId);
}
protected void Page_Load(object sender, EventArgs e)
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
if (Session["role"] == null)
{
Response.Redirect("loginStudent.aspx");
}
sessionId = Request.QueryString["sessionId"];
token = Request.QueryString["token"];
if (sessionId == null || token == null)
{
Response.Redirect("loginStudent.aspx");
}
InterviewDAO intDao = new InterviewDAO();
string adminNo = intDao.checkSession(sessionId, token);
if (Session["role"].ToString() != "Incharge")
{
if (adminNo != Session["adminNo"].ToString())
{
Response.Redirect("./Oops.aspx");
}
}
}
public async Task<ActionResult> Create(FormCollection collection)
{
try
{
if (Request.Form["acknowledgeAccurateDataCheckbox"] != null)
{
// save application form data back to database through service
using (HttpClient httpClient = new HttpClient())
{
httpClient.BaseAddress = new Uri("http://localhost:51309");
httpClient.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage result = new HttpResponseMessage();
string resultContent = "";
// find applicant id from the previously submitted Application form, if available
int applicantID = 0;
if (Convert.ToInt32(Request.Form["applicantID"]) > 0)
{
applicantID = Convert.ToInt32(Request.Form["applicantID"]);
}
// otherwise, get last applicant id from database
else
{
var applieds = await ServerResponse<List<AppliedDAO>>.GetResponseAsync(ServiceURIs.ServiceAppliedUri);
applicantID = applieds.Last().ApplicantID;
}
// and save the short answer responses (both to SAResponses and to Interview tables)
// TODO: change the hardcoded "50" into some sort of variable
// (i.e. the length of all possible SA responses from form)
for (int i = 0; i < 50; i++)
{
try
{
if (Request.Form["SAResponse_" + i] != null)
{
// save short answer response to SAResponses, first
// so gather up response info:
SAResponseDAO saResponse = new SAResponseDAO();
saResponse.SAResponseDescription = Request.Form["SAResponse_" + i];
// post (save) short answer response data to SAResponses
result = httpClient.PostAsJsonAsync(ServiceURIs.ServiceSAResponseUri, saResponse).Result;
resultContent = result.Content.ReadAsStringAsync().Result;
// then get last inserted short answer response ID for the Interview table later
var saResponses = await ServerResponse<List<SAResponseDAO>>.GetResponseAsync(ServiceURIs.ServiceSAResponseUri);
int lastInsertedSaResponseId = saResponses.Last().SAResponseID;
// gather short answer response data
InterviewDAO interview = new InterviewDAO();
interview.ApplicantID = applicantID;
interview.SAQuestionID = i;
interview.SAResponseID = lastInsertedSaResponseId;
//interview.UserID = applicantID; // this might be overlapping... we might just need applicantID for later matchups...
// post (save) short answer response data to Interview table
result = httpClient.PostAsJsonAsync(ServiceURIs.ServiceInterviewUri, interview).Result;
resultContent = result.Content.ReadAsStringAsync().Result;
}
}
catch { }
}
}
// allow applicant to either create new account or log in
return RedirectToAction("Register", "Account");
}
else
{
// TODO: validation later on...
return RedirectToAction("Create");
}
}
catch
{
// TODO: validation later on...
return RedirectToAction("Create");
}
}
