private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, EmployeeProfessionItemViewModel 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("@ProfessionId", ((object)EmployeeItem.Profession?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ProfessionIdentifier", ((object)EmployeeItem.Profession?.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ProfessionCode", ((object)EmployeeItem.Profession?.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ProfessionName", ((object)EmployeeItem.Profession?.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ProfessionSecondCode", ((object)EmployeeItem.Profession?.SecondCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryId", ((object)EmployeeItem.Country?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryIdentifier", ((object)EmployeeItem.Country?.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryCode", ((object)EmployeeItem.Country?.Mark) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryName", ((object)EmployeeItem.Country?.Name) ?? 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 EmployeeProfessionItemResponse Create(EmployeeProfessionItemViewModel EmployeeProfessionItem) { EmployeeProfessionItemResponse response = new EmployeeProfessionItemResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, EmployeeProfessionItem); 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 BtnDelete_Click(object sender, RoutedEventArgs e) { var response = new EmployeeProfessionItemSQLiteRepository().SetStatusDeleted(CurrentEmployeeProfessionDG.Identifier); if (response.Success) { MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Stavka_je_uspešno_obrisanaUzvičnik")); CurrentEmployeeProfessionForm = new EmployeeProfessionItemViewModel(); CurrentEmployeeProfessionForm.Identifier = Guid.NewGuid(); CurrentEmployeeProfessionForm.ItemStatus = ItemStatus.Added; CurrentEmployeeProfessionDG = null; EmployeeCreatedUpdated(); Thread displayThread = new Thread(() => DisplayEmployeeProfessionData()); displayThread.IsBackground = true; displayThread.Start(); } else { MainWindow.ErrorMessage = response.Message; } }
private void btnEditEmployee_Click(object sender, RoutedEventArgs e) { CurrentEmployeeProfessionForm = new EmployeeProfessionItemViewModel(); CurrentEmployeeProfessionForm.Identifier = CurrentEmployeeProfessionDG.Identifier; CurrentEmployeeProfessionForm.ItemStatus = ItemStatus.Edited; CurrentEmployeeProfessionForm.IsSynced = CurrentEmployeeProfessionDG.IsSynced; CurrentEmployeeProfessionForm.Country = CurrentEmployeeProfessionDG.Country; CurrentEmployeeProfessionForm.Profession = CurrentEmployeeProfessionDG.Profession; CurrentEmployeeProfessionForm.UpdatedAt = CurrentEmployeeProfessionDG.UpdatedAt; }
public static EmployeeProfessionItemViewModel ConvertToEmployeeProfessionViewModelLite(this EmployeeProfession EmployeeItem) { EmployeeProfessionItemViewModel EmployeeItemViewModel = new EmployeeProfessionItemViewModel() { Id = EmployeeItem.Id, Identifier = EmployeeItem.Identifier, ItemStatus = EmployeeItem.ItemStatus, IsActive = EmployeeItem.Active, UpdatedAt = EmployeeItem.UpdatedAt, CreatedAt = EmployeeItem.CreatedAt }; return(EmployeeItemViewModel); }
public EmployeeProfessionItemResponse Create(EmployeeProfessionItemViewModel EmployeeItemViewModel) { EmployeeProfessionItemResponse response = new EmployeeProfessionItemResponse(); try { response = WpfApiHandler.SendToApi <EmployeeProfessionItemViewModel, EmployeeProfessionItemResponse>(EmployeeItemViewModel, "Create"); } catch (Exception ex) { response.EmployeeProfessionItem = new EmployeeProfessionItemViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
private static EmployeeProfessionItemViewModel Read(SqliteDataReader query) { int counter = 0; EmployeeProfessionItemViewModel dbEntry = new EmployeeProfessionItemViewModel(); dbEntry.Id = SQLiteHelper.GetInt(query, ref counter); dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter); dbEntry.Employee = SQLiteHelper.GetEmployee(query, ref counter); dbEntry.Profession = SQLiteHelper.GetProfession(query, ref counter); dbEntry.Country = SQLiteHelper.GetCountry(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 EmployeeProfessionItemResponse Create(EmployeeProfessionItemViewModel EmployeeItemViewModel) { EmployeeProfessionItemResponse response = new EmployeeProfessionItemResponse(); try { var addedEmployeeItem = unitOfWork.GetEmployeeProfessionRepository().Create(EmployeeItemViewModel.ConvertToEmployeeProfession()); unitOfWork.Save(); response.EmployeeProfessionItem = addedEmployeeItem.ConvertToEmployeeProfessionViewModel(); response.Success = true; } catch (Exception ex) { response.EmployeeProfessionItem = new EmployeeProfessionItemViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public EmployeeProfessionItemListResponse GetEmployeeProfessionsByEmployee(int companyId, Guid EmployeeIdentifier) { EmployeeProfessionItemListResponse response = new EmployeeProfessionItemListResponse(); List <EmployeeProfessionItemViewModel> EmployeeProfessionItems = new List <EmployeeProfessionItemViewModel>(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM EmployeeProfessionItems " + "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()) { EmployeeProfessionItemViewModel dbEntry = Read(query); EmployeeProfessionItems.Add(dbEntry); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.EmployeeProfessionItems = new List <EmployeeProfessionItemViewModel>(); return(response); } db.Close(); } response.Success = true; response.EmployeeProfessionItems = EmployeeProfessionItems; return(response); }
public JsonResult Create([FromBody] EmployeeProfessionItemViewModel c) { EmployeeProfessionItemResponse response = new EmployeeProfessionItemResponse(); try { response = this.EmployeeItemService.Create(c); } catch (Exception ex) { response.Success = false; response.Message = ex.Message; Console.WriteLine(ex.Message); } return(Json(response, new Newtonsoft.Json.JsonSerializerSettings() { Formatting = Newtonsoft.Json.Formatting.Indented })); }
public static EmployeeProfession ConvertToEmployeeProfession(this EmployeeProfessionItemViewModel EmployeeItemViewModel) { EmployeeProfession EmployeeItem = new EmployeeProfession() { Id = EmployeeItemViewModel.Id, Identifier = EmployeeItemViewModel.Identifier, EmployeeId = EmployeeItemViewModel.Employee?.Id ?? null, ProfessionId = EmployeeItemViewModel.Profession?.Id ?? null, CountryId = EmployeeItemViewModel.Country?.Id ?? null, 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 Employee_Profession_AddEdit(EmployeeViewModel employee) { employeeService = DependencyResolver.Kernel.Get <IEmployeeService>(); employeeProfessionService = DependencyResolver.Kernel.Get <IEmployeeProfessionService>(); InitializeComponent(); this.DataContext = this; CurrentEmployee = employee; CurrentEmployeeProfessionForm = new EmployeeProfessionItemViewModel(); CurrentEmployeeProfessionForm.Identifier = Guid.NewGuid(); CurrentEmployeeProfessionForm.ItemStatus = ItemStatus.Added; Thread displayThread = new Thread(() => DisplayEmployeeProfessionData()); displayThread.IsBackground = true; displayThread.Start(); btnAddEmployee.Focus(); }
public static EmployeeProfessionItemViewModel ConvertToEmployeeProfessionViewModel(this EmployeeProfession EmployeeItem) { EmployeeProfessionItemViewModel EmployeeItemViewModel = new EmployeeProfessionItemViewModel() { Id = EmployeeItem.Id, Identifier = EmployeeItem.Identifier, Employee = EmployeeItem.Employee?.ConvertToEmployeeViewModelLite(), Profession = EmployeeItem.Profession?.ConvertToProfessionViewModelLite(), Country = EmployeeItem.Country?.ConvertToCountryViewModelLite(), ItemStatus = EmployeeItem.ItemStatus, IsActive = EmployeeItem.Active, CreatedBy = EmployeeItem.CreatedBy?.ConvertToUserViewModelLite(), Company = EmployeeItem.Company?.ConvertToCompanyViewModelLite(), UpdatedAt = EmployeeItem.UpdatedAt, CreatedAt = EmployeeItem.CreatedAt }; return(EmployeeItemViewModel); }
public EmployeeProfessionItemResponse GetEmployeeProfessionItem(Guid identifier) { EmployeeProfessionItemResponse response = new EmployeeProfessionItemResponse(); EmployeeProfessionItemViewModel EmployeeItem = new EmployeeProfessionItemViewModel(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM EmployeeProfessionItems " + "WHERE Identifier = @Identifier;", db); selectCommand.Parameters.AddWithValue("@Identifier", identifier); SqliteDataReader query = selectCommand.ExecuteReader(); if (query.Read()) { EmployeeProfessionItemViewModel dbEntry = Read(query); EmployeeItem = dbEntry; } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.EmployeeProfessionItem = new EmployeeProfessionItemViewModel(); return(response); } db.Close(); } response.Success = true; response.EmployeeProfessionItem = EmployeeItem; return(response); }
private void btnCancelEmployee_Click(object sender, RoutedEventArgs e) { CurrentEmployeeProfessionForm = new EmployeeProfessionItemViewModel(); CurrentEmployeeProfessionForm.Identifier = Guid.NewGuid(); CurrentEmployeeProfessionForm.ItemStatus = ItemStatus.Added; }
private void btnAddEmployee_Click(object sender, RoutedEventArgs e) { #region Validation if (CurrentEmployeeProfessionForm.Profession?.Name == null) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Obavezno_polje_naziv_profesije")); return; } #endregion Thread th = new Thread(() => { SubmitButtonEnabled = false; CurrentEmployeeProfessionForm.Employee = CurrentEmployee; CurrentEmployeeProfessionForm.Company = new CompanyViewModel() { Id = MainWindow.CurrentCompanyId }; CurrentEmployeeProfessionForm.CreatedBy = new UserViewModel() { Id = MainWindow.CurrentUserId }; new EmployeeProfessionItemSQLiteRepository().Delete(CurrentEmployeeProfessionForm.Identifier); var response = new EmployeeProfessionItemSQLiteRepository().Create(CurrentEmployeeProfessionForm); if (!response.Success) { MainWindow.ErrorMessage = response.Message; CurrentEmployeeProfessionForm = new EmployeeProfessionItemViewModel(); CurrentEmployeeProfessionForm.Identifier = Guid.NewGuid(); CurrentEmployeeProfessionForm.ItemStatus = ItemStatus.Added; CurrentEmployeeProfessionForm.IsSynced = false; return; } CurrentEmployeeProfessionForm = new EmployeeProfessionItemViewModel(); CurrentEmployeeProfessionForm.Identifier = Guid.NewGuid(); CurrentEmployeeProfessionForm.ItemStatus = ItemStatus.Added; CurrentEmployeeProfessionForm.IsSynced = false; EmployeeCreatedUpdated(); DisplayEmployeeProfessionData(); Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { popCountry.Focus(); }) ); SubmitButtonEnabled = true; }); th.IsBackground = true; th.Start(); }