private void buttonInsertBand_Click(object sender, EventArgs e)
{
if (textBoxBandName.Text == "" || textBoxDescription.Text == "")
{
MessageBox.Show("Wrong input!");
return;
}
IBandsRepository bandsRep = new BandsRepository();
BandModel toPost = new BandModel();
toPost.BandName = textBoxBandName.Text;
toPost.DiscriptionOfType = textBoxDescription.Text;
bool flag = bandsRep.AddBand(toPost);
if (flag)
{
MessageBox.Show("Posted!");
}
else
{
MessageBox.Show("Error!");
}
textBoxBandName.Text = "";
textBoxDescription.Text = "";
}
private void buttonDeleteBand_Click(object sender, EventArgs e)
{
if (textBoxNameDelete.Text == "")
{
MessageBox.Show("Wrong input!");
return;
}
IBandsRepository bandsRep = new BandsRepository();
string toPost;
toPost = textBoxNameDelete.Text;
bool flag = bandsRep.DeleteBand(toPost);
if (flag)
{
MessageBox.Show("Deleted!");
}
else
{
MessageBox.Show("Error!");
}
textBoxNameDelete.Text = "";
}
private void buttonSeeBands_Click(object sender, EventArgs e)
{
IBandsRepository bandsRep = new BandsRepository();
List <BandModel> bands = bandsRep.GetAllBands().ToList();
listBands.Items.Clear();
foreach (BandModel band in bands)
{
string toList = "Id:" + band.BandId + ", Name:" + band.BandName
+ ", Description:" + band.DiscriptionOfType;
listBands.Items.Add(toList);
}
}
private void buttonExcel_Click(object sender, EventArgs e)
{
var workbook = new XLWorkbook();
IXLWorksheet worksheet = workbook.Worksheets.Add("Bands");
IBandsRepository bandRep = new BandsRepository();
List <BandModel> bands = bandRep.GetAllBands().ToList();
worksheet.Cell(1, 1).Value = "Band Id";
worksheet.Cell(1, 2).Value = "Type Id";
worksheet.Cell(1, 3).Value = "Band name";
worksheet.Cell(1, 4).Value = "DescriptionOfType";
int i = 2;
foreach (BandModel band in bands)
{
worksheet.Cell(i, 1).Value = band.BandId.ToString();
worksheet.Cell(i, 2).Value = band.TypeId.ToString();
worksheet.Cell(i, 3).Value = band.BandName;
worksheet.Cell(i, 4).Value = band.DiscriptionOfType;
i++;
}
using (FileStream fs = new FileStream("bands.xlsx", FileMode.OpenOrCreate))
{
workbook.SaveAs(fs);
}
//Excel.Application excelApp = new Excel.Application();
//IBandsRepository bandRep = new BandsRepository();
//List<BandModel> bands = bandRep.GetAllBands().ToList();
//excelApp.Workbooks.Add();
//Excel.Worksheet workSht = (Excel.Worksheet)excelApp.ActiveSheet;
//int i = 0;
//foreach (BandModel band in bands)
//{
// workSht.Cells[i, 0] = band.BandId.ToString();
// workSht.Cells[i, 1] = band.TypeId.ToString();
// workSht.Cells[i, 2] = band.BandName;
// workSht.Cells[i, 3] = band.DiscriptionOfType;
//}
//excelApp.Visible = true;
}
private void buttonUpdateBand_Click(object sender, EventArgs e)
{
if (textBoxBandName.Text == "" || textBoxNewBandName.Text == "")
{
MessageBox.Show("Wrong input!");
return;
}
IBandsRepository bandsRep = new BandsRepository();
bool flag = bandsRep.UpdateBandName(textBoxBandName.Text, textBoxNewBandName.Text);
if (flag)
{
MessageBox.Show("Updated!");
}
else
{
MessageBox.Show("Error!");
}
textBoxBandName.Text = "";
textBoxNewBandName.Text = "";
}
// Entries constructor w/declared entries list for Home page
public EntriesController()
{
_entriesRepository = new EntriesRepository();
_bandsRepository = new BandsRepository();
}
// Entries constructor w/declared entries list for Home page
public HomeController()
{
_bandsRepository = new BandsRepository();
}