// // Function: private void btn_Add_Task_Clicked(object sender, RoutedEventArgs e) // // Arguments: object sender = object that called function // RoutedEventArgs e = arguments for the event // // Purpose: Add a task to the currently selected ticket // private void btn_Add_Task_Clicked(object sender, RoutedEventArgs e) { Tickets_Tasks New_Task = new Tickets_Tasks(); New_Task.Generate_New(CUser, CTicket); active_tasks.Add(New_Task); }
public UC_Task_Details(Tickets_Tasks Ticket_Info) { Active_Task = Ticket_Info; // Set binding attributes to the Active Ticket this.DataContext = Active_Task; InitializeComponent(); Active_Task.PropertyChanged += Active_Ticket_PropertyChanged; if (Active_Task.Just_Created) { btn_Cancel_Task.Visibility = Visibility.Visible; btn_Save_Task.Visibility = Visibility.Visible; } else { btn_Cancel_Task.Visibility = Visibility.Hidden; btn_Save_Task.Visibility = Visibility.Hidden; } }
public void Load_Task_Details(long Ticket_ID, int User_ID, bool All_Tasks) { int task_count = 0; DB_Users users = new DB_Users(); users.Get_List(0); // Read all the tickets for the assigned ticket ID active_tasks.Clear(); // Open the database and retrieve tickets for the current user or all of them if all is selected string connString = SQLConnString; // Query the tickets for this site for this user StringBuilder query = new StringBuilder("SELECT * FROM "); query.Append(tblTasks); query.Append(" WHERE Ticket_ID = '"); query.Append(Ticket_ID); query.Append("'"); // If select all is not enabled, only show this users tickets if (All_Tasks == false) { query.Append(" AND (Assigned_User_ID = '"); query.Append(User_ID); query.Append("' OR Creator_ID = '"); query.Append(User_ID); query.Append("')"); } // Read all the tasks associated with this ticket using (SqlConnection sqlCon = new SqlConnection(connString)) { sqlCon.Open(); SqlCommand SqlCmd = new SqlCommand(query.ToString(), sqlCon); using SqlDataReader reader = SqlCmd.ExecuteReader(); while (reader.Read()) { Tickets_Tasks ticket_task = new Tickets_Tasks(); ticket_task.Site_ID = ((long)reader[0]); ticket_task.Ticket_ID = ((long)reader[1]); ticket_task.Ticket_Task_ID = ((long)reader[2]); ticket_task.Creator_ID = ((int)reader[3]); for (int i = 0; i < users.User_ID.Count; i++) { if (users.User_ID[i] == ticket_task.Creator_ID) { ticket_task.Creator = users.User_Name[i]; } } if (!DBNull.Value.Equals(reader[4])) { ticket_task.Created_On = ((DateTime)reader[4]); } if (!DBNull.Value.Equals(reader[5])) { ticket_task.Task_Status = ((int)reader[5]); } if (!DBNull.Value.Equals(reader[6])) { ticket_task.Task_ID = ((long)reader[6]); } if (!DBNull.Value.Equals(reader[7])) { ticket_task.Priority = ((int)reader[7]); } if (!DBNull.Value.Equals(reader[8])) { ticket_task.Task_Overview = ((string)reader[8]); } if (!DBNull.Value.Equals(reader[9])) { ticket_task.Task_Details = ((string)reader[9]); } if (!DBNull.Value.Equals(reader[10])) { ticket_task.Assigned_User_ID = ((int)reader[10]); } for (int i = 0; i < users.User_ID.Count; i++) { if (users.User_ID[i] == ticket_task.Assigned_User_ID) { ticket_task.Assigned_User = users.User_Name[i]; } } if (!DBNull.Value.Equals(reader[11])) { ticket_task.Progress = ((int)reader[11]); } if (!DBNull.Value.Equals(reader[12])) { ticket_task.Due_On = ((DateTime)reader[12]); } if (!DBNull.Value.Equals(reader[13])) { ticket_task.Started_TS = ((DateTime)reader[13]); } if (!DBNull.Value.Equals(reader[14])) { ticket_task.Completed_TS = ((DateTime)reader[14]); } if (!DBNull.Value.Equals(reader[15])) { ticket_task.Notes = ((string)reader[15]); } if (!DBNull.Value.Equals(reader[16])) { ticket_task.Alarm1_Enabled = ((bool)reader[16]); } if (!DBNull.Value.Equals(reader[17])) { ticket_task.Alarm1 = ((DateTime)reader[17]); } if (!DBNull.Value.Equals(reader[18])) { ticket_task.Alarm1_Ack_TS = ((DateTime)reader[18]); } if (!DBNull.Value.Equals(reader[19])) { ticket_task.Alarm2_Enabled = ((bool)reader[19]); } if (!DBNull.Value.Equals(reader[20])) { ticket_task.Alarm2 = ((DateTime)reader[20]); } if (!DBNull.Value.Equals(reader[21])) { ticket_task.Alarm2_Ack_TS = ((DateTime)reader[21]); } if (!DBNull.Value.Equals(reader[22])) { ticket_task.Alarm3_Enabled = ((bool)reader[22]); } if (!DBNull.Value.Equals(reader[23])) { ticket_task.Alarm3 = ((DateTime)reader[23]); } if (!DBNull.Value.Equals(reader[24])) { ticket_task.Alarm3_Ack_TS = ((DateTime)reader[24]); } if (!DBNull.Value.Equals(reader[25])) { ticket_task.Late_Alarm = ((bool)reader[25]); } active_tasks.Add(ticket_task); task_count++; } } if (task_count == 0) { Task_Grid.Visibility = Visibility.Hidden; } else { Task_Grid.Visibility = Visibility.Visible; } }