// // Function: private void Add_Ticket() // // Purpose: Add a new ticket to the current site // private void Add_Ticket() { Site_Tickets new_ticket = new Site_Tickets(); new_ticket.Generate_New(site_id.Site_ID, "", cuser.User_ID, cuser.User_Name); new_ticket.Get_Site_Name(site_id.Site_ID); site_tickets.Add(new_ticket); if (Site_Ticket_List.Visibility == Visibility.Hidden) { Site_Ticket_List.Visibility = Visibility.Visible; } }
public void Load_Site_Tickets() { int current_tick = 0; DB_Users users = new DB_Users(); users.Get_List(0); // Delete the site tickets array before starting site_tickets.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(tblTickets); query.Append(" WHERE Site_ID = '"); query.Append(site_id.Site_ID); query.Append("'"); // If select all is not enabled, only show this users tickets if ((bool)site_tickets_viewall.IsChecked == false) { query.Append(" AND Creator_ID = '"); query.Append(cuser.User_ID); query.Append("'"); } // Read all the tickets associated with this user using (SqlConnection sqlCon = new SqlConnection(connString)) { sqlCon.Open(); SqlCommand SqlCmd = new SqlCommand(query.ToString(), sqlCon); using SqlDataReader reader = SqlCmd.ExecuteReader(); while (reader.Read()) { Site_Tickets site_ticket = new Site_Tickets(); site_ticket.Site_ID = ((long)reader[0]); site_ticket.Get_Site_Name(site_ticket.Site_ID); site_ticket.Ticket_ID = ((long)reader[1]); site_ticket.Creator_User_ID = ((long)reader[2]); for (int i = 0; i < users.User_ID.Count; i++) { if (users.User_ID[i] == (int)site_ticket.Creator_User_ID) { site_ticket.Creator = users.User_Name[i]; break; } } site_ticket.Created_On = ((DateTime)reader[3]); if (!DBNull.Value.Equals(reader[4])) { site_ticket.Due_On = ((DateTime)reader[4]); } if (!DBNull.Value.Equals(reader[5])) { site_ticket.Brief_Desc = ((string)reader[5]); } if (!DBNull.Value.Equals(reader[6])) { site_ticket.Long_Desc = ((string)reader[6]); } if (!DBNull.Value.Equals(reader[7])) { site_ticket.Ticket_Status = ((int)reader[7]); } if (!DBNull.Value.Equals(reader[8])) { site_ticket.Completed_TS = ((DateTime)reader[8]); } if (!DBNull.Value.Equals(reader[9])) { site_ticket.Notes = ((string)reader[9]); } if (!DBNull.Value.Equals(reader[10])) { site_ticket.Total_Tasks = ((int)reader[10]); } if (!DBNull.Value.Equals(reader[11])) { site_ticket.Completed_Tasks = ((int)reader[11]); } if (!DBNull.Value.Equals(reader[12])) { site_ticket.Active_Tasks = ((int)reader[12]); } site_ticket.Changed = false; site_tickets.Add(site_ticket); current_tick++; } } if (current_tick == 0) { Site_Ticket_List.Visibility = Visibility.Hidden; } else { Site_Ticket_List.Visibility = Visibility.Visible; } }