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