private void cmdOK_Click(object sender, EventArgs e)
{
if (!IsNewMode)
{
DialogResult = DialogResult.OK;
Close();
}
else
{
try
{
if (!CompareStrings(txtPassword.Text.Trim(), txtPassword2.Text.Trim()))
{
return;
}
if (!StringHelper.ValidatePassword(txtPassword.Text.Trim()))
{
var msg = "Hasło musi mieć co najmniej " + AppVars.MinPwdLength.ToString() + " znaków, w tym co najmniej jedną cyfrę, jedną wielką i jedną małą literę!";
MessageBox.Show(msg, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var RecordID = AddUser().Result;
if (RecordID > 0)
{
NewRecordAdded?.Invoke(txtLogin.Text.Trim());
ClearControls();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void cmdOK_Click(object sender, EventArgs e)
{
if (IsNewMode)
{
var StudentId = AddStudent().Result;
if (StudentId > 0)
{
if (AddStudentAllocation(StudentId).Result > 0)
{
NewRecordAdded?.Invoke(StudentId);
cmdOK.Enabled = false;
ClearData();
}
else
{
MessageBox.Show("Wystąpił błąd podczas dodawania przydziału ucznia.\nOperacja została anulowana.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return;
}
else
{
MessageBox.Show("Wystąpił błąd podczas dodawania ucznia.\nOperacja została anulowana.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
DialogResult = DialogResult.OK;
Close();
}
}
private void cmdOK_Click(object sender, EventArgs e)
{
if (IsNewMode)
{
try
{
var recordID = AddSchoolClass().Result;
if (recordID > 0)
{
NewRecordAdded?.Invoke(recordID);
cmdOK.Enabled = false;
LoadSchoolClass();
cbKlasa_SelectedIndexChanged(cbKlasa, e);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
DialogResult = DialogResult.OK;
Close();
}
}
private void cmdOK_Click(object sender, EventArgs e)
{
if (IsNewMode)
{
var IdList = new List <int>();
if (chkPion.Checked)
{
IdList = cbKlasa.Items.Cast <SchoolClass>().Where(x => x.ClassCode.Substring(0, 1) == ((SchoolClass)cbKlasa.SelectedItem).ClassCode.Substring(0, 1)).Select(x => x.ID).ToList();
}
else
{
IdList.Add(((SchoolClass)cbKlasa.SelectedItem).ID);
}
var RecordID = AddSubjectScheme(IdList).Result.Item2;
if (RecordID > 0)
{
NewRecordAdded?.Invoke(RecordID);
cmdOK.Enabled = false;
cbKlasa_SelectedIndexChanged(cbKlasa, e);
}
}
else
{
DialogResult = DialogResult.OK;
Close();
}
}
private void cmdOK_Click(object sender, EventArgs e)
{
if (!IsNewMode)
{
DialogResult = DialogResult.OK;
Close();
}
else
{
try
{
var recordID = AddSchoolType(txtNazwa.Text, txtAlias.Text).Result;
if (recordID > 0)
{
NewRecordAdded?.Invoke(recordID);
ClearControls();
txtNazwa.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
bool AddPrivilege()
{
try
{
long recordId = 0;
int recordCount = 0;
var sqlString = PrivilegeSQL.InsertPrivilege();
var sqlParamWithValue = new HashSet <IDictionary <string, object> >();
foreach (Privilege P in olvObsada.CheckedObjects)
{
sqlParamWithValue.Add(CreatePrivilegeParams(P));
}
using (var scope = AppSession.TypeContainer.BeginLifetimeScope())
{
var dbs = scope.Resolve <IDataBaseService>();
var value = dbs.AddManyRecordsAsync(sqlString, sqlParamWithValue).Result;
recordCount = value.RecordCount;
recordId = value.InsertedRecordId;
}
NewRecordAdded?.Invoke(recordId);
MessageBox.Show($"{recordCount} rekordów zostało dodanych.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
private bool AddNewExclusion()
{
try
{
int recordCount = 0;
var sqlString = PrivilegeSQL.InsertExclusion();
var sqlParamWithValue = new HashSet <IDictionary <string, object> >();
foreach (StudentAllocation S in olvStudent.CheckedObjects)
{
sqlParamWithValue.Add(new Dictionary <string, object>
{
{ "@AllocationID", S.ID },
{ "@PrivilegeID", privilege.ID },
{ "@StartDate", S.StartDate },
{ "@EndDate", S.EndDate },
{ "@Owner", S.Creator.Owner },
{ "@User", S.Creator.User },
{ "@IP", S.Creator.IP }
});
}
using (var scope = AppSession.TypeContainer.BeginLifetimeScope())
{
var dbs = scope.Resolve <IDataBaseService>();
recordCount = dbs.AddManyRecordsAsync(sqlString, sqlParamWithValue).Result.RecordCount;
}
if (recordCount > 0)
{
MessageBox.Show($"{recordCount} rekordów zostało dodanych.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
NewRecordAdded?.Invoke(new Exclusion
{
AllocationID = (int)sqlParamWithValue.Last().Where(x => x.Key == "@AllocationID").First().Value,
PrivilegeID = (int)sqlParamWithValue.Last().Where(x => x.Key == "@PrivilegeID").First().Value
});
return(true);
}
throw new Exception($"Wystąpił błąd podczas dodawania wykluczenia.\nOperacja została anulowana.");
}
catch (Exception)
{
throw;
}
}
