CinderellaMGS.SQL_Queries.setShiftStartEnd C# (CSharp) Method

        public void setShiftStartEnd(bool shiftStart, bool clear)
        {
            if (shiftStart)
            {
                if (clear)
                {
                    database.ExecuteQuery("UPDATE [CinderellaMGS].[dbo].[ConfigSettings] SET [PropertyValue]='' WHERE [appProperty]='shiftStart'");
                }

                else
                {
                    database.ExecuteQuery("UPDATE [CinderellaMGS].[dbo].[ConfigSettings] SET [PropertyValue]=CONVERT(VARCHAR, getDate(), 109) WHERE [appProperty]='shiftStart'");
                }
            }
            else//shiftEnd
            {
                if (clear)
                {
                    database.ExecuteQuery("UPDATE [CinderellaMGS].[dbo].[ConfigSettings] SET [PropertyValue]='' WHERE [appProperty]='shiftEnd'");
                }

                else
                {
                    database.ExecuteQuery("UPDATE [CinderellaMGS].[dbo].[ConfigSettings] SET [PropertyValue]=CONVERT(VARCHAR, getDate(), 109) WHERE [appProperty]='shiftEnd'");
                }
            }
        }