/// <summary>
/// gets user name from model id
/// </summary>
/// <param name="model_id"></param>
/// <returns></returns>
private string GetUserName(int model_id)
{
int userId = ws.GetCreatorUserId(model_id);
SqlConnection sqlConnection = new SqlConnection(resources.ResourceManager.GetString("Connection_String"));
if (sqlConnection.State != System.Data.ConnectionState.Open)
{
sqlConnection.Open();
}
string query = "SELECT username FROM [Users] Where Id = @user_id;";
SqlCommand sqlCmd = new SqlCommand(query, sqlConnection);
sqlCmd.Parameters.AddWithValue("@user_id", userId);
SqlDataReader reader = sqlCmd.ExecuteReader();
string username = "";
if (reader.Read())
{
username = reader.GetString(0);
}
return(username);
}