private void LoadStaff()
{
StaffList.Clear();
var sqlData = new StaffQuery().SelectAllNotRetirement();
if (sqlData.HasRows)
{
while (sqlData.Read())
{
StaffDTO dto = new StaffDTO
{
STAFF_IDNUMBER = sqlData["idnumber"].ToString(),
STAFF_DEPT = sqlData["dept"].ToString(),
STAFF_RANK = sqlData["rank"].ToString(),
STAFF_NAME = sqlData["name"].ToString(),
STAFF_ADDRESS = sqlData["address"].ToString(),
STAFF_TEL = sqlData["tel"].ToString(),
STAFF_JOIN_DAY = sqlData["join_day"].ToString(),
STAFF_RETIREMENT_DAY = sqlData["retirement_day"].ToString(),
STAFF_STATE = sqlData["state"].ToString()
};
StaffList.Add(new StaffModel(dto));
}
sqlData.Close();
SharedPreference.Instance.DBM.SqlConn.Close();
}
else
{
sqlData.Close();
SharedPreference.Instance.DBM.SqlConn.Close();
}
}
private void Execute_Reset(object obj)
{
var p = (SfDataGrid)obj;
p.SearchHelper.ClearSearch();
var UID = session.AccountID;
var res = staffRepository.Get(s => s.Account_id != UID);
StaffList.Clear();
res.Distinct().ToList().ForEach(i => StaffList.Add(i));
}
private void Execute_UpdateInfoStaff(object obj)
{
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Are you sure?", "Confirmation", System.Windows.MessageBoxButton.YesNo, MessageBoxImage.Question);
if (messageBoxResult == MessageBoxResult.Yes)
{
var p = (staff)obj;
staffRepository.Update(p);
staffRepository.Save();
var selectedAcc = accountRepository.Get(acc => acc.ID == p.Account_id).FirstOrDefault();
selectedAcc.UserName = ExtraFunction.generateUserName(p);
accountRepository.Update(selectedAcc);
accountRepository.Save();
var UID = session.AccountID;
var res = staffRepository.Get(s => s.Account_id != UID);
StaffList.Clear();
res.Distinct().ToList().ForEach(i => StaffList.Add(i));
System.Windows.Forms.MessageBox.Show("Successfully updated", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
