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