Ejemplo n.º 1
0
        public FarrowSow(int id)
        {
            InitializeComponent();

            // select the sow from the database using the id passed in the constructor
            using (SQLiteConnection conn = new SQLiteConnection(App.FilePath))
            {
                this.sow = conn.Table <Sow>().Where(x => x.ID == id).SingleOrDefault();
            }
        }
Ejemplo n.º 2
0
        public SowDetails(int id)
        {
            InitializeComponent();
            editMode = false;

            // using the id passed to this page, select the corresponding sow from the databases
            using (SQLiteConnection conn = new SQLiteConnection(App.FilePath))
            {
                this.sow = conn.Table <Sow>().Where(x => x.ID == id).SingleOrDefault();
            }
        }
Ejemplo n.º 3
0
        // Add Sow Button, adds a new sow to the database
        async void AddButtonClicked(object sender, EventArgs args)
        {
            // get user input from the form
            string   sowno     = SowNo.Text;
            string   knickname = KnickName.Text;
            DateTime farrowed  = SowFarrowedDate.Date;
            DateTime bred      = SowBredDate.Date;
            DateTime due       = bred.AddDays(113);
            DateTime usound    = bred.AddDays(27);

            // TODO: determine status
            // if farrowed date > bred date:
            //  status = "READY_TO_BREED"
            // if bred date > farrowed date:
            //  status = "BRED"
            // use sow.update() instead after the sow object has been created

            // create a sow object with the input
            // leav status empty as it will be determined by sow.update()
            Sow sow = new Sow()
            {
                SowNo          = sowno,
                KnickName      = knickname,
                FarrowedDate   = farrowed,
                BredDate       = bred,
                DueDate        = due,
                UltrasoundDate = usound,
            };

            sow.DetermineStatus();

            // insert sow into the database
            using (SQLiteConnection conn = new SQLiteConnection(App.FilePath))
            {
                conn.CreateTable <Sow>();
                int rowsAdded = conn.Insert(sow);
            }

            // return to the sows page
            await Navigation.PopAsync();
        }
Ejemplo n.º 4
0
        // temporary method for adding test data
        async void TestDataButtonClicked(object sender, EventArgs args)
        {
            // delete all sows
            using (SQLiteConnection conn = new SQLiteConnection(App.FilePath))
            {
                conn.CreateTable <Sow>();
                conn.CreateTable <Litter>();
                conn.CreateTable <Ultrasound>();

                conn.DeleteAll <Sow>();
                conn.DeleteAll <Litter>();
                conn.DeleteAll <Ultrasound>();

                // sows with statuses that need an action
                Sow sow1 = new Sow()
                {
                    SowNo     = "4352",
                    KnickName = "Jim"
                };
                sow1.DetermineStatus();
                Sow sow2 = new Sow()
                {
                    SowNo     = "4356",
                    KnickName = "Jimbo",
                    BredDate  = DateTime.Now.AddDays(-27),
                    Status    = "PENDING_ULTRASOUND"
                };
                Sow sow3 = new Sow()
                {
                    SowNo     = "4354",
                    KnickName = "Jimmy",
                    BredDate  = DateTime.Now.AddDays(-113)
                };
                sow3.DetermineStatus();

                // sows with status's that do not need to be actions
                Sow sow4 = new Sow()
                {
                    SowNo     = "4111",
                    KnickName = "Jarge",
                    BredDate  = DateTime.Now.AddDays(-10)
                };
                sow4.DetermineStatus();
                Sow sow5 = new Sow()
                {
                    SowNo     = "4222",
                    KnickName = "Yorg",
                    BredDate  = DateTime.Now.AddDays(-30)
                };
                sow5.DetermineStatus();
                Sow sow6 = new Sow()
                {
                    SowNo        = "4333",
                    KnickName    = "Gark",
                    BredDate     = DateTime.Now.AddDays(-150),
                    FarrowedDate = DateTime.Now.AddDays(-5)
                };
                sow6.DetermineStatus();

                int rowsAdded;
                rowsAdded = conn.Insert(sow1);
                rowsAdded = conn.Insert(sow2);
                rowsAdded = conn.Insert(sow3);
                rowsAdded = conn.Insert(sow4);
                rowsAdded = conn.Insert(sow5);
                rowsAdded = conn.Insert(sow6);
            }
        }