// // Function: public void Remove_User(int user_type, int index_no) // // Arguments: int user_type = Type of user to remove (0 = System User, 1 = Site) // int index_no = Index number of user to remove from list // // Purpose: Removes an entire record of a user at a certain index // public void Remove_User(int user_type, int index_no) { User_Name.RemoveAt(index_no); User_ID.RemoveAt(index_no); Access.RemoveAt(index_no); if (user_type == 1) { Site_User_ID.RemoveAt(index_no); Site_ID.RemoveAt(index_no); View_Resources.RemoveAt(index_no); Add_Resources.RemoveAt(index_no); Modify_Resources.RemoveAt(index_no); Del_Resources.RemoveAt(index_no); View_Tickets.RemoveAt(index_no); Add_Tickets.RemoveAt(index_no); } }
// // Function: public int Save_Site(int mode) // // Arguments: int mode = Mode of save (0 = Save New, 1 = Update) // // Purpose: Display the Login dialog and try logging in if a name was entered and Login button pressed // public int Save_Site(int mode) { // If the user name is blank then get it from the system and try to log in with AD security string connString = SQLConnString; string SaveCmd = ""; int SqlResult = 0; StringBuilder query = new StringBuilder(""); using (SqlConnection sqlCon = new SqlConnection(connString)) { switch (mode) { case 0: query.Append("INSERT INTO "); query.Append(tblSiteInfo); query.Append(" "); query.Append(tblSiteFields); query.Append(" "); query.Append(tblSiteInsert); SaveCmd = query.ToString(); using (SqlCommand SqlCmd = new SqlCommand(SaveCmd)) { // Write the current site information to the database SqlCmd.Connection = sqlCon; SqlCmd.Parameters.AddWithValue("@short_name", Short_Name); SqlCmd.Parameters.AddWithValue("@full_name", Full_Name); SqlCmd.Parameters.AddWithValue("@customer_name", Customer_Name); SqlCmd.Parameters.AddWithValue("@address", Address); SqlCmd.Parameters.AddWithValue("@job_number", Job_Number); try { sqlCon.Open(); SqlResult = SqlCmd.ExecuteNonQuery(); } catch (SqlException e) { if (e.Number == 2627) { MessageBox.Show("A site with this name already exists. Please select a unique site name and try again.", "Site Exists", MessageBoxButton.OK, MessageBoxImage.Error); } else { MessageBox.Show(e.Message, "Failed To Save Site", MessageBoxButton.OK, MessageBoxImage.Error); } SqlResult = 0; } } sqlCon.Close(); break; case 1: query.Append("UPDATE "); query.Append(tblSiteInfo); query.Append(" "); query.Append(tblSiteUpdate); query.Append(Site_ID.ToString()); SaveCmd = query.ToString(); using (SqlCommand SqlCmd = new SqlCommand(SaveCmd)) { SqlCmd.Connection = sqlCon; SqlCmd.Parameters.AddWithValue("@short_name", Short_Name); SqlCmd.Parameters.AddWithValue("@full_name", Full_Name); SqlCmd.Parameters.AddWithValue("@customer_name", Customer_Name); SqlCmd.Parameters.AddWithValue("@address", Address); SqlCmd.Parameters.AddWithValue("@job_number", Job_Number); try { sqlCon.Open(); SqlResult = SqlCmd.ExecuteNonQuery(); } catch (SqlException e) { if (e.Number == 2627) { MessageBox.Show("A site with this name already exists. Please select a unique site name and try again.", "Site Exists", MessageBoxButton.OK, MessageBoxImage.Error); } else { MessageBox.Show(e.Message, "Failed To Save Site", MessageBoxButton.OK, MessageBoxImage.Error); } SqlResult = 0; } } sqlCon.Close(); break; } } return(SqlResult); }
public override string ToString() { return(Site_ID.ToString() + Campground_ID.ToString() + Site_Number.ToString() + Max_Occupancy.ToString() + Accessible.ToString() + Max_RV_Length.ToString() + Utilities.ToString()); }
// // Function: public void Get_List(int mode, long site_id) // // Arguments: int mode = Mode of list to get (0 = All Users, 1 = Only Users For This Site) // long site_id = Site ID to get the list for (if mode is 1) // // Purpose: Gets a list of all users (mode = 0) or ones granted rights to see a site (mode = 1) // public void Get_List(int mode, long site_id = 0) { List <int> site_users = new List <int>(); Initialize(); // If the user name is blank then get it from the system and try to log in with AD security string connString = SQLConnString; // Query the User Database for the user StringBuilder query = new StringBuilder("SELECT * FROM "); switch (mode) { // All Users case 0: query.Append(tblUserInfo); query.Append(" ORDER BY User_Name"); using (SqlConnection sqlCon = new SqlConnection(connString)) { sqlCon.Open(); SqlCommand SqlCmd = new SqlCommand(query.ToString(), sqlCon); using SqlDataReader reader = SqlCmd.ExecuteReader(); while (reader.Read()) { User_ID.Add((int)reader[0]); User_Name.Add(String.Format("{0}", reader[1])); Access.Add((int)reader[2]); } sqlCon.Close(); } break; // Site_ID users case 1: query.Append(tblSiteUsers); query.Append(" WHERE Site_ID = "); query.Append(site_id.ToString()); // Get list of User_ID's using (SqlConnection sqlCon = new SqlConnection(connString)) { sqlCon.Open(); SqlCommand SqlCmd = new SqlCommand(query.ToString(), sqlCon); using SqlDataReader reader = SqlCmd.ExecuteReader(); while (reader.Read()) { Site_User_ID.Add((long)reader[0]); Site_ID.Add((long)reader[1]); site_users.Add((int)reader[2]); User_ID.Add((int)reader[2]); View_Resources.Add((bool)reader[3]); Add_Resources.Add((bool)reader[4]); Modify_Resources.Add((bool)reader[5]); Del_Resources.Add((bool)reader[6]); View_Tickets.Add((bool)reader[7]); Add_Tickets.Add((bool)reader[8]); Mark_Delete.Add(false); } sqlCon.Close(); } // Convert that list to actual names for display foreach (int id in site_users) { query.Clear(); query.Append("SELECT * FROM "); query.Append(tblUserInfo); query.Append(" WHERE User_ID = "); query.Append(id.ToString()); using (SqlConnection sqlCon = new SqlConnection(connString)) { sqlCon.Open(); SqlCommand SqlCmd = new SqlCommand(query.ToString(), sqlCon); using SqlDataReader reader = SqlCmd.ExecuteReader(); while (reader.Read()) { User_Name.Add(String.Format("{0}", reader[1])); } sqlCon.Close(); } } break; } }
public override string ToString() { return(Reservation_ID.ToString() + Site_ID.ToString() + Name + From_Date.ToString() + To_Date.ToString() + Create_Date.ToString()); }