C# WindowsFormsApplication13.DataManager类代码示例

 public void get_all_remain_hoursTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     int expected = 0; // TODO: Initialize to an appropriate value
     int actual;
     actual = target.GetAllSprintRemainHours();
     Assert.AreEqual(expected, actual);
     Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void add_programmer_expected_work_hoursTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     int expected = 0;
     int actual;
     actual = target.add_programmer_expected_work_hours(6,4);
     Assert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void DateGetDayStatusTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     int expected = 1; // TODO: Initialize to an appropriate value
     int actual;
     DateTime day = DateTime.Parse("20.01.2013");
     actual = target.DateGetDayStatus(day);
     Assert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void Dateadd_new_dayTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     DateTime day = DateTime.Today;
     int status = 1;
     int expected = 0; // TODO: Initialize to an appropriate value
     int actual;
     actual = target.DateAddNewDay(day, status);
     Assert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void get_all_sprint_daysTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     DateTime[] expected = new DateTime[4]; // TODO: Initialize to an appropriate value
     expected[0] = DateTime.Parse("01.12.2012");
     expected[1] = DateTime.Parse("02.12.2012");
     expected[2] = DateTime.Parse("03.12.2012");
     expected[3] = DateTime.Parse("20.01.2013");
     DateTime[] actual;
     actual = target.GetAllSprintDays();
     CollectionAssert.AreEqual(expected, actual);
        // Assert.Inconclusive("Verify the correctness of this test method.");
 }

        private void ProgrammerToDB()
        {
            if (!IfProgrammerGreedChanged())
                return;

            DataManager dm = new DataManager();
            MathManager mm = new MathManager();
            int col = 3;
            int rows = programmerDataGridView.Rows.Count;
            string[] read = new string[col];
            for (int i = 0; i < rows - 1; i++)
            {
                for (int j = 0; j < col; j++)
                {
                    read[j] = programmerDataGridView.Rows[i].Cells[j + 1].Value.ToString();
                }
                /*for (int j = 0; j < col; j++)
                {
                    if (j == 2)
                        continue; // description might be null
                    if (read[j] == null)
                        return;
                }*/
                int programmer_ID = Convert.ToInt32(programmerDataGridView.Rows[i].Cells[0].Value.ToString());
                if (mm.isProgrammer_Id_Exist(programmer_ID) >= 0)
                { // task already exist, therefore we need only to update
                    if (mm.isProgrammerNameValid(read[0]) == true)
                    {
                        dm.ProgrammerUpdateProgrammerName(programmer_ID, read[0]);
                    }
                    else
                    {
                        MessageBox.Show("Invalid programmer name at line:" + (i + 1));
                        return;
                    }

                    dm.ProgrammerUpdateProgrammerExpectedWorkHours(programmer_ID,Convert.ToDouble(read[1]));
                    dm.ProgrammerUpdateProgrammerCurrentWorkHours(programmer_ID, Convert.ToDouble(read[2]));
                }
                else
                {
                    int ans = dm.ProgrammerAddNewProgrammer(read[0], Convert.ToInt32(read[1]), Convert.ToInt32(read[2]));
                    if (ans == -1)
                    {
                        MessageBox.Show("Error adding new programmer");
                        return;
                    }
                }
            }
        }

 public void SprintGetAllWorkingDaysTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     DateTime[] expected = new DateTime[3]; // TODO: Initialize to an appropriate value
     expected[0] = DateTime.Parse("1.12.12");
     expected[1] = DateTime.Parse("3.12.12");
     expected[2] = DateTime.Parse("20.1.13");
     DateTime[] actual;
     actual = target.SprintGetAllWorkingDays();
     CollectionAssert.AreEqual(expected, actual);
 }

 public void StorySetStoryDescriptionTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     int expected = 0;
     int actual;
     actual = target.StorySetStoryDescription(3, "hz");
     Assert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void Taskadd_new_taskTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     // int ID = 0; // TODO: Initialize to an appropriate value
     int Task_Owner = 1; // TODO: Initialize to an appropriate value
     int Story_ID = 3; // TODO: Initialize to an appropriate value
     string Description = " "; // TODO: Initialize to an appropriate value
     int Priority = 2; // TODO: Initialize to an appropriate value
     int expected = 0; // TODO: Initialize to an appropriate value
     int actual;
     actual = target.TaskAddNewTask(Story_ID, Priority, Description, Task_Owner);
     Assert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void WorkHoursGetProgrammerWorkHoursAllTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     float expected = 13; // TODO: Initialize to an appropriate value
     float actual;
     actual = target.WorkHoursGetProgrammerWorkHoursAll(1);
     Assert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void SprintGetRemainWorkingDaysTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     int expected = 1; // TODO: Initialize to an appropriate value
     int actual;
     actual = target.SprintGetRemainWorkingDays();
     Assert.AreEqual(expected, actual);
 }

 public void WorkHoursAddNewDayWorkHoursTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     float expected = 0; // TODO: Initialize to an appropriate value
     float actual;
     DateTime day = DateTime.Parse("1.12.12");
     actual = target.WorkHoursAddNewDayWorkHours(6,day);
     Assert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void WorkHoursGetAllSprintWorkHoursTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     float[] expected = {5,2,7}; // TODO: Initialize to an appropriate value
     float[] actual;
     actual = target.WorkHoursGetAllSprintWorkHours();
     CollectionAssert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void StoryGetStoriesIDForStoryOwnerTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     int[] expected = {3};
     int[] actual;
     actual = target.StoryGetStoriesIDForStoryOwner(6);
     CollectionAssert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }

 public void StoryGetStoryDemoDesTest()
 {
     DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
     string expected = "fignia";
     string actual;
     actual = target.StoryGetStoryDemoDes(3);
     Assert.AreEqual(expected, actual);
     //Assert.Inconclusive("Verify the correctness of this test method.");
 }