void m_DeleteCalcMemberButton_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show(Localization.DeleteCurrent_Question, Localization.Warning, MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
CalcMemberInfo memberInfo = MembersList.CurrentObject as CalcMemberInfo;
if (memberInfo != null)
{
Members.Remove(memberInfo.Name);
MembersList.RemoveItem(memberInfo);
}
else
{
CalculatedNamedSetInfo setInfo = MembersList.CurrentObject as CalculatedNamedSetInfo;
if (setInfo != null)
{
Sets.Remove(setInfo.Name);
MembersList.RemoveItem(setInfo);
}
}
m_ClearButton.IsEnabled = (Members.Count + Sets.Count) > 0;
RefreshMetadataTree();
}
return;
}
// Load members from the database
// TODO: Add listview filler to GlobalVariables
private void LoadMembers()
{
string sqlCommandText = "Select * from [Member]";
DataSet ds = Database.SqlQueryDataSet(sqlCommandText);
MembersList.Clear();
if (ds.Tables.Count > 0)
{
for (int index = 0; index < ds.Tables[0].Rows.Count; ++index)
{
DataRow row = ds.Tables[0].Rows[index];
if (row.RowState != DataRowState.Deleted)
{
MembersList.Add(new MemberModel()
{
Firstname = (string)row["firstname"],
Lastname = (string)row["lastname"],
Partner = (bool)row["partner"],
MemberSince = (DateTime)row["memberSince"]
});
}
}
}
}
public void EndEdit()
{
if (MemberCtrl.IsEnabled && MemberCtrl.Visibility == Visibility.Visible)
{
if (MemberCtrl.Member != null && MemberCtrl.Member.Name != MemberCtrl.NameText)
{
Members.Remove(MemberCtrl.Member.Name);
String newName = BuildNewCalculatedMemberName(MemberCtrl.NameText);
MemberCtrl.Member.Name = newName;
Members.Add(MemberCtrl.Member.Name, MemberCtrl.Member);
MemberCtrl.Initialize(MemberCtrl.Member);
MembersList.Refresh();
}
}
if (SetCtrl.IsEnabled && SetCtrl.Visibility == Visibility.Visible)
{
if (SetCtrl.Set != null && SetCtrl.Set.Name != SetCtrl.NameText)
{
Sets.Remove(SetCtrl.Set.Name);
String newName = BuildNewCalculatedNamedSetName(SetCtrl.NameText);
SetCtrl.Set.Name = newName;
Sets.Add(SetCtrl.Set.Name, SetCtrl.Set);
SetCtrl.Initialize(SetCtrl.Set);
MembersList.Refresh();
}
}
RefreshMetadataTree();
}
private void CharacterReceived(Website.CharInfo Character)
{
if (Character.Name == string.Empty)
{
MessageBox.Show("Character doesn't exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Cursor = Cursors.Default; //Reset cursor to deafult
return;
}
foreach (Website.CharInfo MemberChar in Members)
{
if (MemberChar.Name == Character.Name)
{
MessageBox.Show("Character is already at the list", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Cursor = Cursors.Default; //Reset cursor to deafult
return;
}
}
Members.Add(Character);
MembersList.Invoke(new EventHandler(delegate
{
//Update the ListView
MembersList.Items.Add(new ListViewItem(new string[] {
Character.Name,
Character.GuildName,
Character.GuildNickName
}));
}));
this.Invoke(new EventHandler(delegate
{
this.Cursor = Cursors.Default; //Reset cursor to deafult
}));
}
private void DeleteUserFromTeam(UserListModelInner user)
{
if (Model.Leader == IDHolder.IDUser)
{
MembersList.Remove(user);
}
}
public static MembersList LoadMembers()
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MembersList target = new MembersList();
var memb =
from p in db.Players
orderby p.Name
select p;
_count = 0;
foreach (var item in memb)
{
MrMember newMember = new MrMember()
{
pID = item.PlayerID,
name = item.Name,
fname = item.FName,
lname = item.LName,
gender = item.Sex,
hcp = item.Hcp,
memberNumber = item.MemberID,
title = item.Title,
hdate = item.HDate,
del = item.Delete
};
newMember.active = SignupList.CountPlayersActiveSignupEntries(item.PlayerID);
target.Members.Add(newMember);
_count++;
}
Count = _count;
return(target);
}
protected int ShowMembers()
{
this.ml = MembersList.LoadMembers();
this.MainMemberRepeater.DataSource = new MembersList[] { this.ml };
this.MainMemberRepeater.DataBind();
return(MembersList.Count);
}
public void OnNavigatedTo(INavigationParameters parameters)
{
celula = (Celula)parameters["celula"];
if (celula != null)
{
PageTitle = "Editar";
Name = celula.Name;
StartTime = celula.CelulaStartTime;
Country = celula.Country;
State = celula.State;
City = celula.City;
Address = celula.Address;
SelectLiderButtonText = celula.LeaderName;
SelectAnfitriaoButtonText = celula.AnfitriaoName;
foreach (Person member in celula.Members)
{
MembersList.Add(member);
}
}
else
{
PageTitle = "Nova Célula";
SelectLiderButtonText = "Selectione o líder";
SelectAnfitriaoButtonText = "Selectione o anfitrião";
}
}
void AddToTable()
{
//Find Json in project
path = Application.streamingAssetsPath + "/JsonChallenge.json";
jsonString = File.ReadAllText(path);
//Check if Json is null
if (jsonString != null)
{
MemberList = JsonUtility.FromJson <MembersList>(jsonString);
Table table = JsonUtility.FromJson <Table>(jsonString);
//Set Title and Headers
Title.text = table.Title;
header[0].text = table.ColumnHeaders[0];
header[1].text = table.ColumnHeaders[1];
header[2].text = table.ColumnHeaders[2];
header[3].text = table.ColumnHeaders[3];
//Instantiate members into table.
foreach (Members members in MemberList.Members)
{
go = Instantiate(prefab, new Vector3(0, 0, 90f), Quaternion.identity) as GameObject;
go.transform.parent = GameObject.Find("Content").transform;
prefabs.Add(go);
go.transform.localScale = new Vector3(1f, 1f, 1f);
go.transform.GetChild(0).GetComponent <Text>().text = members.ID;
go.transform.GetChild(1).GetComponent <Text>().text = members.Name;
go.transform.GetChild(2).GetComponent <Text>().text = members.Role;
go.transform.GetChild(3).GetComponent <Text>().text = members.Nickname;
}
}
else
{
print("Json is null, add Json first into StreamingAssets");
}
}
private void TeamSelected(TeamDetailSelectedMessage teamDetailSelectedMessage)
{
Model = apiClient.GetTeamById(teamDetailSelectedMessage.Id);
this.MembersList = new BindingList <UserListModelInner>();
foreach (var member in Model.Members)
{
MembersList.Add(member);
}
}
private void Start()
{
SetPageID(0);
stats = GameObject.Find("Scripts").GetComponent <statystyki>();
ScoutProposition = GetComponent <ScoutProposition>();
MembersList = GetComponent <MembersList>();
GUIoper = GameObject.Find("Interface").GetComponent <GUIOperations>();
GUIPlanetOperations = GameObject.Find("Interface").GetComponent <GUIPlanetOperations>();
Work();
}
void m_AddNamedSetButton_Click(object sender, RoutedEventArgs e)
{
CalculatedNamedSetInfo info = new CalculatedNamedSetInfo();
info.Name = BuildNewCalculatedNamedSetName(String.Empty);
Sets.Add(info.Name, info);
MembersList.Initialize(Members, Sets, info);
RefreshMetadataTree();
m_ClearButton.IsEnabled = (Members.Count + Sets.Count) > 0;
}
void m_ClearButton_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show(Localization.DeleteAll_Question, Localization.Warning, MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
Members.Clear();
Sets.Clear();
m_ClearButton.IsEnabled = (Members.Count + Sets.Count) > 0;
MembersList.Initialize(Members, Sets);
RefreshMetadataTree();
}
}
private void AddUserToTeam(UserAddToTeamMessage user)
{
var mapper = new UserMapper();
var userModel = apiClient.GetUserById(user.Id);
MembersList.Add(new UserListModelInner
{
Id = userModel.Id,
Name = userModel.Name
});
}
public static MembersList GetMembers()
{
MembersList membersList;
using (MySqlConnection conn = new MySqlConnection(connString))
{
string query = @"SELECT id_member, name_member, lastName_member, phone_member, type_member, profile_member, email_member, passwor_member
FROM members;";
using (MySqlCommand cmd = new MySqlCommand())
{
membersList = new MembersList();
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
cmd.Connection = conn;
conn.Open();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
string name;
string lName;
string email;
string profile;
string password;
string phone;
string type;
int id;
while (reader.Read())
{
name = reader["name_member"] as string;
lName = reader["lastName_member"] as string;
email = reader["email_member"] as string;
profile = reader["profile_member"] as string;
password = reader["passwor_member"] as string;
type = reader["type_member"] as string;
id = (int)reader["id_member"];
phone = reader.IsDBNull(3) ? null : reader["phone_member"] as string;
membersList.Add(new Member()
{
Name = name,
LastName = lName,
Email = email,
Profile = profile,
Password = password,
Phone = phone,
Type = type,
ID = id,
});
}
}
}
}
return(membersList);
}
protected void Member_ItemCommand(Object Sender, RepeaterCommandEventArgs e)
{
Label2.Text = "The " + ((Button)e.CommandSource).Text + " button has just been clicked; <br />";
int playerID = Convert.ToInt32(((Button)e.CommandSource).Text.Trim());
int deleteCode = MembersList.DeleteMember(clubSettings.ClubID, playerID);
if (deleteCode == 0)
{
Label3.Text = MembersList.MembersName + " has been deleted.";
}
else
{
Label3.Text = MembersList.MembersName + " has ACTIVE Signups and will stay in the members database.";
}
ShowMembers();
}
void m_AddCalcMemberButton_Click(object sender, RoutedEventArgs e)
{
CalcMemberInfo info = new CalcMemberInfo();
// Если по выбранному узлу можем определить иерархию, то уникальное имя иерархии добавляем в имя вычисляемого элемента
// В этом случае элемент попадет в данную иерархию
// В противном случае - в иерархию [Measures] даже если она явно не прописана в имени
String name_prefix = String.Empty;
var hierarchy = CubeBrowser.SelectedNode as HierarchyTreeNode;
if (hierarchy != null)
{
if (hierarchy.Info != null && hierarchy.Info is HierarchyInfo)
{
name_prefix = ((HierarchyInfo)hierarchy.Info).UniqueName;
}
}
var level = CubeBrowser.SelectedNode as LevelTreeNode;
if (level != null)
{
if (level.Info != null && level.Info is LevelInfo)
{
name_prefix = ((LevelInfo)level.Info).ParentHirerachyId;
}
}
var member = CubeBrowser.SelectedNode as MemberLiteTreeNode;
if (member != null)
{
if (member.Info != null)
{
name_prefix = member.Info.HierarchyUniqueName;
}
}
String defaultName = String.IsNullOrEmpty(name_prefix) ? "[Calculated Member]" : name_prefix + "." + "[Calculated Member]";
info.Name = BuildNewCalculatedMemberName(defaultName);
Members.Add(info.Name, info);
MembersList.Initialize(Members, Sets, info);
RefreshMetadataTree();
m_ClearButton.IsEnabled = (Members.Count + Sets.Count) > 0;
}
public void Proceed()
{
var guildMembersFromDatabase = GetMembersFromDb();
var transformatedMembers = MembersList
.StringMembersListToListObject(guildMembersFromDatabase);
foreach (var character in transformatedMembers)
{
bool isRequestOk = RequestManager
.SendGETRequest($"{TibiaAPICharacterUrl}{character.Name}.json",
out var responseString) == HttpStatusCode.OK &&
!String.IsNullOrEmpty(responseString);
if (isRequestOk)
{
ProcessResponse(responseString, character.Name, character.Guild);
}
}
}
public void Initialize(Dictionary <String, CalculationInfoBase> members, Dictionary <String, CalculationInfoBase> sets, CubeDefInfo cubeInfo, String measureGroupName)
{
m_Members = members;
m_Sets = sets;
m_ClearButton.IsEnabled = (Members.Count + Sets.Count) > 0;
MemberCtrl.InitializeMetadata(cubeInfo);
if (CubeBrowser.CubeInfo != cubeInfo)
{
CubeBrowser.Initialize(cubeInfo);
}
CubeBrowser.MeasureGroupName = measureGroupName;
MemberCtrl.IsEnabled = SetCtrl.IsEnabled = false;
foreach (CalculationInfoBase info in Members.Values)
{
CalcMemberInfo member = info as CalcMemberInfo;
if (member != null)
{
// Добавляем в список стандартных пользовательские строки форматирования
if (!String.IsNullOrEmpty(member.FormatString))
{
if (!FormatStrings.Contains(member.FormatString))
{
FormatStrings.Add(member.FormatString);
}
}
}
}
MemberCtrl.FormatStrings = FormatStrings;
MembersList.Initialize(members, sets);
RefreshMetadataTree();
//CalcMemberInfo memberInfo = MembersList.CurrentObject as CalcMemberInfo;
//if (memberInfo != null)
//{
// MemberCtrl.Initialize(memberInfo);
//}
}
private void GuildMembersReceived(List <Website.CharInfo> GuildMembers)
{
if (GuildMembers.Count == 0)
{
MessageBox.Show("Guild doesn't exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Cursor = Cursors.Default; //Reset cursor to deafult
return;
}
bool AlreadyInList = false;
foreach (Website.CharInfo Character in GuildMembers)
{
foreach (Website.CharInfo MemberChar in Members)
{
if (MemberChar.Name == Character.Name)
{
MessageBox.Show("Character " + Character.Name + " is already at the list.", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
AlreadyInList = true;
break;
}
}
if (!AlreadyInList)
{
Members.Add(Character);
MembersList.Invoke(new EventHandler(delegate
{
//Update the ListView
MembersList.Items.Add(new ListViewItem(new string[] {
Character.Name,
Character.GuildName,
Character.GuildNickName
}));
}));
}
AlreadyInList = false;
}
this.Invoke(new EventHandler(delegate
{
this.Cursor = Cursors.Default; //Reset cursor to deafult
}));
}
//Members List
public IActionResult ProjectMembers(int id)
{
var project = _context.Projects.SingleOrDefault(x => x.ProjectId == id);
var project_members = _context.ProjectAssignment.Where(x => x.ProjectId == id).ToList();
var project_members_viewmodel_list = new List <MembersList>();
if (project_members != null && project != null)
{
foreach (var a in project_members)
{
var project_members_viewmodel = new MembersList();
project_members_viewmodel.MemberEmail = _context.ApplicationUsers.SingleOrDefault(x => x.Id == a.EmployeeId).Email;
project_members_viewmodel.ProjectAssignmentId = a.ProjectAssignmentId;
project_members_viewmodel_list.Add(project_members_viewmodel);
}
}
return(View(project_members_viewmodel_list));
}
private async void DoRemoveUser()
{
if (SelectedMember == null)
{
MessageBox.Show("Please select a row first");
return;
}
var confirmMessage = $"Are you sure you want to remove {SelectedMember.FullName()} from committee?";
if (!ImHereMessageBox.ShowYesNo("Remove Member", confirmMessage))
{
return;
}
var success = true;
var errorMsg = "";
try
{
MembersList.Remove(SelectedMember);
CurrentCommittee.Members = MembersList;
AppModel.Entry(CurrentCommittee).State = EntityState.Modified;
await AppModel.SaveChangesAsync();
}
catch (Exception e)
{
success = false;
errorMsg = e.Message;
}
if (success)
{
return;
}
ImHereMessageBox.ShowError("Error deleting row!", errorMsg);
}
public async System.Threading.Tasks.Task Init()
{
if (FunctionalFieldsList.Count == 0)
{
var functionalFieldsList = await _functionalFieldService.Get <List <FunctionalField> >(null);
FunctionalFieldsList.Add(new FunctionalField
{
Id = 0,
Name = ""
});
foreach (var funcField in functionalFieldsList)
{
FunctionalFieldsList.Add(funcField);
}
}
if (LocalCommitteesList.Count == 0)
{
var localCommittees = await _localCommitteeService.Get <List <LocalCommittee> >(null);
LocalCommitteesList.Add(new LocalCommittee
{
Id = 0,
Name = ""
});
foreach (var localCommittee in localCommittees)
{
LocalCommitteesList.Add(localCommittee);
}
}
Model.Search.Member searchMember = new Model.Search.Member();
if (SelectedFunctionalField != null)
{
searchMember.FunctionalFieldId = SelectedFunctionalField.Id;
var list = await _membersService.Get <IEnumerable <Model.Response.MemberLL> >(searchMember);
MembersList.Clear();
foreach (var member in list)
{
MembersList.Add(member);
}
}
if (SelectedLocalCommittee != null)
{
searchMember.LocalCommitteeId = SelectedLocalCommittee.Id;
var list = await _membersService.Get <IEnumerable <Model.Response.MemberLL> >(searchMember);
MembersList.Clear();
foreach (var member in list)
{
MembersList.Add(member);
}
}
if (SelectedFunctionalField == null && SelectedLocalCommittee == null)
{
var list = await _membersService.Get <IEnumerable <Model.Response.MemberLL> >(null);
MembersList.Clear();
foreach (var member in list)
{
MembersList.Add(member);
}
}
}
void MemberCtrl_EditEnd(object sender, EventArgs e)
{
EndEdit();
MembersList.Refresh();
}
public void ShowMembers()
{
this.ml = MembersList.LoadMembers(clubSettings.ClubID);
this.MembersListMainRepeater.DataSource = new MembersList[] { this.ml };
this.MembersListMainRepeater.DataBind();
}
public void InstantiateData()
{
GameObject[] exist = GameObject.FindGameObjectsWithTag("Data");
GameObject[] existt = GameObject.FindGameObjectsWithTag("Header");
if (exist != null)
{
foreach (GameObject e in exist)
{
Destroy(e.gameObject);
}
}
if (existt != null)
{
foreach (GameObject h in existt)
{
Destroy(h.gameObject);
}
}
string Path = Application.streamingAssetsPath + "/" + NameJson + ".json";
string JsonString = File.ReadAllText(Path);
MembersList memberslist = JsonUtility.FromJson <MembersList>(JsonString);
//Load Title
Title.text = memberslist.Title;
//Load Column Headers
Headers = new Text[memberslist.ColumnHeaders.Length];
for (int h = 0; h < memberslist.ColumnHeaders.Length; h++)
{
//Instantiate headers
GameObject headersInstantiated = Instantiate(headers, columnHeadersPosition.transform.position, transform.rotation);
headersInstantiated.transform.parent = columnHeadersPosition.transform;
headersInstantiated.transform.position = columnHeadersPosition.transform.position;
headersInstantiated.transform.localScale = new Vector3(1, 1, 1);
//Show headers
Headers[h] = headersInstantiated.GetComponent <Text>();
Headers[h].text = memberslist.ColumnHeaders[h];
}
//Load data
Data = new Text[memberslist.Data.Length];
for (int i = 0; i < memberslist.Data.Length; i++)
{
//Instantiate data object
GameObject dataInstantiated = Instantiate(data, ContentPosition.transform.position, transform.rotation);
dataInstantiated.transform.parent = ContentPosition.transform;
dataInstantiated.transform.position = ContentPosition.transform.position;
dataInstantiated.transform.localScale = new Vector3(1, 1, 1);
dataposition = dataInstantiated.GetComponent <Transform>();
//Reference to Text components
for (int x = 0; x < memberslist.Data.Length; x++)
{
if (dataInstantiated.transform.childCount < memberslist.Data.Length)
{
GameObject objinstantiated = Instantiate(instantiateData, dataposition.transform.position, transform.rotation);
objinstantiated.name = "data";
objinstantiated.transform.parent = dataposition.transform;
objinstantiated.transform.position = dataposition.transform.position;
objinstantiated.transform.localScale = new Vector3(1, 1, 1);
Data[x] = dataInstantiated.transform.GetChild(x).GetComponent <Text>();
}
else
{
Data[x] = dataInstantiated.transform.GetChild(x).GetComponent <Text>();
}
}
//Assignment array's index
for (int e = 0; e < memberslist.Data.Length; e++)
{
int d = 0;
Data[d].text = memberslist.Data[i].ID;
d++;
Data[d].text = memberslist.Data[i].Name;
d++;
Data[d].text = memberslist.Data[i].Role;
d++;
Data[d].text = memberslist.Data[i].Nickname;
}
}
}
