private void btnDelete_Click(object sender, EventArgs e) { if (MetroFramework.MetroMessageBox.Show(this, "Are you sure want to delete this record?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { objState = EntityState.Deleted; try { Muzicar obj = bendInfoBindingSource.Current as Muzicar; if (obj != null) { using (var db = Db.FromConfig("cn")) { db.Sql("delete from BendInfo where MuzicarID = @MuzicarID").WithParameters(new { MuzicarID = obj.MuzicarID }).AsNonQuery(); bendInfoBindingSource.RemoveCurrent(); pContainer.Enabled = false; ClearInput(); objState = EntityState.Unchanged; } } } catch (Exception ex) { MetroFramework.MetroMessageBox.Show(this, ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSave_Click(object sender, EventArgs e) { try { bendInfoBindingSource.EndEdit(); //Get current object Muzicar obj = bendInfoBindingSource.Current as Muzicar; if (obj != null) { using (var db = Db.FromConfig("cn")) { if (objState == EntityState.Added) { //Execute sql insert query obj.MuzicarID = db.Sql("insert into BendInfo(Ime, Prezime, Kontakt, Jmbg, SlikaUrl,Adresa, InstrumentID) values(@Ime, @Prezime, @Kontakt,@InstrumentID, @Jmbg, @SlikaUrl, @InstrumentID);select SCOPE_IDENTITY()").WithParameters(new { Ime = obj.Ime, Prezime = obj.Prezime, Jmbg = obj.Jmbg, SlikaUrl = obj.SlikaUrl, Kontakt = obj.Kontakt, InstrumentID = obj.InstrumentID }).AsScalar <int>(); } else if (objState == EntityState.Changed) { //Execute stored procedure update db.StoredProcedure("MuzicariUpdate").WithParameters(new { MuzicarID = obj.MuzicarID, Ime = obj.Ime, InstrumentID = obj.InstrumentID, Prezime = obj.Prezime, Jmbg = obj.Jmbg, SlikaUrl = obj.SlikaUrl, Kontakt = obj.Kontakt, Adresa = obj.Adresa }).AsNonQuery(); } metroGrid.Refresh(); pContainer.Enabled = false; objState = EntityState.Unchanged; } } } catch (Exception ex) { MetroFramework.MetroMessageBox.Show(this, ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void metroGrid_CellClick(object sender, DataGridViewCellEventArgs e) { Muzicar obj = bendInfoBindingSource.Current as Muzicar;//Get current object if (obj != null) { if (!string.IsNullOrEmpty(obj.SlikaUrl)) { pic.Image = Image.FromFile(obj.SlikaUrl);//Load image to PictureBox } } }
private void btnBrowse_Click(object sender, EventArgs e) { using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "JPEG|*.jpg|PNG|*.png", ValidateNames = true }) { if (ofd.ShowDialog() == DialogResult.OK) { pic.Image = Image.FromFile(ofd.FileName); //Get current object Muzicar obj = bendInfoBindingSource.Current as Muzicar; if (obj != null) { obj.SlikaUrl = ofd.FileName; } } } }
private void MusicTheatre_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'mabDataSet.Instrument' table. You can move, or remove it, as needed. this.instrumentTableAdapter.Fill(this.mabDataSet.Instrument); // TODO: This line of code loads data into the 'mabDataSet.BendInfo' table. You can move, or remove it, as needed. this.bendInfoTableAdapter.Fill(this.mabDataSet.BendInfo); //Connect to sql database using (var db = Db.FromConfig("cn")) { bendInfoBindingSource.DataSource = db.Sql("select *from BendInfo").AsEnumerable <Muzicar>(); } pContainer.Enabled = false; Muzicar obj = bendInfoBindingSource.Current as Muzicar; if (obj != null) { if (!string.IsNullOrEmpty(obj.SlikaUrl)) { pic.Image = Image.FromFile(obj.SlikaUrl);//Load image to PictureBox } } }