public static void takeEmptyDuty(int userID, string week, int shiftID, int locationID, string day, int status, int orderNumber)
{
technical_assistant newTA = new technical_assistant();
object[] requestDetails = new object[11];
requestDetails[0] = week;
requestDetails[1] = shiftID;
requestDetails[2] = locationID;
requestDetails[3] = day;
requestDetails[4] = string.Format("HH:mm:ss", DateTime.Now);
requestDetails[5] = DateTime.Now.ToString("yyy-MM-dd");
requestDetails[6] = getDayDate(day);
requestDetails[7] = status;
requestDetails[8] = 0; //0 means request type is duty request
requestDetails[9] = "Added after draft is out";
requestDetails[10] = orderNumber;
newTA.requestDuty(userID, requestDetails);
}
//query duty request into database
protected void queryDutyRequest(int shift_id, int location_id, string day)
{
int userID = int.Parse(Session["id"].ToString());
object[] requestDetails = new object[11];
requestDetails[0] = commonMethods.getNextMondayDate();
requestDetails[1] = shift_id;
requestDetails[2] = location_id;
requestDetails[3] = day;
requestDetails[4] = string.Format("HH:mm:ss", DateTime.Now);
requestDetails[5] = DateTime.Now.ToString("yyy-MM-dd");
requestDetails[6] = getDayDate(weekDaysList.SelectedValue);
requestDetails[7] = 0; //0 means request status is pending
requestDetails[8] = 0; //0 means request type is duty request
requestDetails[9] = remark.Text;
requestDetails[10] = 0;
technical_assistant TA_obj = new technical_assistant();
TA_obj.requestDuty(userID, requestDetails);
}
protected void save_btn_Click(object sender, EventArgs e)
{
technical_assistant TA_obj = new technical_assistant();
object[] TA_newInfo = new object[5];
TA_newInfo[0] = privateEmail.Text;
TA_newInfo[1] = address.Text;
TA_newInfo[2] = intake.Text;
TA_newInfo[3] = gpa.Text;
TA_newInfo[4] = contactNumber.Text;
int userID = Int32.Parse(Session["id"].ToString());
try
{
TA_obj.editProfile(userID, TA_newInfo);
msg.Text = "Your details has been updated, thank you!";
}
catch (Exception ex)
{
msg.Text = "Information could not be updated, error: " + ex.Message;
}
}
private void populateFields()
{
string hr_count, probs_count, position_name, selection_date;
try
{
technical_assistant ta = new technical_assistant();
int id = Int32.Parse(Session["id"].ToString());
object[] taInfo = new object[13];
Array.Copy(ta.viewProfile(id), taInfo, 12);
db_connection db_obj = new db_connection();
db_obj.open();
int userID = Int32.Parse(Session["id"].ToString());
/*
* SELECT CAST(SUM(FORMAT(TIME_TO_SEC(TIMEDIFF(fypdb.attendance.logout_time, fypdb.attendance.login_time))/3600, 2)) AS DECIMAL(5,2)) AS 'working_hour' FROM
* attendance inner join user on user.user_id=attendance.user_id WHERE user.user_id=89 AND attendance.logout_date between '2015-12-01 00:00:00' and '2016-06-01 23:59:59'
*
*
*/
//inner join fypdb.user on fypdb.user.user_id=fypdb.problem.added_by
string query = "SELECT CAST(SUM(FORMAT(TIME_TO_SEC(TIMEDIFF(fypdb.attendance.logout_time, fypdb.attendance.login_time))/3600, 2)) AS DECIMAL(5,2)) AS 'working_hour' FROM " +
" attendance WHERE attendance.user_id='" + userID + "' ";
string query1 = " SELECT Count(prob_user.user_id) AS 'Number of solved problems' FROM " +
" prob_user WHERE prob_user.user_id='" + userID + "' AND prob_user.action = 's' ;";
string query2 = " SELECT fypdb.position.title from fypdb.position inner join fypdb.user on fypdb.user.position_id=fypdb.position.position_id where fypdb.user.user_id='" + userID + "' ";
string query3 = " SELECT user.selection_date from fypdb.user where fypdb.user.user_id='" + userID + "' ";
MySqlCommand cmd = new MySqlCommand(query, db_obj.connection);
cmd.Parameters.AddWithValue("@userID", userID);
MySqlCommand cmd1 = new MySqlCommand(query1, db_obj.connection);
cmd1.Parameters.AddWithValue("@userID", userID);
MySqlCommand cmd2 = new MySqlCommand(query2, db_obj.connection);
cmd2.Parameters.AddWithValue("@userID", userID);
MySqlCommand cmd3 = new MySqlCommand(query3, db_obj.connection);
cmd3.Parameters.AddWithValue("@userID", userID);
if ((null != cmd.ExecuteScalar()) || (null != cmd1.ExecuteScalar()) || (null != cmd2.ExecuteScalar()) || (null != cmd3.ExecuteScalar()))
{
hr_count = cmd.ExecuteScalar().ToString();
probs_count = cmd1.ExecuteScalar().ToString();
position_name = cmd2.ExecuteScalar().ToString();
selection_date = cmd3.ExecuteScalar().ToString();
hr.Text = hr_count;
problems.Text = probs_count;
position_id.Text = position_name;
selection_date_lb.Text = selection_date;
}
db_obj.close();
name.Text = taInfo[0].ToString();
tp_number.Text = taInfo[1].ToString();
ta_number.Text = taInfo[2].ToString();
privateEmail.Text = taInfo[3].ToString();
contactNumber.Text = taInfo[4].ToString();
taEmail.Text = taInfo[5].ToString();
dob.Text = taInfo[6].ToString();
intake.Text = taInfo[7].ToString();
gpa.Text = taInfo[8].ToString();
warningLetters.Text = taInfo[11].ToString();
achievements.Text = taInfo[10].ToString();
address.Text = taInfo[9].ToString();
}
catch (Exception ex)
{
msg.Text = "There was something wrong.";
}
}
