public EmployeeDetailsPage(EmployeeItemViewModel employee) { InitializeComponent(); var empvm = new EmployeeDetailsViewModel(employee); BindingContext = empvm; }
private void BtnDelete_Click(object sender, RoutedEventArgs e) { var response = new EmployeeItemSQLiteRepository().SetStatusDeleted(CurrentEmployeeItemDG.Identifier); if (response.Success) { MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Stavka_je_uspešno_obrisanaUzvičnik")); CurrentEmployeeItemForm = new EmployeeItemViewModel(); CurrentEmployeeItemForm.Identifier = Guid.NewGuid(); CurrentEmployeeItemForm.ItemStatus = ItemStatus.Added; CurrentEmployeeItemDG = null; EmployeeCreatedUpdated(); Thread displayThread = new Thread(() => DisplayEmployeeItemData()); displayThread.IsBackground = true; displayThread.Start(); } else { MainWindow.ErrorMessage = response.Message; } }
public static EmployeeItem ConvertToEmployeeItem(this EmployeeItemViewModel EmployeeItemViewModel) { EmployeeItem EmployeeItem = new EmployeeItem() { Id = EmployeeItemViewModel.Id, Identifier = EmployeeItemViewModel.Identifier, EmployeeId = EmployeeItemViewModel.Employee?.Id ?? null, FamilyMemberId = EmployeeItemViewModel.FamilyMember?.Id ?? null, Name = EmployeeItemViewModel.Name, DateOfBirth = (DateTime)EmployeeItemViewModel.DateOfBirth, EmbassyDate = EmployeeItemViewModel.EmbassyDate, ItemStatus = EmployeeItemViewModel.ItemStatus, Active = EmployeeItemViewModel.IsActive, CreatedById = EmployeeItemViewModel.CreatedBy?.Id ?? null, CompanyId = EmployeeItemViewModel.Company?.Id ?? null, CreatedAt = EmployeeItemViewModel.CreatedAt, UpdatedAt = EmployeeItemViewModel.UpdatedAt }; return(EmployeeItem); }
public static EmployeeItemViewModel ConvertToEmployeeItemViewModel(this EmployeeItem EmployeeItem) { EmployeeItemViewModel EmployeeItemViewModel = new EmployeeItemViewModel() { Id = EmployeeItem.Id, Identifier = EmployeeItem.Identifier, Employee = EmployeeItem.Employee?.ConvertToEmployeeViewModelLite(), FamilyMember = EmployeeItem.FamilyMember?.ConvertToFamilyMemberViewModelLite(), Name = EmployeeItem.Name, DateOfBirth = EmployeeItem.DateOfBirth, EmbassyDate = EmployeeItem.EmbassyDate, ItemStatus = EmployeeItem.ItemStatus, IsActive = EmployeeItem.Active, CreatedBy = EmployeeItem.CreatedBy?.ConvertToUserViewModelLite(), Company = EmployeeItem.Company?.ConvertToCompanyViewModelLite(), UpdatedAt = EmployeeItem.UpdatedAt, CreatedAt = EmployeeItem.CreatedAt }; return(EmployeeItemViewModel); }
private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, EmployeeItemViewModel EmployeeItem) { insertCommand.Parameters.AddWithValue("@ServerId", EmployeeItem.Id); insertCommand.Parameters.AddWithValue("@Identifier", EmployeeItem.Identifier); insertCommand.Parameters.AddWithValue("@EmployeeId", ((object)EmployeeItem.Employee.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@EmployeeIdentifier", ((object)EmployeeItem.Employee.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@EmployeeCode", ((object)EmployeeItem.Employee.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@EmployeeName", ((object)EmployeeItem.Employee.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@EmployeeInternalCode", ((object)EmployeeItem.Employee.EmployeeCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@FamilyMemberId", ((object)EmployeeItem.FamilyMember.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@FamilyMemberIdentifier", ((object)EmployeeItem.Employee.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@FamilyMemberCode", ((object)EmployeeItem.FamilyMember.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@FamilyMemberName", ((object)EmployeeItem.FamilyMember.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Name", EmployeeItem.Name); insertCommand.Parameters.AddWithValue("@DateOfBirth", ((object)EmployeeItem.DateOfBirth) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@EmbassyDate", ((object)EmployeeItem.EmbassyDate) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Passport", ((object)EmployeeItem.Passport) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ItemStatus", ((object)EmployeeItem.ItemStatus) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@IsSynced", EmployeeItem.IsSynced); insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)EmployeeItem.UpdatedAt) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CreatedById", MainWindow.CurrentUser.Id); insertCommand.Parameters.AddWithValue("@CreatedByName", MainWindow.CurrentUser.FirstName + " " + MainWindow.CurrentUser.LastName); insertCommand.Parameters.AddWithValue("@CompanyId", MainWindow.CurrentCompany.Id); insertCommand.Parameters.AddWithValue("@CompanyName", MainWindow.CurrentCompany.CompanyName); return(insertCommand); }
public static List <EmployeeItemViewModel> GetAllEmpoyee(string pDeptCode, string pStatus) { List <EmployeeItemViewModel> res = new List <EmployeeItemViewModel>(); if (string.IsNullOrEmpty(pDeptCode)) { return(res); } DataTable dtRes = new DataTable(); HRInfoAccess _access = new HRInfoAccess(); dtRes = _access.HRInfo_Query("Q", "", pDeptCode, pStatus, "en"); foreach (DataRow dtr in dtRes.Rows) { EmployeeItemViewModel item = new EmployeeItemViewModel { EMPID = dtr["EMPID"].ToString(), SYS_EMPID = dtr["SYS_EMPID"].ToString(), FULLNAME = dtr["FULLNAME"].ToString(), EMPNAME = dtr["EMPNAME"].ToString(), DEPARTMENT = dtr["DEPARTMENT"].ToString(), STATUS = dtr["STATUS"].ToString(), IDENTITYCARD = dtr["UID_FOR_MES"].ToString(), RFID = dtr["RFID"].ToString(), DATEJOIN = dtr["DATEJOIN"].ToString() }; res.Add(item); } return(res); }
public EmployeeItemResponse Create(EmployeeItemViewModel EmployeeItem) { EmployeeItemResponse response = new EmployeeItemResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, EmployeeItem); insertCommand.ExecuteNonQuery(); } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; return(response); } db.Close(); response.Success = true; return(response); } }
private void btnEditItem_Click(object sender, RoutedEventArgs e) { CurrentEmployeeItemForm = new EmployeeItemViewModel(); CurrentEmployeeItemForm.Identifier = CurrentEmployeeItemDG.Identifier; CurrentEmployeeItemForm.ItemStatus = ItemStatus.Edited; CurrentEmployeeItemForm.IsSynced = CurrentEmployeeItemDG.IsSynced; CurrentEmployeeItemForm.FamilyMember = CurrentEmployeeItemDG.FamilyMember; CurrentEmployeeItemForm.Name = CurrentEmployeeItemDG.Name; CurrentEmployeeItemForm.DateOfBirth = CurrentEmployeeItemDG.DateOfBirth; CurrentEmployeeItemForm.Passport = CurrentEmployeeItemDG.Passport; CurrentEmployeeItemForm.EmbassyDate = CurrentEmployeeItemDG.EmbassyDate; CurrentEmployeeItemForm.UpdatedAt = CurrentEmployeeItemDG.UpdatedAt; }
public EmployeeItemListResponse GetEmployeeItemsByEmployee(int companyId, Guid EmployeeIdentifier) { EmployeeItemListResponse response = new EmployeeItemListResponse(); List <EmployeeItemViewModel> EmployeeItems = new List <EmployeeItemViewModel>(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM EmployeeItems " + "WHERE EmployeeIdentifier = @EmployeeIdentifier " + "AND CompanyId = @CompanyId " + "ORDER BY IsSynced, Id DESC;", db); selectCommand.Parameters.AddWithValue("@EmployeeIdentifier", EmployeeIdentifier); selectCommand.Parameters.AddWithValue("@CompanyId", companyId); SqliteDataReader query = selectCommand.ExecuteReader(); while (query.Read()) { EmployeeItemViewModel dbEntry = Read(query); EmployeeItems.Add(dbEntry); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.EmployeeItems = new List <EmployeeItemViewModel>(); return(response); } db.Close(); } response.Success = true; response.EmployeeItems = EmployeeItems; return(response); }
public static EmployeeItemViewModel ConvertToEmployeeItemViewModelLite(this EmployeeItem EmployeeItem) { EmployeeItemViewModel EmployeeItemViewModel = new EmployeeItemViewModel() { Id = EmployeeItem.Id, Identifier = EmployeeItem.Identifier, Name = EmployeeItem.Name, DateOfBirth = EmployeeItem.DateOfBirth, EmbassyDate = EmployeeItem.EmbassyDate, ItemStatus = EmployeeItem.ItemStatus, IsActive = EmployeeItem.Active, UpdatedAt = EmployeeItem.UpdatedAt, CreatedAt = EmployeeItem.CreatedAt }; return(EmployeeItemViewModel); }
private static EmployeeItemViewModel Read(SqliteDataReader query) { int counter = 0; EmployeeItemViewModel dbEntry = new EmployeeItemViewModel(); dbEntry.Id = SQLiteHelper.GetInt(query, ref counter); dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter); dbEntry.Employee = SQLiteHelper.GetEmployee(query, ref counter); dbEntry.FamilyMember = SQLiteHelper.GetFamilyMember(query, ref counter); dbEntry.Name = SQLiteHelper.GetString(query, ref counter); dbEntry.DateOfBirth = SQLiteHelper.GetDateTime(query, ref counter); dbEntry.EmbassyDate = SQLiteHelper.GetDateTime(query, ref counter); dbEntry.Passport = SQLiteHelper.GetString(query, ref counter); dbEntry.ItemStatus = SQLiteHelper.GetInt(query, ref counter); dbEntry.IsSynced = SQLiteHelper.GetBoolean(query, ref counter); dbEntry.UpdatedAt = SQLiteHelper.GetDateTime(query, ref counter); dbEntry.CreatedBy = SQLiteHelper.GetCreatedBy(query, ref counter); dbEntry.Company = SQLiteHelper.GetCompany(query, ref counter); return(dbEntry); }
public Employee_Item_AddEdit(EmployeeViewModel employee) { employeeService = DependencyResolver.Kernel.Get <IEmployeeService>(); employeeItemService = DependencyResolver.Kernel.Get <IEmployeeItemService>(); InitializeComponent(); this.DataContext = this; CurrentEmployee = employee; CurrentEmployeeItemForm = new EmployeeItemViewModel(); CurrentEmployeeItemForm.Identifier = Guid.NewGuid(); CurrentEmployeeItemForm.ItemStatus = ItemStatus.Added; Thread displayThread = new Thread(() => DisplayEmployeeItemData()); displayThread.IsBackground = true; displayThread.Start(); txtName.Focus(); }
public EmployeeItemResponse GetEmployeeItem(Guid identifier) { EmployeeItemResponse response = new EmployeeItemResponse(); EmployeeItemViewModel EmployeeItem = new EmployeeItemViewModel(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM EmployeeItems " + "WHERE Identifier = @Identifier;", db); selectCommand.Parameters.AddWithValue("@Identifier", identifier); SqliteDataReader query = selectCommand.ExecuteReader(); if (query.Read()) { EmployeeItemViewModel dbEntry = Read(query); EmployeeItem = dbEntry; } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.EmployeeItem = new EmployeeItemViewModel(); return(response); } db.Close(); } response.Success = true; response.EmployeeItem = EmployeeItem; return(response); }
private void btnCancelItem_Click(object sender, RoutedEventArgs e) { CurrentEmployeeItemForm = new EmployeeItemViewModel(); CurrentEmployeeItemForm.Identifier = Guid.NewGuid(); CurrentEmployeeItemForm.ItemStatus = ItemStatus.Added; }
private void btnAddItem_Click(object sender, RoutedEventArgs e) { #region Validation if (CurrentEmployeeItemForm.FamilyMember?.Name == null) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Obavezno_poljeDvotačka_clanporodice")); return; } #endregion Thread th = new Thread(() => { SubmitButtonEnabled = false; CurrentEmployeeItemForm.Employee = CurrentEmployee; CurrentEmployeeItemForm.Company = new CompanyViewModel() { Id = MainWindow.CurrentCompanyId }; CurrentEmployeeItemForm.CreatedBy = new UserViewModel() { Id = MainWindow.CurrentUserId }; new EmployeeItemSQLiteRepository().Delete(CurrentEmployeeItemForm.Identifier); var response = new EmployeeItemSQLiteRepository().Create(CurrentEmployeeItemForm); if (!response.Success) { MainWindow.ErrorMessage = response.Message; CurrentEmployeeItemForm = new EmployeeItemViewModel(); CurrentEmployeeItemForm.Identifier = Guid.NewGuid(); CurrentEmployeeItemForm.ItemStatus = ItemStatus.Added; CurrentEmployeeItemForm.IsSynced = false; return; } CurrentEmployeeItemForm = new EmployeeItemViewModel(); CurrentEmployeeItemForm.Identifier = Guid.NewGuid(); CurrentEmployeeItemForm.ItemStatus = ItemStatus.Added; CurrentEmployeeItemForm.IsSynced = false; EmployeeCreatedUpdated(); DisplayEmployeeItemData(); Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { txtName.Focus(); }) ); SubmitButtonEnabled = true; }); th.IsBackground = true; th.Start(); }
public EmployeeItemViewModelTest() { _employeeItemViewModel = new EmployeeItemViewModel(_directoryManager); }