//
// Function: public int Generate_New()
//
// Purpose: Create a new ticket with some default values so we don't run into NULL's
//
public void Generate_New(Users cuser, Site_Tickets cticket)
{
Site_ID = cticket.Site_ID;
Ticket_ID = cticket.Ticket_ID;
Ticket_Task_ID = 0;
Creator_ID = 0;
Creator = cuser.User_Name;
Created_On = DateTime.Now;
Task_Status = 0;
Task_ID = 0;
Priority = 0;
Task_Overview = "New Task";
Task_Details = "";
Assigned_User_ID = cuser.User_ID;
Progress = 0;
Due_On = DateTime.Now;
Started_TS = DateTime.Parse("Jan 1, 1980");
Completed_TS = DateTime.Parse("Jan 1, 1980");
Notes = "";
Alarm1 = DateTime.Now;
Alarm1_Enabled = false;
Alarm1_Ack_TS = DateTime.Now;
Alarm2 = DateTime.Now;
Alarm2_Enabled = false;
Alarm2_Ack_TS = DateTime.Now;
Alarm3 = DateTime.Now;
Alarm3_Enabled = false;
Alarm3_Ack_TS = DateTime.Now;
Late_Alarm = false;
Site = cticket.Site;
Assigned_User = cuser.User_Name;
}
/* private void Task_Grid_SelectionChanged(object sender, SelectionChangedEventArgs e)
* {
* if (Task_Grid.SelectedIndex > -1)
* {
* Tickets_Tasks sel_row;
* // Get the ticket_id from the list
* sel_row = (Tickets_Tasks)Task_Grid.SelectedItem;
* long task_id = sel_row.Task_ID;
* Task_Detail.Content = new UC_Task_Details(task_id);
* Task_Detail.Visibility = Visibility.Visible;
* btn_Task_Detail.Visibility = Visibility.Visible;
* }
* else
* btn_Task_Detail.Visibility = Visibility.Hidden;
* }
*/
private void Sel_row_PropertyChanged(object sender, PropertyChangedEventArgs e)
{
Site_Tickets changed_ticket = (Site_Tickets)sender;
if (e.PropertyName == "Saved" && changed_ticket.Saved == true)
{
Load_Site_Tickets();
changed_ticket.Saved = false;
}
if (e.PropertyName == "Canceled" && changed_ticket.Canceled == true)
{
Load_Site_Tickets();
Ticket_Detail.Visibility = Visibility.Hidden;
changed_ticket.Canceled = false;
changed_ticket.Changed = false;
}
Site_Ticket_List.IsEnabled = true;
for (int i = 0; i < site_tickets.Count; i++)
{
if (site_tickets[i].Changed)
{
Site_Ticket_List.IsEnabled = false;
}
}
Site_Ticket_List.UpdateLayout();
}
public UC_Ticket_Details(Site_Tickets Ticket_Info)
{
Active_Ticket = Ticket_Info;
// Set binding attributes to the Active Ticket
this.DataContext = Active_Ticket;
InitializeComponent();
Active_Ticket.PropertyChanged += Active_Ticket_PropertyChanged;
if (Active_Ticket.Just_Created)
{
txt_Ticket_No.Visibility = Visibility.Hidden;
tb_Ticket_ID.Visibility = Visibility.Hidden;
btn_Cancel_Ticket.Visibility = Visibility.Visible;
btn_Save_Ticket.Visibility = Visibility.Visible;
}
else
{
txt_Ticket_No.Visibility = Visibility.Visible;
tb_Ticket_ID.Visibility = Visibility.Visible;
btn_Cancel_Ticket.Visibility = Visibility.Hidden;
btn_Save_Ticket.Visibility = Visibility.Hidden;
}
}
//
// 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 UC_Ticket_Tasks(Site_Tickets Ticket, Users User)
{
this.DataContext = this;
active_tasks = new ObservableCollection <Tickets_Tasks>();
CTicket = Ticket;
CUser = User;
InitializeComponent();
btn_Task_Detail.Visibility = Visibility.Hidden;
Load_Task_Details(CTicket.Ticket_ID, CUser.User_ID, (bool)ticket_tasks_viewall.IsChecked);
txt_Ticket_ID.Text = CTicket.Ticket_ID.ToString();
}
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;
}
}
