Автоматическое заполнение графика дежурств

protected void btRaspr_Click(object sender, EventArgs e)
        {
            int[] userlist = new int[4] { 1, 2, 3, 4 };
            int i = 0;
            DateTime DateIn = calendar1.SelectedDate;
            DateTime DateOut = calendar2.SelectedDate;
            DateTime apDate = DateIn;
            string Time = "10:00";
            int ScheduleType = 2;
            int Status = 20;
            SqlCommand command = new SqlCommand("", DBConnection.connection);
            while (apDate <= DateOut)
            {
                command.CommandText = "INSERT INTO [dbo].[Schedule] ([WorkDate],[TimeIn],[TimeOut],[User_ID],[ScheduleType_ID],[Status_ID]) values ('" + apDate.ToShortDateString() + "','" + Time + "','" + Time + "','" + userlist[i] + "','" + ScheduleType + "','" + Status + "')";
                try
                {
                    DBConnection.connection.Open();
                    command.ExecuteScalar();
                }
                catch
                {

                }
                finally
                {
                    DBConnection.connection.Close();
                }
              
                apDate = apDate.AddDays(1);
                i++;
                if (i == 4)
                {
                    i = 0;
                }
                

            }
        }