IDictionary <string, object> CreateUpdateParams(dlgSchool dlg, int id)
{
var sqlParamWithValue = new Dictionary <string, object>();
string NipNumber = null;
if (dlg.txtNip.Text.Length > 0)
{
NipNumber = dlg.txtNip.Text;
}
int?CityID = null;
if (((City)dlg.cbMiejscowosc.SelectedItem).ID != 0)
{
CityID = ((City)dlg.cbMiejscowosc.SelectedItem).ID;
}
sqlParamWithValue.Add("@ID", id);
sqlParamWithValue.Add("@Nazwa", dlg.txtNazwa.Text.Trim());
sqlParamWithValue.Add("@Alias", dlg.txtAlias.Text.Trim());
sqlParamWithValue.Add("@Nip", NipNumber);
sqlParamWithValue.Add("@Ulica", dlg.txtUlica.Text.Trim());
sqlParamWithValue.Add("@Nr", dlg.txtNr.Text.Trim());
sqlParamWithValue.Add("@IdMiejscowosc", CityID);
sqlParamWithValue.Add("@Telefon", dlg.txtTel.Text.Trim());
sqlParamWithValue.Add("@Fax", dlg.txtFax.Text.Trim());
sqlParamWithValue.Add("@Email", dlg.txtEmail.Text.Trim());
sqlParamWithValue.Add("@User", UserSession.User.Login);
sqlParamWithValue.Add("@IP", AppSession.HostIP);
return(sqlParamWithValue);
}
private void EditSchool()
{
try
{
using (var dlg = new dlgSchool())
{
var S = olvSzkola.SelectedObject as School;
FillDialog(dlg, S);
if (dlg.ShowDialog() == DialogResult.OK)
{
//IsqlCommand cmd = new SqlCommand();
if (UpdateDataAsync(dlg, S.ID).Result > 0)
{
NewRecord(S.ID);
return;
}
throw new Exception("Aktualizacja danych nie powiodła się!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private async Task <int> UpdateDataAsync(dlgSchool dlg, int id)
{
using (var scope = AppSession.TypeContainer.BeginLifetimeScope())
{
var dbs = scope.Resolve <IDataBaseService>();
return(await dbs.UpdateRecordAsync(SchoolSQL.UpdateSchool(), CreateUpdateParams(dlg, id)));
}
}
private void cmdAddNew_Click(object sender, EventArgs e)
{
using (var dlg = new dlgSchool())
{
dlg.IsNewMode = true;
dlg.cbTyp.DataSource = cbSchoolType.DataSource;
dlg.cbTyp.SelectedItem = cbSchoolType.SelectedItem;
dlg.NewRecordAdded += NewRecord;
dlg.ShowDialog();
dlg.NewRecordAdded -= NewRecord;
}
}
private void FillDialog(dlgSchool dlg, School S)
{
dlg.Text = "Edycja danych szkoły";
dlg.IsNewMode = false;
dlg.cbTyp.Enabled = false;
dlg.cbTyp.DataSource = cbSchoolType.DataSource;
SetSchoolType(S.SchoolType.ID, dlg.cbTyp);
dlg.txtNazwa.Text = S.Name;
dlg.txtAlias.Text = S.Alias;
dlg.txtEmail.Text = S.Email;
dlg.txtFax.Text = S.FaxNo;
dlg.txtNip.Text = S.Nip;
dlg.txtNr.Text = S.PlaceNo;
dlg.txtTel.Text = S.PlaceNo;
dlg.txtUlica.Text = S.StreetName;
//dlgSchool.SetCity(S.Location.ID, dlg.cbMiejscowosc);
dlg.cbMiejscowosc.SelectedIndex = City.ComboItems.GetCityIndex(S.Location.ID, dlg.cbMiejscowosc.Items);
}
