protected override bool Execute(CodeActivityContext context) { //Login не возвращает ID пока пишем в user_ID логин и ставим галку string user_ID = User_ID.Get(context); string eventSting = EventString.Get(context); byte applicationType = ApplicationType.Get(context); string commentString = CommentString.Get(context); string parentObjectID = ParentObjectID.Get(context); string parentObjectName = ParentObjectName.Get(context); string objectID = ObjectID.Get(context); string bjectName = ObjectName.Get(context); byte eventType = EventType.Get(context); try { DeclaratorService.Insert_ExplUserJournal(user_ID, eventSting, commentString, applicationType, 0, eventType, bjectName, objectID, parentObjectName, parentObjectID, true); } catch (Exception ex) { Error.Set(context, ex.Message); } return(string.IsNullOrEmpty(Error.Get(context))); }
// // 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); } }
protected override bool Execute(CodeActivityContext context) { string userLogin = UserLogin.Get(context); try { string userID = DeclaratorService.GetUserIDByLogin(userLogin); if (String.IsNullOrEmpty(userID)) { Error.Set(context, "пользователь не найден"); } User_ID.Set(context, userID); } catch (Exception ex) { Error.Set(context, ex.Message); } return(string.IsNullOrEmpty(Error.Get(context))); }
protected override bool Execute(CodeActivityContext context) { MemoryStream document = Document_In.Get(context); string user_ID = User_ID.Get(context); string fileName = FileName.Get(context); try { StreamExchange res = DeclaratorService.XMLImportMeterReplaces(new StreamExchange() { User_ID = user_ID, FileName = fileName, XMLStream = document }); if (!string.IsNullOrEmpty(res.Errors)) { Error.Set(context, res.Errors); } Document_Out.Set(context, res.XMLStream); } catch (Exception ex) { Error.Set(context, ex.Message); } finally { if (document != null) { document.Close(); document.Dispose(); } } return(string.IsNullOrEmpty(Error.Get(context))); }
// // Function: public void Save_List(int mode, long site_id = 0) // // Arguments: int mode = Mode of list to save (0 = All Users, 1 = Only Users For This Site) // long site_id = Site ID to get the list for (if mode is 1) // // Purpose: Saves a list of all users (mode = 0) or ones granted rights to see a site (mode = 1) // public bool Save_List(int mode, long site_id = 0) { List <int> site_users = new List <int>(); bool return_code = true; // 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; using (SqlConnection sqlCon = new SqlConnection(connString)) { switch (mode) { // All Users case 0: for (int j = 0; j < User_ID.Count; j++) { StringBuilder query = new StringBuilder(""); if (User_ID[j] == 0) { query.Append("INSERT INTO "); query.Append(tblUserInfo); query.Append(" "); query.Append(tblUserFields); query.Append(" "); query.Append(tblUserInsert); SaveCmd = query.ToString(); using (SqlCommand SqlCmd = new SqlCommand(SaveCmd)) { // Write the current site information to the database SqlCmd.Connection = sqlCon; SqlCmd.Parameters.AddWithValue("@user_name", User_Name[j]); SqlCmd.Parameters.AddWithValue("@access_level", Access[j]); try { if (sqlCon.State != ConnectionState.Open) { sqlCon.Open(); } SqlResult = SqlCmd.ExecuteNonQuery(); } catch (SqlException e) { if (e.Number == 2627) { MessageBox.Show("A user with this name already exists. Please select a unique user name and try again.", "User Exists", MessageBoxButton.OK, MessageBoxImage.Error); } else { MessageBox.Show(e.Message, "Failed To Save User", MessageBoxButton.OK, MessageBoxImage.Error); } SqlResult = 0; return_code = false; } } } else { query.Append("UPDATE "); query.Append(tblUserInfo); query.Append(" "); query.Append(tblUserUpdate); query.Append(User_ID.ToString()); SaveCmd = query.ToString(); using (SqlCommand SqlCmd = new SqlCommand(SaveCmd)) { SqlCmd.Connection = sqlCon; SqlCmd.Parameters.AddWithValue("@user_name", User_Name); SqlCmd.Parameters.AddWithValue("@access_level", Access); try { if (sqlCon.State != ConnectionState.Open) { sqlCon.Open(); } SqlResult = SqlCmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "Failed To Save Site", MessageBoxButton.OK, MessageBoxImage.Error); return_code = false; } } } } sqlCon.Close(); break; case 1: for (int j = 0; j < Site_ID.Count; j++) { StringBuilder query = new StringBuilder(""); if (Site_User_ID[j] == 0) // New site user { query.Append("INSERT "); query.Append(tblSiteUsers); query.Append(" "); query.Append(tblSiteUserFields); query.Append(" "); query.Append(tblSiteUserInsert); SaveCmd = query.ToString(); using (SqlCommand SqlCmd = new SqlCommand(SaveCmd)) { SqlCmd.Connection = sqlCon; SqlCmd.Parameters.AddWithValue("@site_id", (long)Site_ID[j]); SqlCmd.Parameters.AddWithValue("@user_id", (int)User_ID[j]); SqlCmd.Parameters.AddWithValue("@view_all_resources", (bool)View_Resources[j]); SqlCmd.Parameters.AddWithValue("@add_resources", (bool)Add_Resources[j]); SqlCmd.Parameters.AddWithValue("@modify_resources", (bool)Modify_Resources[j]); SqlCmd.Parameters.AddWithValue("@delete_resources", (bool)Del_Resources[j]); SqlCmd.Parameters.AddWithValue("@view_all_tickets", (bool)View_Tickets[j]); SqlCmd.Parameters.AddWithValue("@add_tickets", (bool)Add_Tickets[j]); try { if (sqlCon.State != ConnectionState.Open) { sqlCon.Open(); } SqlResult = SqlCmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "Failed To Save Site Users", MessageBoxButton.OK, MessageBoxImage.Error); return_code = false; } } } else // Update existing site user { if (Mark_Delete[j] == true) { query.Append("DELETE FROM "); query.Append(tblSiteUsers); query.Append(" WHERE Site_ID = '"); query.Append(Site_ID[j].ToString()); query.Append("' and User_ID = '"); query.Append(User_ID[j].ToString()); query.Append("'"); } else { query.Append("UPDATE "); query.Append(tblSiteUsers); query.Append(" "); query.Append(tblSiteUserUpdate); query.Append(Site_User_ID[j].ToString()); } SaveCmd = query.ToString(); using (SqlCommand SqlCmd = new SqlCommand(SaveCmd)) { SqlCmd.Connection = sqlCon; if (Mark_Delete[j] == false) { SqlCmd.Parameters.AddWithValue("@site_id", (long)Site_ID[j]); SqlCmd.Parameters.AddWithValue("@user_id", (int)User_ID[j]); SqlCmd.Parameters.AddWithValue("@view_all_resources", (bool)View_Resources[j]); SqlCmd.Parameters.AddWithValue("@add_resources", (bool)Add_Resources[j]); SqlCmd.Parameters.AddWithValue("@modify_resources", (bool)Modify_Resources[j]); SqlCmd.Parameters.AddWithValue("@delete_resources", (bool)Del_Resources[j]); SqlCmd.Parameters.AddWithValue("@view_all_tickets", (bool)View_Tickets[j]); SqlCmd.Parameters.AddWithValue("@add_tickets", (bool)Add_Tickets[j]); } try { if (sqlCon.State != ConnectionState.Open) { sqlCon.Open(); } SqlResult = SqlCmd.ExecuteNonQuery(); if (SqlResult == 0) { return_code = false; } } catch (SqlException e) { MessageBox.Show(e.Message, "Failed To Save Site Users", MessageBoxButton.OK, MessageBoxImage.Error); return_code = false; } } } } sqlCon.Close(); break; } } return(return_code); }
// // 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; } }
private void textBox1_MouseClick(object sender, MouseEventArgs e) { User_ID.Clear(); User_ID.ForeColor = Color.FromArgb(48, 184, 206); }