// // Function: private void Make_User_List(int mode) // // Arguments: int mode = Mode of operation (0 = All Users, 1 = Just this site's users // // Purpose: Display the User List for a new or existing site // private void Make_User_List(int mode) { View_Users.Clear(); DB_Users users = new DB_Users(); if (mode == 0) { users.Get_List(0); } else { users.Get_List(1, csite.site_info.Site_ID); } for (int i = 0; i < users.User_Name.Count; i++) { Users user = new Users(); user.PropertyChanged += User_PropertyChanged; user.Convert_DB_Users(users, i); View_Users.Add(user); View_Users[i].Changed = false; View_Users[i].Mark_Delete = false; } Changes_Made = false; }
public Users Get_User_Settings(long site_id, int user_id) { DB_Users users = new DB_Users(); Users blank_user = new Users(); users.Get_List(1, site_id); for (int q = 0; q < users.User_Name.Count; q++) { Users user = new Users(); user.Convert_DB_Users(users, q); if (user.User_ID == user_id) { return(user); } } return(blank_user); }
private void Generate_User_List(List <Users> exclude_users) { DB_Users all_users = new DB_Users(); all_users.Get_List(0); for (int i = 0; i < exclude_users.Count; i++) { int x = all_users.User_ID.IndexOf(exclude_users[i].User_ID); if (x != -1) { all_users.Remove_User(0, x); } } avail_users = new ObservableCollection <DB_Users>(); avail_users.Add(all_users); }
public void Load_Task_Details(long Ticket_ID, int User_ID, bool All_Tasks) { int task_count = 0; DB_Users users = new DB_Users(); users.Get_List(0); // Read all the tickets for the assigned ticket ID active_tasks.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(tblTasks); query.Append(" WHERE Ticket_ID = '"); query.Append(Ticket_ID); query.Append("'"); // If select all is not enabled, only show this users tickets if (All_Tasks == false) { query.Append(" AND (Assigned_User_ID = '"); query.Append(User_ID); query.Append("' OR Creator_ID = '"); query.Append(User_ID); query.Append("')"); } // Read all the tasks associated with this ticket using (SqlConnection sqlCon = new SqlConnection(connString)) { sqlCon.Open(); SqlCommand SqlCmd = new SqlCommand(query.ToString(), sqlCon); using SqlDataReader reader = SqlCmd.ExecuteReader(); while (reader.Read()) { Tickets_Tasks ticket_task = new Tickets_Tasks(); ticket_task.Site_ID = ((long)reader[0]); ticket_task.Ticket_ID = ((long)reader[1]); ticket_task.Ticket_Task_ID = ((long)reader[2]); ticket_task.Creator_ID = ((int)reader[3]); for (int i = 0; i < users.User_ID.Count; i++) { if (users.User_ID[i] == ticket_task.Creator_ID) { ticket_task.Creator = users.User_Name[i]; } } if (!DBNull.Value.Equals(reader[4])) { ticket_task.Created_On = ((DateTime)reader[4]); } if (!DBNull.Value.Equals(reader[5])) { ticket_task.Task_Status = ((int)reader[5]); } if (!DBNull.Value.Equals(reader[6])) { ticket_task.Task_ID = ((long)reader[6]); } if (!DBNull.Value.Equals(reader[7])) { ticket_task.Priority = ((int)reader[7]); } if (!DBNull.Value.Equals(reader[8])) { ticket_task.Task_Overview = ((string)reader[8]); } if (!DBNull.Value.Equals(reader[9])) { ticket_task.Task_Details = ((string)reader[9]); } if (!DBNull.Value.Equals(reader[10])) { ticket_task.Assigned_User_ID = ((int)reader[10]); } for (int i = 0; i < users.User_ID.Count; i++) { if (users.User_ID[i] == ticket_task.Assigned_User_ID) { ticket_task.Assigned_User = users.User_Name[i]; } } if (!DBNull.Value.Equals(reader[11])) { ticket_task.Progress = ((int)reader[11]); } if (!DBNull.Value.Equals(reader[12])) { ticket_task.Due_On = ((DateTime)reader[12]); } if (!DBNull.Value.Equals(reader[13])) { ticket_task.Started_TS = ((DateTime)reader[13]); } if (!DBNull.Value.Equals(reader[14])) { ticket_task.Completed_TS = ((DateTime)reader[14]); } if (!DBNull.Value.Equals(reader[15])) { ticket_task.Notes = ((string)reader[15]); } if (!DBNull.Value.Equals(reader[16])) { ticket_task.Alarm1_Enabled = ((bool)reader[16]); } if (!DBNull.Value.Equals(reader[17])) { ticket_task.Alarm1 = ((DateTime)reader[17]); } if (!DBNull.Value.Equals(reader[18])) { ticket_task.Alarm1_Ack_TS = ((DateTime)reader[18]); } if (!DBNull.Value.Equals(reader[19])) { ticket_task.Alarm2_Enabled = ((bool)reader[19]); } if (!DBNull.Value.Equals(reader[20])) { ticket_task.Alarm2 = ((DateTime)reader[20]); } if (!DBNull.Value.Equals(reader[21])) { ticket_task.Alarm2_Ack_TS = ((DateTime)reader[21]); } if (!DBNull.Value.Equals(reader[22])) { ticket_task.Alarm3_Enabled = ((bool)reader[22]); } if (!DBNull.Value.Equals(reader[23])) { ticket_task.Alarm3 = ((DateTime)reader[23]); } if (!DBNull.Value.Equals(reader[24])) { ticket_task.Alarm3_Ack_TS = ((DateTime)reader[24]); } if (!DBNull.Value.Equals(reader[25])) { ticket_task.Late_Alarm = ((bool)reader[25]); } active_tasks.Add(ticket_task); task_count++; } } if (task_count == 0) { Task_Grid.Visibility = Visibility.Hidden; } else { Task_Grid.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; } }