private void btnDel_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("Na pewno chcesz usunąć wybrany dokument ?", "Uwaga", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { var dok_id = GetDoIdByRow(gridViewDoki.FocusedRowHandle); if (dok_id == null) { MessageBox.Show("Brak wybranego dokumentu do usunięcia"); return; } dok_edit = doki_model.Where(x => x.do_id == dok_id).FirstOrDefault(); doki_model = DAO.p_int_dokument_usun(dok_edit.do_id); artykuly_model = DAO.p_int_artykul_pobierz(null); gridControlDoki.DataSource = doki_model; gridControlArtykuly.DataSource = artykuly_model; } catch (Exception ex) { log.Error(ex.Message); log.Error(ex.InnerException.Message); } } }
public static List <p_int_dokument_pobierz> p_int_dokument_dodaj(p_int_dokument_pobierz new_dok) { log.Info("p_int_dokument_dodaj"); var m = new List <p_int_dokument_pobierz>(); using (var db = new col_dataEntities()) { var p = new SqlParameter[5]; p[0] = new SqlParameter("@p_do_nazwa", SqlDbType.NVarChar); p[0].Value = new_dok.do_nazwa; p[1] = new SqlParameter("@p_do_data", SqlDbType.DateTime); p[1].Value = new_dok.do_data; p[2] = new SqlParameter("@p_do_numer_kl", SqlDbType.NVarChar); p[2].Value = new_dok.do_numer_klienta; p[3] = new SqlParameter("@p_do_cena_br", SqlDbType.Decimal); p[3].Value = new_dok.do_cena_brutto; p[4] = new SqlParameter("@p_do_cena_nt", SqlDbType.Decimal); p[4].Value = new_dok.do_cena_netto; m = db.Database.SqlQuery <p_int_dokument_pobierz>("exec p_int_dokument_dodaj @p_do_nazwa,@p_do_data,@p_do_numer_kl,@p_do_cena_br,@p_do_cena_nt", p).ToList(); } return(m); }
private void EditDok(p_int_dokument_pobierz dokument, string windowTitle, FormClosingEventHandler closedDelegate) { editDokform = new EditDokForm(dokument) { Text = windowTitle }; editDokform.FormClosing += closedDelegate; editDokform.ShowDialog(); }
public EditDokForm(p_int_dokument_pobierz dok) { InitializeComponent(); txtDonazwa.DataBindings.Add("EditValue", dok, "do_nazwa"); txtNrKlienta.DataBindings.Add("EditValue", dok, "do_numer_klienta"); spinEditCenaBr.DataBindings.Add("EditValue", dok, "do_cena_brutto", true, DataSourceUpdateMode.OnPropertyChanged); spinEditCenaNetto.DataBindings.Add("EditValue", dok, "do_cena_netto", true, DataSourceUpdateMode.OnPropertyChanged); dateEditData.DataBindings.Add("EditValue", dok, "do_data", true, DataSourceUpdateMode.OnPropertyChanged); }
private void btnAdd_Click(object sender, EventArgs e) { try { dok_edit = new p_int_dokument_pobierz(); EditDok(dok_edit, "Nowy dokument", AddNewDok); //ExpandMasterRowDokiAfterCallback(); } catch (Exception ex) { log.Error(ex.Message); log.Error(ex.InnerException.Message); } }
private void EditDok(object sender, FormClosingEventArgs e) { if (((EditDokForm)sender).DialogResult == DialogResult.OK) { try { doki_model = DAO.p_int_dokument_update(dok_edit); gridControlDoki.DataSource = doki_model; } catch (Exception ex) { log.Error(ex.Message); log.Error(ex.InnerException.Message); } } dok_edit = null; }
private void btnEdit_Click(object sender, EventArgs e) { try { var dok_id = GetDoIdByRow(gridViewDoki.FocusedRowHandle); if (dok_id == null) { MessageBox.Show("Brak wybranego dokumenty do edycji"); return; } dok_edit = doki_model.Where(x => x.do_id == dok_id).FirstOrDefault(); EditDok(dok_edit, "Edycja", EditDok); } catch (Exception ex) { log.Error(ex.Message); log.Error(ex.InnerException.Message); } }