private void FillDialog(dlgTeacher dlg, Teacher T)
{
dlg.txtTeacher.Text = T.Name;
dlg.cbRole.DataSource = Enum.GetNames(typeof(User.UserRole));
dlg.cbRole.Text = T.Role.ToString();
dlg.chkStatus.Checked = (int)T.Status > 0;
}
void EditTeacher()
{
try
{
if (olvSubject.SelectedObject == null)
{
return;
}
using (var dlg = new dlgTeacher())
{
var T = (Teacher)olvSubject.SelectedObject;
FillDialog(dlg, T);
if (dlg.ShowDialog() == DialogResult.OK)
{
//IsqlCommand cmd = new SqlCommand();
if (UpdateTeacherAsync(dlg, T.ID).Result > 0)
{
//cmd.CommitTransaction();
GetData(olvSubject);
SeekHelper.SetListItem <Teacher, int>(T.ID, "ID", olvSubject);
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> UpdateTeacherAsync(dlgTeacher dlg, int id)
{
using (var scope = AppSession.TypeContainer.BeginLifetimeScope())
{
var dbs = scope.Resolve <IDataBaseService>();
return(await dbs.UpdateRecordAsync(TeacherSQL.UpdateTeacher(), CreateUpdateParams(dlg, id)));
}
}
IDictionary <string, object> CreateUpdateParams(dlgTeacher dlg, int id)
{
var sqlParamWithValue = new Dictionary <string, object>();
User.UserRole R = (User.UserRole)Enum.Parse(typeof(User.UserRole), dlg.cbRole.SelectedValue.ToString());
sqlParamWithValue.Add("@ID", id);
sqlParamWithValue.Add("@Rola", R);
sqlParamWithValue.Add("@Status", dlg.chkStatus.Checked);
sqlParamWithValue.Add("@User", UserSession.User.Login);
sqlParamWithValue.Add("@IP", AppSession.HostIP);
return(sqlParamWithValue);
}