private bool Get_Support_Tickets() { try { //MySQL_ITIS A = new MySQL_ITIS(); if (MySQL_ITIS.openConnection() == false) { throw new Exception("MySQL Connection is not open!"); } if (MySQL_ITIS.cmd != null) { MySQL_ITIS.cmd.Dispose(); } string _Query = null; _Query = Pub.isIT_Support() ? "SELECT * FROM IT_WORKSTATIONS.tickets_new;" : string.Format("SELECT * FROM IT_WORKSTATIONS.tickets_new WHERE tickets_new.requestee LIKE '{0}' and DATE_FILED >= '2021-05-01';", Pub.MyDisplayName()); //_Query = "SELECT * FROM IT_WORKSTATIONS.tickets_new;"; MySQL_ITIS.cmd = new MySqlCommand(_Query); MySQL_ITIS.conn.Open(); MySQL_ITIS.cmd.Connection = MySQL_ITIS.conn; MySql.Data.MySqlClient.MySqlDataReader r = MySQL_ITIS.cmd.ExecuteReader(); Support_Tickets = new List <Support_Ticket>(); while (r.Read()) { Support_Tickets.Add(new Support_Ticket { _TicketID = int.Parse(r.GetString("ticketid")).ToString("000000"), _Date_Filed = DateTime.Parse(r.GetString("Date_Filed")).ToString("MM/dd/yyyy"), _Requestee = r.GetString("Requestee"), _Description = r.IsDBNull(3) ? null : r.GetString("description"), _Status = r.GetString("status"), _Last_Update = r.IsDBNull(5) ? null : DateTime.Parse(r.GetString("Last_Update")).ToString("MM/dd/yyyy"), _Assigned_IT = r.IsDBNull(6) ? null : r.GetString("Assigned_IT"), _IT_Remarks = r.IsDBNull(7) ? null : r.GetString("IT_Remarks"), TAG = Set_TAG(r.GetString("status")) }); } MySQL_ITIS.conn.Close(); MySQL_ITIS.conn.Dispose(); return(true); } catch (Exception ex) { MessageBox.Show("Error : " + ex.Message, "CSF TICKETING", MessageBoxButton.OK, MessageBoxImage.Error); return(false); } }
private bool LOAD_CSF_Users() { try { //Task t = Task.Run(() => //{ if (MySQL_ITIS.openConnection() == false) { throw new Exception("MySQL Connection is not open!"); } MySqlCommand _cmd = new MySqlCommand("SELECT WS_USERS.NAME FROM IT_WORKSTATIONS.WS_USERS ORDER BY WS_USERS.NAME;") { Connection = MySQL_ITIS.conn }; MySqlDataReader _r = _cmd.ExecuteReader(); if (CboRequestee.Items.Count > 0) { CboRequestee.Items.Clear(); } ComboBoxItem CboItem; while (_r.Read()) { CboItem = new ComboBoxItem() { Content = _r.GetString("name") }; CboRequestee.Items.Add(CboItem); } _cmd.Dispose(); MySQL_ITIS.conn.Close(); MySQL_ITIS.conn.Dispose(); //}); //TimeSpan ts = TimeSpan.FromSeconds(60); //if (!t.Wait(ts)) // throw new Exception("LOAD CSF USERS : Timeout interval of 60 seconds elapsed."); return(true); } catch (Exception ex) { MessageBox.Show("Error : " + ex.Message, "CSF TICKETING", MessageBoxButton.OK, MessageBoxImage.Error); return(false); } }
private bool PERFORM_DELETION(string _ID) { try { bool result = false; using (MySqlCommand cmd = new MySqlCommand()) { /// OPEN CONNECTION TO MYSQL SERVER if (MySQL_ITIS.openConnection() == false) { throw new Exception("MySQL Connection is not open!"); } cmd.Connection = MySQL_ITIS.conn; var MyQuery = @"DELETE FROM IT_WORKSTATIONS.TICKETS_NEW WHERE TICKETID = @TicketID;"; cmd.CommandText = MyQuery; cmd.Parameters.AddWithValue("@TicketID", _ID); MySqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { result = rdr.RecordsAffected > 0 ? true : false; } MySQL_ITIS.conn.Close(); MySQL_ITIS.conn.Dispose(); } return(result); } catch (Exception) { throw; } }
private bool PERFORM_UPDATE(string _ID) { try { bool Result = false; using (MySqlCommand cmd = new MySqlCommand()) { if (MySQL_ITIS.openConnection() == false) { throw new Exception("MySQL connection is not open!"); } var MyQuery = ""; /// if NOT IT Support if (Pub.isIT_Support() == false) { MyQuery = "UPDATE IT_WORKSTATIONS.TICKETS_NEW " + "SET LAST_UPDATE=@LastUpdate, REQUESTEE=@Requestee, DESCRIPTION=@Remarks) " + "WHERE TICKETID=@TicketID;"; } /// if IT SUPPORT Member else { MyQuery = "UPDATE IT_WORKSTATIONS.TICKETS_NEW " + "SET LAST_UPDATE=@LastUpdate, REQUESTEE=@Requestee, DESCRIPTION=@Remarks, TICKETS_NEW.STATUS=@Status, ASSIGNED_ID=@AssignedIT, IT_REMARKS=@ITRemarks) " + "WHERE TICKETID=@TicketID;"; } cmd.CommandText = MyQuery; string Requestee = Pub.isIT_Support() ? ((CboRequestee.SelectedItem != null) ? (CboRequestee.SelectedItem as ComboBoxItem).Content.ToString() : CboRequestee.Text) : Pub.MyDisplayName(); cmd.Parameters.AddWithValue("@LastUpdate", DateTime.Today.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@Requestee", Requestee); cmd.Parameters.AddWithValue("@Description", TxtRemarks.Text); cmd.Parameters.AddWithValue("@TicketID", _ID); if (Pub.isIT_Support() == true) { cmd.Parameters.AddWithValue("@Status", (CboStatus.SelectedItem as ComboBoxItem).Content.ToString()); cmd.Parameters.AddWithValue("@AssignedIT", (CboAssignedSupport.SelectedItem as ComboBoxItem).Content.ToString()); cmd.Parameters.AddWithValue("@ITRemarks", TxtITRemarks.Text); } cmd.Connection = MySQL_ITIS.conn; MySqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { Result = rdr.RecordsAffected > 0 ? true : false; } MySQL_ITIS.conn.Close(); MySQL_ITIS.conn.Dispose(); } return(Result); } catch (Exception) { throw; } }