private void btnDeleteMember_Click(object sender, EventArgs e)
{
ListView lst = lstMember;
int index = GenFunction.GetLvIndex(lst);
if (lst.SelectedItems.Count == 0)
{
return;
}
//#if DEBUG == false
var result = MessageBox.Show("Verenigingslid verwijderen?\nDit kan niet ongedaan gemaakt worden!", "Vereniging - Leden",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.No)
{
return;
}
//#endif
ListViewItem item = lst.SelectedItems[0];
LedenModel ledenModel = new LedenModel();
ledenModel.Id = Int32.Parse(item.Tag.ToString());
ledenModel.Name = item.Text;
SqliteDataAccess.DeleteMember(ledenModel);
lst.Items[GenFunction.GetLvIndex(lst)].Remove();
GenFunction.GetLvPervIndexAfterDelete(lst, index);
}
public static void DeleteMember(LedenModel lm)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute($"DELETE FROM leden WHERE Id = @Id", lm);
}
}
private void LstMember_AfterLabelEdit(object sender, LabelEditEventArgs e)
{
ListView lst = sender as ListView;
int index = GenFunction.GetLvIndex(lst);
Console.WriteLine(index);
if (lst.SelectedItems.Count == 0)
{
return;
}
if (e.Label == null)
{
return;
}
ListViewItem item = lst.SelectedItems[0];
LedenModel ledenModel = new LedenModel
{
Id = Int32.Parse(item.Tag.ToString()),
Name = e.Label.ToString()
};
SqliteDataAccess.UpdateLeden(ledenModel);
SetLedenList();
GenFunction.SelectLvCurrentItem(lst, index);
}
public static void UpdateLeden(LedenModel lm)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute($"UPDATE leden SET Name = @Name WHERE Id = @Id", lm);
}
}
public static void SaveLeden(LedenModel lm)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute($"INSERT INTO leden (Name, Ver_id) VALUES (@Name, @IdClub)", lm);
}
}
public static List <LedenModel> GetLeden(LedenModel lm)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
var output = cnn.Query <LedenModel>("SELECT * FROM leden WHERE Ver_Id = @IdClub", lm); // new DynamicParameters());
return(output.ToList());
}
}
private void CreateNewMember()
{
LedenModel lm = new LedenModel
{
IdClub = clubId,
Name = "Naam"
};
SqliteDataAccess.SaveLeden(lm);
SetLedenList();
GenFunction.SetLvEditAfterNew(lstMember);
}
private Boolean GenJsonFile(int clubId, string clubName, string path)
{
DataSet dataSet = new DataSet("dataSet");
dataSet.Namespace = "NetFrameWork";
DataTable table = new DataTable();
table.TableName = "LedenLijst"; // clubName;
DataColumn itemColumn = new DataColumn("name");
table.Columns.Add(itemColumn);
dataSet.Tables.Add(table);
LedenModel lm = new LedenModel();
lm.IdClub = clubId;
leden = SqliteDataAccess.GetLeden(lm);
foreach (var ledenList in leden)
{
DataRow newRow = table.NewRow();
newRow["name"] = ledenList.Name;
table.Rows.Add(newRow);
}
dataSet.AcceptChanges();
string json = JsonConvert.SerializeObject(dataSet, Formatting.Indented);
try
{
using (var tw = new StreamWriter($@"{path}\{clubName}.json", false))
{
tw.WriteLine(json);
tw.Close();
}
return(false);
}
catch (UnauthorizedAccessException e)
{
MessageBox.Show(e.Message, "Vereniging - Leden",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return(true);
}
finally
{
}
//Console.WriteLine(json);
}
private void SetLedenList()
{
lstMember.Items.Clear();
LedenModel lm = new LedenModel();
lm.IdClub = clubId;
leden = SqliteDataAccess.GetLeden(lm);
foreach (var ledenList in leden)
{
var row = new String[] { ledenList.Name };
var lvi = new ListViewItem(row)
{
Tag = ledenList.Id //clubList.Id;
};
lstMember.Items.Add(lvi);
}
}
