private void btnAddNewMaterial_Click(object sender, EventArgs e)
{
DM_Material newMaterial = new DM_Material();
newMaterial.Id_rodzaj_materialu = Convert.ToInt32(cmbRodzajMaterialu.SelectedValue);
newMaterial.Nazwa = this.txtNewMaterial.Text;
this.database.DM_Material.Add(newMaterial);
this.database.SaveChanges();
this.txtNewMaterial.Text = "";
var MaterialForm = Application.OpenForms.OfType <Material>().Single();
MaterialForm.initDataGridView();
this.Close();
}
private void btnDeleteMaterial_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Czy chcesz usunąć materiał?", "Usuwanie materiał", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
int id = Convert.ToInt32(this.dgvMaterial.CurrentRow.Cells[0].Value);
DM_Material toRemove = this.database.DM_Material.Where(id_materialu => id_materialu.Id_materialu == id).First();
this.database.DM_Material.Remove(toRemove); // DELETE
this.database.SaveChanges();
initDataGridView();
}
else
{
DialogResult dialog1Result = MessageBox.Show("Nie udało się usunąć materiału?");
}
}
private void btnSaveChanges_Click(object sender, EventArgs e)
{
Material frm = (Material)Application.OpenForms["Material"];
// int row = (frm.dgvMaterial.CurrentRow.Index)+1;
// DM_Material toUpdate = this.database.DM_Material.Where(id_materialu => id_materialu.Id_materialu == row).First();
int row = Convert.ToInt32(frm.dgvMaterial.CurrentRow.Cells[0].Value);;
DM_Material toUpdate = this.database.DM_Material.Where(narzedzie => narzedzie.Id_materialu == row).First();
toUpdate.Id_rodzaj_materialu = Convert.ToInt32(cmbEdytujRodzajMaterialu.SelectedValue); // UPDATE
toUpdate.Nazwa = txtEdytujMaterial.Text; // UPDATE
this.database.SaveChanges();
frm.dgvMaterial.DataSource = this.database.vDM_Material.ToList();
// var MaterialForm = Application.OpenForms.OfType<Material>().Single();
// MaterialForm.initDataGridView();
this.Close();
}
