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