Пример #1
0
        private async void SaveVehicleChecklistToDatabase(Boolean displayAlert)
        {
            try
            {
                ApplyActivityIndicator();

                var staff            = App.StaffDatabase.GetStaffById(Convert.ToInt32(App.SettingsDatabase.GetSetting("AssignedStaffId").Value));
                var vehicleChecklist = App.VehicleChecklistsDatabase.GetVehicleChecklistById(Convert.ToInt32(Id.Text));

                var m = new Models.VehicleChecklists()
                {
                    CreatedDate    = CreatedDate_DatePicker.Date,
                    IsDeleted      = false,
                    Information    = null,
                    OfficeId       = null,
                    SentToOffice   = false,
                    StaffId        = staff.Id,
                    StaffSignature = null,
                    Comments       = Comments_Entry.Text,
                    Mileage        = Mileage_Entry.Text,
                    Registration   = Registration_Entry.Text.ToUpper()
                };

                #region Line Items

                var issues = new List <VehicleChecklistIssuesViewModel>
                {
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = OCFL_Label.Text,
                        Comments      = OCFL_Comments.Text,
                        Condition     = OCFL_Picker.SelectedIndex != -1 ? OCFL_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = VLWC_Label.Text,
                        Comments      = VLWC_Comments.Text,
                        Condition     = VLWC_Picker.SelectedIndex != -1 ? VLWC_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = WW_Label.Text,
                        Comments      = WW_Comments.Text,
                        Condition     = WW_Picker.SelectedIndex != -1 ? WW_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = CWM_Label.Text,
                        Comments      = CWM_Comments.Text,
                        Condition     = CWM_Picker.SelectedIndex != -1 ? CWM_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = H_Label.Text,
                        Comments      = H_Comments.Text,
                        Condition     = H_Picker.SelectedIndex != -1 ? H_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = HB_Label.Text,
                        Comments      = HB_Comments.Text,
                        Condition     = HB_Picker.SelectedIndex != -1 ? HB_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = TP_Label.Text,
                        Comments      = TP_Comments.Text,
                        Condition     = TP_Picker.SelectedIndex != -1 ? TP_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = TC_Label.Text,
                        Comments      = TC_Comments.Text,
                        Condition     = TC_Picker.SelectedIndex != -1 ? TC_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = CVN_Label.Text,
                        Comments      = CVN_Comments.Text,
                        Condition     = CVN_Picker.SelectedIndex != -1 ? CVN_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = SW_Label.Text,
                        Comments      = SW_Comments.Text,
                        Condition     = SW_Picker.SelectedIndex != -1 ? SW_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = CCV_Label.Text,
                        Comments      = CCV_Comments.Text,
                        Condition     = CCV_Picker.SelectedIndex != -1 ? CCV_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = ISS_Label.Text,
                        Comments      = ISS_Comments.Text,
                        Condition     = ISS_Picker.SelectedIndex != -1 ? ISS_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = FE_Label.Text,
                        Comments      = FE_Comments.Text,
                        Condition     = FE_Picker.SelectedIndex != -1 ? FE_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    },
                    new VehicleChecklistIssuesViewModel()
                    {
                        IssueName     = FA_Label.Text,
                        Comments      = FA_Comments.Text,
                        Condition     = FA_Picker.SelectedIndex != -1 ? FA_Picker.SelectedItem.ToString() : "N/A",
                        IssueCategory = "Vehicle"
                    }
                };

                m.Information = JsonConvert.SerializeObject(new
                {
                    Issues = issues
                });

                #endregion

                if (vehicleChecklist != null)
                {
                    if (vehicleChecklist.StaffSignature != null)
                    {
                        m.StaffSignature = vehicleChecklist.StaffSignature;
                    }
                    else
                    {
                        if (StaffSign != null)
                        {
                            var image = await StaffSign.GetImageStreamAsync(SignatureImageFormat.Png);

                            if (image != null)
                            {
                                byte[] arr;

                                using (var ms = new MemoryStream())
                                {
                                    await image.CopyToAsync(ms);

                                    arr = ms.ToArray();
                                }

                                m.StaffSignature = arr;
                            }
                        }
                    }
                }
                else
                {
                    if (StaffSign != null)
                    {
                        var image = await StaffSign.GetImageStreamAsync(SignatureImageFormat.Png);

                        if (image != null)
                        {
                            byte[] arr;

                            using (var ms = new MemoryStream())
                            {
                                await image.CopyToAsync(ms);

                                arr = ms.ToArray();
                            }

                            m.StaffSignature = arr;
                        }
                    }
                }

                if (!String.IsNullOrEmpty(Id.Text))
                {
                    m.Id = Convert.ToInt32(Id.Text);

                    App.VehicleChecklistsDatabase.UpdateVehicleChecklist(m);

                    if (displayAlert)
                    {
                        ResetActivityIndicator();

                        await DisplayAlert("Saved", "This vehicle checklist has been saved successfully.", "Acknowledge");
                    }
                }
                else
                {
                    App.VehicleChecklistsDatabase.InsertVehicleChecklist(m);

                    await Navigation.PushAsync(new VehicleChecklist(m.Id));

                    Navigation.RemovePage(this);
                }
            }
            catch (Exception ex)
            {
                ResetActivityIndicator();

                await DisplayAlert("Error", "An error has occurred. " + ex.Message, "Acknowledge");
            }
        }
Пример #2
0
        private async void SaveDailyTimesheetToDatabase(Boolean displayAlert)
        {
            try
            {
                ApplyActivityIndicator();

                var staff          = App.StaffDatabase.GetStaffById(Convert.ToInt32(App.SettingsDatabase.GetSetting("AssignedStaffId").Value));
                var dailyTimesheet = App.DailyTimesheetsDatabase.GetDailyTimesheetById(Convert.ToInt32(Id.Text));

                var timeSpan = new TimeSpan(0, 0, 0, 0, 0);

                var m = new Models.DailyTimesheets()
                {
                    DailyMileage   = DailyMileage_Entry.Text,
                    Date           = Date_DatePicker.Date,
                    IsDeleted      = false,
                    LineItems      = null,
                    LunchEndTime   = null,
                    LunchStartTime = null,
                    MileageEnd     = MileageEnd_Entry.Text,
                    MileageStart   = MileageStart_Entry.Text,
                    OfficeId       = null,
                    SentToOffice   = false,
                    StaffId        = staff.Id,
                    StaffSignature = null,
                    CallOut        = CallOut_CheckBox.IsChecked,
                    TotalHours     = 0,
                    WeekNumber     = Weeks.GetISO8601WeekOfYear(Date_DatePicker.Date)
                };

                if (LunchEndTime_TimePicker.Time != timeSpan)
                {
                    m.LunchEndTime = LunchEndTime_TimePicker.Time;
                }

                if (LunchStartTime_TimePicker.Time != timeSpan)
                {
                    m.LunchStartTime = LunchStartTime_TimePicker.Time;
                }

                #region Line Items

                Decimal?totalHours = 0;

                var lineItems = new List <DailyTimesheetLineItemViewModel>();

                foreach (var item in ListItems.Children)
                {
                    if (item.GetType() == typeof(ListItems))
                    {
                        var items = (ListItems)item;

                        var section = items.GetItems();

                        if (section.JobNumber != 0 && section.JobHours != 0)
                        {
                            lineItems.Add(new DailyTimesheetLineItemViewModel()
                            {
                                ArriveSite  = section.ArriveSite,
                                SiteAddress = section.SiteAddress,
                                Comment     = section.Comment,
                                Complete    = section.Complete,
                                FinishJob   = section.FinishJob,
                                JobHours    = section.JobHours,
                                JobNumber   = section.JobNumber,
                                LeaveSite   = section.LeaveSite,
                                StartJob    = section.StartJob
                            });

                            totalHours = totalHours + section.JobHours;
                        }
                    }
                }

                m.TotalHours = totalHours ?? 0;

                m.LineItems = JsonConvert.SerializeObject(new
                {
                    DailyTimesheetLineItems = lineItems
                });

                #endregion

                if (dailyTimesheet != null)
                {
                    if (dailyTimesheet.StaffSignature != null)
                    {
                        m.StaffSignature = dailyTimesheet.StaffSignature;
                    }
                    else
                    {
                        if (StaffSign != null)
                        {
                            StaffSign_StackLayout.IsVisible = true;
                            var image = await StaffSign.GetImageStreamAsync(SignatureImageFormat.Png);

                            if (image != null)
                            {
                                byte[] arr;

                                using (var ms = new MemoryStream())
                                {
                                    await image.CopyToAsync(ms);

                                    arr = ms.ToArray();
                                }

                                m.StaffSignature = arr;
                            }
                        }
                    }
                }
                else
                {
                    if (StaffSign != null)
                    {
                        var image = await StaffSign.GetImageStreamAsync(SignatureImageFormat.Png);

                        if (image != null)
                        {
                            byte[] arr;

                            using (var ms = new MemoryStream())
                            {
                                await image.CopyToAsync(ms);

                                arr = ms.ToArray();
                            }

                            m.StaffSignature = arr;
                        }
                    }
                }

                if (!String.IsNullOrEmpty(Id.Text))
                {
                    m.Id = Convert.ToInt32(Id.Text);

                    App.DailyTimesheetsDatabase.UpdateDailyTimesheet(m);

                    if (displayAlert)
                    {
                        ResetActivityIndicator();

                        await DisplayAlert("Saved", "This daily timesheet has been saved successfully.", "Acknowledge");
                    }
                }
                else
                {
                    App.DailyTimesheetsDatabase.InsertDailyTimesheet(m);

                    await Navigation.PushAsync(new DailyTimesheet(m.Id));

                    Navigation.RemovePage(this);
                }
            }
            catch (Exception ex)
            {
                ResetActivityIndicator();

                await DisplayAlert("Error", "An error has occurred. " + ex.Message, "Acknowledge");
            }
        }