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