public CalendarAssignmentListResponse GetCalendarAssignmentsByDate(int companyId, DateTime?filterDate) { CalendarAssignmentListResponse response = new CalendarAssignmentListResponse(); List <CalendarAssignmentViewModel> CalendarAssignments = new List <CalendarAssignmentViewModel>(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM CalendarAssignments assignment " + "WHERE (@Date IS NULL OR @Date = '' OR DATE(Date) = DATE(@Date)) " + "AND assignment.CompanyId = @CompanyId " + "ORDER BY assignment.IsSynced, assignment.Id DESC ", db); selectCommand.Parameters.AddWithValue("@Date", ((object)filterDate) ?? DBNull.Value); selectCommand.Parameters.AddWithValue("@CompanyId", companyId); SqliteDataReader query = selectCommand.ExecuteReader(); while (query.Read()) { CalendarAssignmentViewModel dbEntry = Read(query); CalendarAssignments.Add(dbEntry); } response.CalendarAssignments = CalendarAssignments; selectCommand = new SqliteCommand( "SELECT Count(*) " + "FROM CalendarAssignments assignment " + "WHERE (@Date IS NULL OR @Date = '' OR DATE(Date) = DATE(@Date)) " + "AND assignment.CompanyId = @CompanyId " + "ORDER BY assignment.IsSynced, assignment.Id DESC;", db); selectCommand.Parameters.AddWithValue("@Date", ((object)filterDate) ?? DBNull.Value); selectCommand.Parameters.AddWithValue("@CompanyId", companyId); query = selectCommand.ExecuteReader(); if (query.Read()) { response.TotalItems = query.GetInt32(0); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.CalendarAssignments = new List <CalendarAssignmentViewModel>(); return(response); } db.Close(); } response.Success = true; response.CalendarAssignments = CalendarAssignments; return(response); }
public CalendarAssignmentResponse Create(CalendarAssignmentViewModel CalendarAssignment) { CalendarAssignmentResponse response = new CalendarAssignmentResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, CalendarAssignment); 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); } }
public Calendar_AddEdit(CalendarAssignmentViewModel calendarAssignment, bool isCreateProcess, bool isPopup = false) { InitializeComponent(); calendarAssignmentService = DependencyResolver.Kernel.Get <ICalendarAssignmentService>(); this.DataContext = this; CurrentCalendarAssignment = calendarAssignment; IsCreateProcess = isCreateProcess; IsPopup = isPopup; }
private void btnAdd_Click(object sender, RoutedEventArgs e) { CalendarAssignmentViewModel calendarAssignment = new CalendarAssignmentViewModel(); calendarAssignment.Identifier = Guid.NewGuid(); calendarAssignment.Date = TodayDate?.Date ?? DateTime.Now.Date; Calendar_AddEdit addEditForm = new Calendar_AddEdit(calendarAssignment, true); addEditForm.CalendarAssignmentCreatedUpdated += new CalendarAssignmentHandler(SyncData); FlyoutHelper.OpenFlyout(this, ((string)Application.Current.FindResource("Kalendar")), 95, addEditForm); }
public CalendarAssignmentResponse Create(CalendarAssignmentViewModel CalendarAssignment) { CalendarAssignmentResponse response = new CalendarAssignmentResponse(); try { response = WpfApiHandler.SendToApi <CalendarAssignmentViewModel, CalendarAssignmentResponse>(CalendarAssignment, "Create"); } catch (Exception ex) { response.CalendarAssignment = new CalendarAssignmentViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
private static CalendarAssignmentViewModel Read(SqliteDataReader query) { int counter = 0; CalendarAssignmentViewModel dbEntry = new CalendarAssignmentViewModel(); dbEntry.Id = SQLiteHelper.GetInt(query, ref counter); dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter); dbEntry.Name = SQLiteHelper.GetString(query, ref counter); dbEntry.Description = SQLiteHelper.GetString(query, ref counter); dbEntry.Date = SQLiteHelper.GetDateTime(query, ref counter); dbEntry.IsSynced = SQLiteHelper.GetBoolean(query, ref counter); dbEntry.UpdatedAt = SQLiteHelper.GetDateTime(query, ref counter); dbEntry.AssignedTo = SQLiteHelper.GetCreatedBy(query, ref counter); dbEntry.CreatedBy = SQLiteHelper.GetCreatedBy(query, ref counter); dbEntry.Company = SQLiteHelper.GetCompany(query, ref counter); return(dbEntry); }
public static CalendarAssignmentViewModel ConvertToCalendarAssignmentViewModelLite(this CalendarAssignment CalendarAssignment) { CalendarAssignmentViewModel CalendarAssignmentViewModel = new CalendarAssignmentViewModel() { Id = CalendarAssignment.Id, Identifier = CalendarAssignment.Identifier, Name = CalendarAssignment.Name, Description = CalendarAssignment.Description, Date = CalendarAssignment.Date, IsActive = CalendarAssignment.Active, UpdatedAt = CalendarAssignment.UpdatedAt, CreatedAt = CalendarAssignment.CreatedAt }; return(CalendarAssignmentViewModel); }
public JsonResult Create([FromBody] CalendarAssignmentViewModel c) { CalendarAssignmentResponse response; try { response = this.calendarAssignmentService.Create(c); } catch (Exception ex) { response = null; Console.WriteLine(ex.Message); } return(Json(response, new Newtonsoft.Json.JsonSerializerSettings() { Formatting = Newtonsoft.Json.Formatting.Indented })); }
private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, CalendarAssignmentViewModel CalendarAssignment) { insertCommand.Parameters.AddWithValue("@ServerId", CalendarAssignment.Id); insertCommand.Parameters.AddWithValue("@Identifier", CalendarAssignment.Identifier); insertCommand.Parameters.AddWithValue("@Name", ((object)CalendarAssignment.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Description", ((object)CalendarAssignment.Description) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Date", ((object)CalendarAssignment.Date) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@IsSynced", CalendarAssignment.IsSynced); insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)CalendarAssignment.UpdatedAt) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@AssignedToId", ((object)CalendarAssignment?.AssignedTo?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@AssignedToName", (object)(CalendarAssignment?.AssignedTo?.FirstName + " " + CalendarAssignment?.AssignedTo?.LastName) ?? 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 CalendarAssignment ConvertToCalendarAssignment(this CalendarAssignmentViewModel CalendarAssignmentViewModel) { CalendarAssignment CalendarAssignment = new CalendarAssignment() { Id = CalendarAssignmentViewModel.Id, Identifier = CalendarAssignmentViewModel.Identifier, Name = CalendarAssignmentViewModel.Name, Description = CalendarAssignmentViewModel.Description, Date = CalendarAssignmentViewModel.Date, AssignedToId = CalendarAssignmentViewModel?.AssignedTo?.Id ?? null, Active = CalendarAssignmentViewModel.IsActive, CreatedById = CalendarAssignmentViewModel.CreatedBy?.Id ?? null, CompanyId = CalendarAssignmentViewModel.Company?.Id ?? null, CreatedAt = CalendarAssignmentViewModel.CreatedAt, UpdatedAt = CalendarAssignmentViewModel.UpdatedAt }; return(CalendarAssignment); }
public CalendarAssignmentResponse Create(CalendarAssignmentViewModel assignment) { CalendarAssignmentResponse response = new CalendarAssignmentResponse(); try { response.CalendarAssignment = unitOfWork.GetCalendarAssignmentRepository() .Create(assignment.ConvertToCalendarAssignment()) .ConvertToCalendarAssignmentViewModel(); unitOfWork.Save(); response.Success = true; } catch (Exception ex) { response.CalendarAssignment = new CalendarAssignmentViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public static CalendarAssignmentViewModel ConvertToCalendarAssignmentViewModel(this CalendarAssignment CalendarAssignment) { CalendarAssignmentViewModel CalendarAssignmentViewModel = new CalendarAssignmentViewModel() { Id = CalendarAssignment.Id, Identifier = CalendarAssignment.Identifier, Name = CalendarAssignment.Name, Description = CalendarAssignment.Description, Date = CalendarAssignment.Date, IsActive = CalendarAssignment.Active, CreatedBy = CalendarAssignment?.CreatedBy?.ConvertToUserViewModelLite(), AssignedTo = CalendarAssignment?.AssignedTo?.ConvertToUserViewModelLite(), Company = CalendarAssignment?.Company?.ConvertToCompanyViewModelLite(), UpdatedAt = CalendarAssignment.UpdatedAt, CreatedAt = CalendarAssignment.CreatedAt }; return(CalendarAssignmentViewModel); }
private void BtnSubmit_Click(object sender, RoutedEventArgs e) { #region Validation if (CurrentCalendarAssignment.Date == null) { MainWindow.WarningMessage = ((string)Application.Current.FindResource("ObaveznoPoljeDatum")); return; } if (String.IsNullOrEmpty(CurrentCalendarAssignment.Name)) { MainWindow.WarningMessage = ((string)Application.Current.FindResource("ObaveznoPoljeNaziv")); return; } if (String.IsNullOrEmpty(CurrentCalendarAssignment.Description)) { MainWindow.WarningMessage = ((string)Application.Current.FindResource("ObaveznoPoljeOpis")); return; } #endregion Thread th = new Thread(() => { SubmitButtonContent = ((string)Application.Current.FindResource("Čuvanje_u_tokuTriTacke")); SubmitButtonEnabled = false; CurrentCalendarAssignment.IsSynced = false; CurrentCalendarAssignment.Company = new CompanyViewModel() { Id = MainWindow.CurrentCompanyId }; CurrentCalendarAssignment.CreatedBy = new UserViewModel() { Id = MainWindow.CurrentUserId }; CalendarAssignmentResponse response = new CalendarAssignmentSQLiteRepository().Delete(CurrentCalendarAssignment.Identifier); response = new CalendarAssignmentSQLiteRepository().Create(CurrentCalendarAssignment); if (!response.Success) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Greška_kod_lokalnog_čuvanjaUzvičnik")); SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži")); SubmitButtonEnabled = true; return; } response = calendarAssignmentService.Create(CurrentCalendarAssignment); if (!response.Success) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Podaci_su_sačuvani_u_lokaluUzvičnikTačka_Greška_kod_čuvanja_na_serveruUzvičnik")); SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži")); SubmitButtonEnabled = true; } if (response.Success) { MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Podaci_su_uspešno_sačuvaniUzvičnik")); SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži")); SubmitButtonEnabled = true; CalendarAssignmentCreatedUpdated?.Invoke(); if (IsCreateProcess) { DateTime tmpDate = CurrentCalendarAssignment.Date; CurrentCalendarAssignment = new CalendarAssignmentViewModel(); CurrentCalendarAssignment.Identifier = Guid.NewGuid(); CurrentCalendarAssignment.Date = tmpDate; Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { dtSelectedDate.Focus(); }) ); } else { Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { if (IsPopup) { FlyoutHelper.CloseFlyoutPopup(this); } else { FlyoutHelper.CloseFlyout(this); } }) ); } } }); th.IsBackground = true; th.Start(); }