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);
}
}
