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."; } }