예제 #1
0
       public void RedrawGraph()
       {
           MathManager math = new MathManager();
           series1.Points.Clear();
           series2.Points.Clear();

           System.Windows.Forms.DataVisualization.Charting.DataPoint[] expectedPoints = new System.Windows.Forms.DataVisualization.Charting.DataPoint[2];
           System.Windows.Forms.DataVisualization.Charting.DataPoint[] realPoints = new System.Windows.Forms.DataVisualization.Charting.DataPoint[56];
           expectedPoints[0] = new System.Windows.Forms.DataVisualization.Charting.DataPoint(0D, 0D);
           expectedPoints[1] = new System.Windows.Forms.DataVisualization.Charting.DataPoint(0D, 0D);

           // updating points values of expected graph from DB

           math.updateEstimatedGraphPoints(expectedPoints);
           //System.Windows.Forms.DataVisualization.Charting.DataPoint[] realPoints = new System.Windows.Forms.DataVisualization.Charting.DataPoint[56];
           realPoints[0] = new System.Windows.Forms.DataVisualization.Charting.DataPoint(0D, 0D);/////////////////////////////////
           for (int i = 0; i < realPoints.Length; i++) // initalizating the realPoints values to zeros
           {
               realPoints[i] = new System.Windows.Forms.DataVisualization.Charting.DataPoint(0D, 0D);
           }

           math.updateRealGraphPoints(realPoints);

           series1.Points.Add(expectedPoints[0]);
           series1.Points.Add(expectedPoints[1]);

           series2.Points.Add(realPoints[0]);////////////////////////////////
           for (int i = 0; i < realPoints.Length; i++)
           {
               series2.Points.Add(realPoints[i]);
           }
           Refresh();
       }
예제 #2
0
        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;
                    }
                }
            }
        }
예제 #3
0
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.components = new System.ComponentModel.Container();
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
            System.Windows.Forms.DataVisualization.Charting.ChartArea chartArea1 = new System.Windows.Forms.DataVisualization.Charting.ChartArea();
            System.Windows.Forms.DataVisualization.Charting.Legend legend1 = new System.Windows.Forms.DataVisualization.Charting.Legend();
            System.Windows.Forms.DataVisualization.Charting.Series series1 = new System.Windows.Forms.DataVisualization.Charting.Series();
            // creating array of expected Points
            System.Windows.Forms.DataVisualization.Charting.DataPoint[] expectedPoints = new System.Windows.Forms.DataVisualization.Charting.DataPoint [2];
            // initalizating points values of expected graph
            expectedPoints[0] = new System.Windows.Forms.DataVisualization.Charting.DataPoint(0D, 0D);
            expectedPoints[1] = new System.Windows.Forms.DataVisualization.Charting.DataPoint(0D, 0D);

            // updating points values of expected graph from DB
            MathManager math = new MathManager();
            //math.updateEstimatedGraphPoints(expectedPoints);

            //System.Windows.Forms.DataVisualization.Charting.DataPoint dataPoint1 = new System.Windows.Forms.DataVisualization.Charting.DataPoint(0D, 500D);
            //System.Windows.Forms.DataVisualization.Charting.DataPoint dataPoint2 = new System.Windows.Forms.DataVisualization.Charting.DataPoint(30D, 0D);
            System.Windows.Forms.DataVisualization.Charting.Series series2 = new System.Windows.Forms.DataVisualization.Charting.Series();

            System.Windows.Forms.DataVisualization.Charting.DataPoint[] realPoints = new System.Windows.Forms.DataVisualization.Charting.DataPoint[56];
            realPoints[0] = new System.Windows.Forms.DataVisualization.Charting.DataPoint(0D, 0D);/////////////////////////////////
            /*for (int i = 0; i < realPoints.Length; i++) // initalizating the realPoints values to zeros
            {
                realPoints[i] = new System.Windows.Forms.DataVisualization.Charting.DataPoint(0D, 0D);
            }*/

            //math.updateRealGraphPoints(realPoints);

            this.database1DataSet1 = new WindowsFormsApplication13.Database1DataSet1();
            this.storyBindingSource = new System.Windows.Forms.BindingSource(this.components);
            this.storyTableAdapter = new WindowsFormsApplication13.Database1DataSet1TableAdapters.StoryTableAdapter();
            this.tableAdapterManager = new WindowsFormsApplication13.Database1DataSet1TableAdapters.TableAdapterManager();
            this.storyBindingNavigator = new System.Windows.Forms.BindingNavigator(this.components);
            this.bindingNavigatorAddNewItem = new System.Windows.Forms.ToolStripButton();
            this.bindingNavigatorCountItem = new System.Windows.Forms.ToolStripLabel();
            this.bindingNavigatorDeleteItem = new System.Windows.Forms.ToolStripButton();
            this.bindingNavigatorMoveFirstItem = new System.Windows.Forms.ToolStripButton();
            this.bindingNavigatorMovePreviousItem = new System.Windows.Forms.ToolStripButton();
            this.bindingNavigatorSeparator = new System.Windows.Forms.ToolStripSeparator();
            this.bindingNavigatorPositionItem = new System.Windows.Forms.ToolStripTextBox();
            this.bindingNavigatorSeparator1 = new System.Windows.Forms.ToolStripSeparator();
            this.bindingNavigatorMoveNextItem = new System.Windows.Forms.ToolStripButton();
            this.bindingNavigatorMoveLastItem = new System.Windows.Forms.ToolStripButton();
            this.bindingNavigatorSeparator2 = new System.Windows.Forms.ToolStripSeparator();
            this.storyBindingNavigatorSaveItem = new System.Windows.Forms.ToolStripButton();
            this.programmerBindingSource = new System.Windows.Forms.BindingSource(this.components);
            this.programmerTableAdapter = new WindowsFormsApplication13.Database1DataSet1TableAdapters.ProgrammerTableAdapter();
            this.sprintBindingSource = new System.Windows.Forms.BindingSource(this.components);
            this.sprintTableAdapter = new WindowsFormsApplication13.Database1DataSet1TableAdapters.SprintTableAdapter();
            this.storyDataGridView = new System.Windows.Forms.DataGridView();
            this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn4 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn5 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn6 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn7 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.tabControl = new System.Windows.Forms.TabControl();
            this.tabPage1 = new System.Windows.Forms.TabPage();
            this.tabPage2 = new System.Windows.Forms.TabPage();
            this.taskDataGridView = new System.Windows.Forms.DataGridView();
            this.dataGridViewTextBoxColumn8 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn9 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn10 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn11 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.dataGridViewTextBoxColumn12 = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.taskBindingSource = new System.Windows.Forms.BindingSource(this.components);
            this.tabPage3 = new System.Windows.Forms.TabPage();
            this.chart1 = new System.Windows.Forms.DataVisualization.Charting.Chart();
            this.tabPage4 = new System.Windows.Forms.TabPage();
            this.tabPage5 = new System.Windows.Forms.TabPage();
            this.dataGridView1 = new System.Windows.Forms.DataGridView();
            this.ColumnProgramerId = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.ColumnProgramerName = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.ColumnExpectedWorkingHouers = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.ColumnActualWorkingHours = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.ColumnRisk = new System.Windows.Forms.DataGridViewTextBoxColumn();
            this.menuStrip1 = new System.Windows.Forms.MenuStrip();
            this.teamToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.addMemberToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.removeMamberToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.teamSettingsToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.sprintToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.newSprintToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.editSprintToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.optionsToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.windowOptionsToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.taskTableAdapter = new WindowsFormsApplication13.Database1DataSet1TableAdapters.TaskTableAdapter();
            ((System.ComponentModel.ISupportInitialize)(this.database1DataSet1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.storyBindingSource)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.storyBindingNavigator)).BeginInit();
            this.storyBindingNavigator.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.programmerBindingSource)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sprintBindingSource)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.storyDataGridView)).BeginInit();
            this.tabControl.SuspendLayout();
            this.tabPage1.SuspendLayout();
            this.tabPage2.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.taskDataGridView)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.taskBindingSource)).BeginInit();
            this.tabPage3.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.chart1)).BeginInit();
            this.tabPage5.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
            this.menuStrip1.SuspendLayout();
            this.SuspendLayout();
            // 
            // database1DataSet1
            // 
            this.database1DataSet1.DataSetName = "Database1DataSet1";
            this.database1DataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
            // 
            // storyBindingSource
            // 
            this.storyBindingSource.DataMember = "Story";
            this.storyBindingSource.DataSource = this.database1DataSet1;
            // 
            // storyTableAdapter
            // 
            this.storyTableAdapter.ClearBeforeFill = true;
            // 
            // tableAdapterManager
            // 
            this.tableAdapterManager.BackupDataSetBeforeUpdate = false;
            this.tableAdapterManager.DateTableAdapter = null;
            this.tableAdapterManager.ProgrammerTableAdapter = null;
            this.tableAdapterManager.SprintTableAdapter = null;
            this.tableAdapterManager.Story_In_SprintTableAdapter = null;
            this.tableAdapterManager.StoryTableAdapter = this.storyTableAdapter;
            this.tableAdapterManager.TaskTableAdapter = null;
            this.tableAdapterManager.UpdateOrder = WindowsFormsApplication13.Database1DataSet1TableAdapters.TableAdapterManager.UpdateOrderOption.InsertUpdateDelete;
            this.tableAdapterManager.Work_hoursTableAdapter = null;
            // 
            // storyBindingNavigator
            // 
            this.storyBindingNavigator.AddNewItem = this.bindingNavigatorAddNewItem;
            this.storyBindingNavigator.BindingSource = this.storyBindingSource;
            this.storyBindingNavigator.CountItem = this.bindingNavigatorCountItem;
            this.storyBindingNavigator.DeleteItem = this.bindingNavigatorDeleteItem;
            this.storyBindingNavigator.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.bindingNavigatorMoveFirstItem,
            this.bindingNavigatorMovePreviousItem,
            this.bindingNavigatorSeparator,
            this.bindingNavigatorPositionItem,
            this.bindingNavigatorCountItem,
            this.bindingNavigatorSeparator1,
            this.bindingNavigatorMoveNextItem,
            this.bindingNavigatorMoveLastItem,
            this.bindingNavigatorSeparator2,
            this.bindingNavigatorAddNewItem,
            this.bindingNavigatorDeleteItem,
            this.storyBindingNavigatorSaveItem});
            this.storyBindingNavigator.Location = new System.Drawing.Point(0, 24);
            this.storyBindingNavigator.MoveFirstItem = this.bindingNavigatorMoveFirstItem;
            this.storyBindingNavigator.MoveLastItem = this.bindingNavigatorMoveLastItem;
            this.storyBindingNavigator.MoveNextItem = this.bindingNavigatorMoveNextItem;
            this.storyBindingNavigator.MovePreviousItem = this.bindingNavigatorMovePreviousItem;
            this.storyBindingNavigator.Name = "storyBindingNavigator";
            this.storyBindingNavigator.PositionItem = this.bindingNavigatorPositionItem;
            this.storyBindingNavigator.Size = new System.Drawing.Size(1055, 25);
            this.storyBindingNavigator.TabIndex = 0;
            this.storyBindingNavigator.Text = "bindingNavigator1";
            this.storyBindingNavigator.RefreshItems += new System.EventHandler(this.storyBindingNavigator_RefreshItems);
            // 
            // bindingNavigatorAddNewItem
            // 
            this.bindingNavigatorAddNewItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
            this.bindingNavigatorAddNewItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorAddNewItem.Image")));
            this.bindingNavigatorAddNewItem.Name = "bindingNavigatorAddNewItem";
            this.bindingNavigatorAddNewItem.RightToLeftAutoMirrorImage = true;
            this.bindingNavigatorAddNewItem.Size = new System.Drawing.Size(23, 22);
            this.bindingNavigatorAddNewItem.Text = "Add new";
            // 
            // bindingNavigatorCountItem
            // 
            this.bindingNavigatorCountItem.Name = "bindingNavigatorCountItem";
            this.bindingNavigatorCountItem.Size = new System.Drawing.Size(35, 22);
            this.bindingNavigatorCountItem.Text = "of {0}";
            this.bindingNavigatorCountItem.ToolTipText = "Total number of items";
            // 
            // bindingNavigatorDeleteItem
            // 
            this.bindingNavigatorDeleteItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
            this.bindingNavigatorDeleteItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorDeleteItem.Image")));
            this.bindingNavigatorDeleteItem.Name = "bindingNavigatorDeleteItem";
            this.bindingNavigatorDeleteItem.RightToLeftAutoMirrorImage = true;
            this.bindingNavigatorDeleteItem.Size = new System.Drawing.Size(23, 22);
            this.bindingNavigatorDeleteItem.Text = "Delete";
            // 
            // bindingNavigatorMoveFirstItem
            // 
            this.bindingNavigatorMoveFirstItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
            this.bindingNavigatorMoveFirstItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMoveFirstItem.Image")));
            this.bindingNavigatorMoveFirstItem.Name = "bindingNavigatorMoveFirstItem";
            this.bindingNavigatorMoveFirstItem.RightToLeftAutoMirrorImage = true;
            this.bindingNavigatorMoveFirstItem.Size = new System.Drawing.Size(23, 22);
            this.bindingNavigatorMoveFirstItem.Text = "Move first";
            // 
            // bindingNavigatorMovePreviousItem
            // 
            this.bindingNavigatorMovePreviousItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
            this.bindingNavigatorMovePreviousItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMovePreviousItem.Image")));
            this.bindingNavigatorMovePreviousItem.Name = "bindingNavigatorMovePreviousItem";
            this.bindingNavigatorMovePreviousItem.RightToLeftAutoMirrorImage = true;
            this.bindingNavigatorMovePreviousItem.Size = new System.Drawing.Size(23, 22);
            this.bindingNavigatorMovePreviousItem.Text = "Move previous";
            // 
            // bindingNavigatorSeparator
            // 
            this.bindingNavigatorSeparator.Name = "bindingNavigatorSeparator";
            this.bindingNavigatorSeparator.Size = new System.Drawing.Size(6, 25);
            // 
            // bindingNavigatorPositionItem
            // 
            this.bindingNavigatorPositionItem.AccessibleName = "Position";
            this.bindingNavigatorPositionItem.AutoSize = false;
            this.bindingNavigatorPositionItem.Name = "bindingNavigatorPositionItem";
            this.bindingNavigatorPositionItem.Size = new System.Drawing.Size(50, 23);
            this.bindingNavigatorPositionItem.Text = "0";
            this.bindingNavigatorPositionItem.ToolTipText = "Current position";
            // 
            // bindingNavigatorSeparator1
            // 
            this.bindingNavigatorSeparator1.Name = "bindingNavigatorSeparator1";
            this.bindingNavigatorSeparator1.Size = new System.Drawing.Size(6, 25);
            // 
            // bindingNavigatorMoveNextItem
            // 
            this.bindingNavigatorMoveNextItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
            this.bindingNavigatorMoveNextItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMoveNextItem.Image")));
            this.bindingNavigatorMoveNextItem.Name = "bindingNavigatorMoveNextItem";
            this.bindingNavigatorMoveNextItem.RightToLeftAutoMirrorImage = true;
            this.bindingNavigatorMoveNextItem.Size = new System.Drawing.Size(23, 22);
            this.bindingNavigatorMoveNextItem.Text = "Move next";
            // 
            // bindingNavigatorMoveLastItem
            // 
            this.bindingNavigatorMoveLastItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
            this.bindingNavigatorMoveLastItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMoveLastItem.Image")));
            this.bindingNavigatorMoveLastItem.Name = "bindingNavigatorMoveLastItem";
            this.bindingNavigatorMoveLastItem.RightToLeftAutoMirrorImage = true;
            this.bindingNavigatorMoveLastItem.Size = new System.Drawing.Size(23, 22);
            this.bindingNavigatorMoveLastItem.Text = "Move last";
            // 
            // bindingNavigatorSeparator2
            // 
            this.bindingNavigatorSeparator2.Name = "bindingNavigatorSeparator2";
            this.bindingNavigatorSeparator2.Size = new System.Drawing.Size(6, 25);
            // 
            // storyBindingNavigatorSaveItem
            // 
            this.storyBindingNavigatorSaveItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
            this.storyBindingNavigatorSaveItem.Image = ((System.Drawing.Image)(resources.GetObject("storyBindingNavigatorSaveItem.Image")));
            this.storyBindingNavigatorSaveItem.Name = "storyBindingNavigatorSaveItem";
            this.storyBindingNavigatorSaveItem.Size = new System.Drawing.Size(23, 22);
            this.storyBindingNavigatorSaveItem.Text = "Save Data";
            this.storyBindingNavigatorSaveItem.Click += new System.EventHandler(this.storyBindingNavigatorSaveItem_Click);
            // 
            // programmerBindingSource
            // 
            this.programmerBindingSource.DataMember = "Programmer";
            this.programmerBindingSource.DataSource = this.database1DataSet1;
            // 
            // programmerTableAdapter
            // 
            this.programmerTableAdapter.ClearBeforeFill = true;
            // 
            // sprintBindingSource
            // 
            this.sprintBindingSource.DataMember = "Sprint";
            this.sprintBindingSource.DataSource = this.database1DataSet1;
            // 
            // sprintTableAdapter
            // 
            this.sprintTableAdapter.ClearBeforeFill = true;
            // 
            // storyDataGridView
            // 
            this.storyDataGridView.AutoGenerateColumns = false;
            this.storyDataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.storyDataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
            this.dataGridViewTextBoxColumn1,
            this.dataGridViewTextBoxColumn2,
            this.dataGridViewTextBoxColumn3,
            this.dataGridViewTextBoxColumn4,
            this.dataGridViewTextBoxColumn5,
            this.dataGridViewTextBoxColumn6,
            this.dataGridViewTextBoxColumn7});
            this.storyDataGridView.DataSource = this.storyBindingSource;
            this.storyDataGridView.Dock = System.Windows.Forms.DockStyle.Fill;
            this.storyDataGridView.Location = new System.Drawing.Point(3, 3);
            this.storyDataGridView.Name = "storyDataGridView";
            this.storyDataGridView.Size = new System.Drawing.Size(1041, 485);
            this.storyDataGridView.TabIndex = 1;
            // 
            // dataGridViewTextBoxColumn1
            // 
            this.dataGridViewTextBoxColumn1.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.ColumnHeader;
            this.dataGridViewTextBoxColumn1.DataPropertyName = "Story_ID";
            this.dataGridViewTextBoxColumn1.HeaderText = "Story_ID";
            this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1";
            this.dataGridViewTextBoxColumn1.ReadOnly = true;
            this.dataGridViewTextBoxColumn1.Width = 73;
            // 
            // dataGridViewTextBoxColumn2
            // 
            this.dataGridViewTextBoxColumn2.DataPropertyName = "Story_Owner";
            this.dataGridViewTextBoxColumn2.HeaderText = "Story_Owner";
            this.dataGridViewTextBoxColumn2.Name = "dataGridViewTextBoxColumn2";
            // 
            // dataGridViewTextBoxColumn3
            // 
            this.dataGridViewTextBoxColumn3.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.ColumnHeader;
            this.dataGridViewTextBoxColumn3.DataPropertyName = "Story_Current_Sprint";
            this.dataGridViewTextBoxColumn3.HeaderText = "Story_Current_Sprint";
            this.dataGridViewTextBoxColumn3.Name = "dataGridViewTextBoxColumn3";
            this.dataGridViewTextBoxColumn3.Width = 129;
            // 
            // dataGridViewTextBoxColumn4
            // 
            this.dataGridViewTextBoxColumn4.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.ColumnHeader;
            this.dataGridViewTextBoxColumn4.DataPropertyName = "Story_Demo_DES";
            this.dataGridViewTextBoxColumn4.HeaderText = "Story_Demo_DES";
            this.dataGridViewTextBoxColumn4.Name = "dataGridViewTextBoxColumn4";
            this.dataGridViewTextBoxColumn4.Width = 118;
            // 
            // dataGridViewTextBoxColumn5
            // 
            this.dataGridViewTextBoxColumn5.DataPropertyName = "Story_Description";
            this.dataGridViewTextBoxColumn5.HeaderText = "Story_Description";
            this.dataGridViewTextBoxColumn5.Name = "dataGridViewTextBoxColumn5";
            // 
            // dataGridViewTextBoxColumn6
            // 
            this.dataGridViewTextBoxColumn6.DataPropertyName = "Story_Priority";
            this.dataGridViewTextBoxColumn6.HeaderText = "Story_Priority";
            this.dataGridViewTextBoxColumn6.Name = "dataGridViewTextBoxColumn6";
            // 
            // dataGridViewTextBoxColumn7
            // 
            this.dataGridViewTextBoxColumn7.DataPropertyName = "Story_Work_Status";
            this.dataGridViewTextBoxColumn7.HeaderText = "Story_Work_Status";
            this.dataGridViewTextBoxColumn7.Name = "dataGridViewTextBoxColumn7";
            // 
            // tabControl
            // 
            this.tabControl.Controls.Add(this.tabPage1);
            this.tabControl.Controls.Add(this.tabPage2);
            this.tabControl.Controls.Add(this.tabPage3);
            this.tabControl.Controls.Add(this.tabPage4);
            this.tabControl.Controls.Add(this.tabPage5);
            this.tabControl.Dock = System.Windows.Forms.DockStyle.Fill;
            this.tabControl.Location = new System.Drawing.Point(0, 49);
            this.tabControl.Name = "tabControl";
            this.tabControl.SelectedIndex = 0;
            this.tabControl.Size = new System.Drawing.Size(1055, 517);
            this.tabControl.TabIndex = 2;
            // 
            // tabPage1
            // 
            this.tabPage1.Controls.Add(this.storyDataGridView);
            this.tabPage1.Location = new System.Drawing.Point(4, 22);
            this.tabPage1.Name = "tabPage1";
            this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
            this.tabPage1.Size = new System.Drawing.Size(1047, 491);
            this.tabPage1.TabIndex = 0;
            this.tabPage1.Text = "Stories";
            this.tabPage1.UseVisualStyleBackColor = true;
            // 
            // tabPage2
            // 
            this.tabPage2.Controls.Add(this.taskDataGridView);
            this.tabPage2.Location = new System.Drawing.Point(4, 22);
            this.tabPage2.Name = "tabPage2";
            this.tabPage2.Padding = new System.Windows.Forms.Padding(3);
            this.tabPage2.Size = new System.Drawing.Size(1047, 491);
            this.tabPage2.TabIndex = 1;
            this.tabPage2.Text = "Tasks";
            this.tabPage2.UseVisualStyleBackColor = true;
            // 
            // taskDataGridView
            // 
            this.taskDataGridView.AutoGenerateColumns = false;
            this.taskDataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.taskDataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
            this.dataGridViewTextBoxColumn8,
            this.dataGridViewTextBoxColumn9,
            this.dataGridViewTextBoxColumn10,
            this.dataGridViewTextBoxColumn11,
            this.dataGridViewTextBoxColumn12});
            this.taskDataGridView.DataSource = this.taskBindingSource;
            this.taskDataGridView.Dock = System.Windows.Forms.DockStyle.Fill;
            this.taskDataGridView.Location = new System.Drawing.Point(3, 3);
            this.taskDataGridView.Name = "taskDataGridView";
            this.taskDataGridView.Size = new System.Drawing.Size(1041, 485);
            this.taskDataGridView.TabIndex = 0;
            // 
            // dataGridViewTextBoxColumn8
            // 
            this.dataGridViewTextBoxColumn8.DataPropertyName = "Task_ID";
            this.dataGridViewTextBoxColumn8.HeaderText = "Task_ID";
            this.dataGridViewTextBoxColumn8.Name = "dataGridViewTextBoxColumn8";
            this.dataGridViewTextBoxColumn8.ReadOnly = true;
            // 
            // dataGridViewTextBoxColumn9
            // 
            this.dataGridViewTextBoxColumn9.DataPropertyName = "Task_Story_ID";
            this.dataGridViewTextBoxColumn9.HeaderText = "Task_Story_ID";
            this.dataGridViewTextBoxColumn9.Name = "dataGridViewTextBoxColumn9";
            // 
            // dataGridViewTextBoxColumn10
            // 
            this.dataGridViewTextBoxColumn10.DataPropertyName = "Task_Priority";
            this.dataGridViewTextBoxColumn10.HeaderText = "Task_Priority";
            this.dataGridViewTextBoxColumn10.Name = "dataGridViewTextBoxColumn10";
            // 
            // dataGridViewTextBoxColumn11
            // 
            this.dataGridViewTextBoxColumn11.DataPropertyName = "Task_Description";
            this.dataGridViewTextBoxColumn11.HeaderText = "Task_Description";
            this.dataGridViewTextBoxColumn11.Name = "dataGridViewTextBoxColumn11";
            // 
            // dataGridViewTextBoxColumn12
            // 
            this.dataGridViewTextBoxColumn12.DataPropertyName = "Task_Ovner";
            this.dataGridViewTextBoxColumn12.HeaderText = "Task_Ovner";
            this.dataGridViewTextBoxColumn12.Name = "dataGridViewTextBoxColumn12";
            // 
            // taskBindingSource
            // 
            this.taskBindingSource.DataMember = "Task";
            this.taskBindingSource.DataSource = this.database1DataSet1;
            // 
            // tabPage3
            // 
            this.tabPage3.Controls.Add(this.chart1);
            this.tabPage3.Location = new System.Drawing.Point(4, 22);
            this.tabPage3.Name = "tabPage3";
            this.tabPage3.Padding = new System.Windows.Forms.Padding(3);
            this.tabPage3.Size = new System.Drawing.Size(1047, 491);
            this.tabPage3.TabIndex = 2;
            this.tabPage3.Text = "Sprint Proggress";
            this.tabPage3.UseVisualStyleBackColor = true;
            // 
            // chart1
            // 
            chartArea1.Area3DStyle.Enable3D = true;
            chartArea1.Area3DStyle.Inclination = 20;
            chartArea1.Area3DStyle.LightStyle = System.Windows.Forms.DataVisualization.Charting.LightStyle.Realistic;
            chartArea1.Area3DStyle.PointDepth = 30;
            chartArea1.Area3DStyle.PointGapDepth = 10;
            chartArea1.Name = "ChartArea1";
            this.chart1.ChartAreas.Add(chartArea1);
            legend1.Name = "Legend1";
            this.chart1.Legends.Add(legend1);
            this.chart1.Location = new System.Drawing.Point(40, 22);
            this.chart1.Name = "chart1";
            series1.ChartArea = "ChartArea1";
            series1.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
            series1.Legend = "Legend1";
            series1.Name = "Expected Progress";


            series1.Points.Add(expectedPoints[0]);
            series1.Points.Add(expectedPoints[1]);
            
            series2.ChartArea = "ChartArea1";
            series2.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
            series2.Legend = "Legend1";
            series2.Name = "Real Progress";
            series2.Points.Add(realPoints[0]);////////////////////////////////
            /*for (int i = 0; i < realPoints.Length; i++)
            {
                series2.Points.Add(realPoints[i]);
            }*/
            this.chart1.Series.Add(series1);
            this.chart1.Series.Add(series2);
            this.chart1.Size = new System.Drawing.Size(896, 401);
            this.chart1.TabIndex = 0;
            this.chart1.Text = "chart1";
            // 
            // tabPage4
            // 
            this.tabPage4.Location = new System.Drawing.Point(4, 22);
            this.tabPage4.Name = "tabPage4";
            this.tabPage4.Padding = new System.Windows.Forms.Padding(3);
            this.tabPage4.Size = new System.Drawing.Size(1047, 491);
            this.tabPage4.TabIndex = 3;
            this.tabPage4.Text = "Story Proggress";
            this.tabPage4.UseVisualStyleBackColor = true;
            // 
            // tabPage5
            // 
            this.tabPage5.Controls.Add(this.dataGridView1);
            this.tabPage5.Location = new System.Drawing.Point(4, 22);
            this.tabPage5.Name = "tabPage5";
            this.tabPage5.Padding = new System.Windows.Forms.Padding(3);
            this.tabPage5.Size = new System.Drawing.Size(1047, 491);
            this.tabPage5.TabIndex = 4;
            this.tabPage5.Text = "Summery";
            this.tabPage5.UseVisualStyleBackColor = true;
            // 
            // dataGridView1
            // 
            this.dataGridView1.AllowUserToAddRows = false;
            this.dataGridView1.AllowUserToDeleteRows = false;
            this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
            this.ColumnProgramerId,
            this.ColumnProgramerName,
            this.ColumnExpectedWorkingHouers,
            this.ColumnActualWorkingHours,
            this.ColumnRisk});
            this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.dataGridView1.Location = new System.Drawing.Point(3, 3);
            this.dataGridView1.Name = "dataGridView1";
            this.dataGridView1.ReadOnly = true;
            this.dataGridView1.Size = new System.Drawing.Size(1041, 485);
            this.dataGridView1.TabIndex = 0;
            // 
            // ColumnProgramerId
            // 
            this.ColumnProgramerId.HeaderText = "Column1";
            this.ColumnProgramerId.Name = "ColumnProgramerId";
            this.ColumnProgramerId.ReadOnly = true;
            this.ColumnProgramerId.Visible = false;
            // 
            // ColumnProgramerName
            // 
            this.ColumnProgramerName.HeaderText = "Name";
            this.ColumnProgramerName.Name = "ColumnProgramerName";
            this.ColumnProgramerName.ReadOnly = true;
            // 
            // ColumnExpectedWorkingHouers
            // 
            this.ColumnExpectedWorkingHouers.HeaderText = "Expected Working Houers";
            this.ColumnExpectedWorkingHouers.Name = "ColumnExpectedWorkingHouers";
            this.ColumnExpectedWorkingHouers.ReadOnly = true;
            // 
            // ColumnActualWorkingHours
            // 
            this.ColumnActualWorkingHours.HeaderText = "Actual Working Hours";
            this.ColumnActualWorkingHours.Name = "ColumnActualWorkingHours";
            this.ColumnActualWorkingHours.ReadOnly = true;
            // 
            // ColumnRisk
            // 
            this.ColumnRisk.HeaderText = "Risk";
            this.ColumnRisk.Name = "ColumnRisk";
            this.ColumnRisk.ReadOnly = true;
            // 
            // menuStrip1
            // 
            this.menuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.teamToolStripMenuItem,
            this.sprintToolStripMenuItem,
            this.optionsToolStripMenuItem});
            this.menuStrip1.Location = new System.Drawing.Point(0, 0);
            this.menuStrip1.Name = "menuStrip1";
            this.menuStrip1.Size = new System.Drawing.Size(1055, 24);
            this.menuStrip1.TabIndex = 3;
            this.menuStrip1.Text = "menuStrip1";
            // 
            // teamToolStripMenuItem
            // 
            this.teamToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.addMemberToolStripMenuItem,
            this.removeMamberToolStripMenuItem,
            this.teamSettingsToolStripMenuItem});
            this.teamToolStripMenuItem.Name = "teamToolStripMenuItem";
            this.teamToolStripMenuItem.Size = new System.Drawing.Size(49, 20);
            this.teamToolStripMenuItem.Text = "Team";
            // 
            // addMemberToolStripMenuItem
            // 
            this.addMemberToolStripMenuItem.Name = "addMemberToolStripMenuItem";
            this.addMemberToolStripMenuItem.Size = new System.Drawing.Size(165, 22);
            this.addMemberToolStripMenuItem.Text = "Add member";
            this.addMemberToolStripMenuItem.Click += new System.EventHandler(this.addMemberToolStripMenuItem_Click);
            // 
            // removeMamberToolStripMenuItem
            // 
            this.removeMamberToolStripMenuItem.Name = "removeMamberToolStripMenuItem";
            this.removeMamberToolStripMenuItem.Size = new System.Drawing.Size(165, 22);
            this.removeMamberToolStripMenuItem.Text = "Remove mamber";
            // 
            // teamSettingsToolStripMenuItem
            // 
            this.teamSettingsToolStripMenuItem.Name = "teamSettingsToolStripMenuItem";
            this.teamSettingsToolStripMenuItem.Size = new System.Drawing.Size(165, 22);
            this.teamSettingsToolStripMenuItem.Text = "Team settings";
            this.teamSettingsToolStripMenuItem.Click += new System.EventHandler(this.teamSettingsToolStripMenuItem_Click);
            // 
            // sprintToolStripMenuItem
            // 
            this.sprintToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.newSprintToolStripMenuItem,
            this.editSprintToolStripMenuItem});
            this.sprintToolStripMenuItem.Name = "sprintToolStripMenuItem";
            this.sprintToolStripMenuItem.Size = new System.Drawing.Size(50, 20);
            this.sprintToolStripMenuItem.Text = "Sprint";
            // 
            // newSprintToolStripMenuItem
            // 
            this.newSprintToolStripMenuItem.Name = "newSprintToolStripMenuItem";
            this.newSprintToolStripMenuItem.Size = new System.Drawing.Size(132, 22);
            this.newSprintToolStripMenuItem.Text = "New Sprint";
            this.newSprintToolStripMenuItem.Click += new System.EventHandler(this.newSprintToolStripMenuItem_Click);
            // 
            // editSprintToolStripMenuItem
            // 
            this.editSprintToolStripMenuItem.Name = "editSprintToolStripMenuItem";
            this.editSprintToolStripMenuItem.Size = new System.Drawing.Size(132, 22);
            this.editSprintToolStripMenuItem.Text = "Edit Sprint";
            // 
            // optionsToolStripMenuItem
            // 
            this.optionsToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.windowOptionsToolStripMenuItem});
            this.optionsToolStripMenuItem.Name = "optionsToolStripMenuItem";
            this.optionsToolStripMenuItem.Size = new System.Drawing.Size(61, 20);
            this.optionsToolStripMenuItem.Text = "Options";
            // 
            // windowOptionsToolStripMenuItem
            // 
            this.windowOptionsToolStripMenuItem.Name = "windowOptionsToolStripMenuItem";
            this.windowOptionsToolStripMenuItem.Size = new System.Drawing.Size(161, 22);
            this.windowOptionsToolStripMenuItem.Text = "Window options";
            // 
            // taskTableAdapter
            // 
            this.taskTableAdapter.ClearBeforeFill = true;
            // 
            // Form1
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(1055, 566);
            this.Controls.Add(this.tabControl);
            this.Controls.Add(this.storyBindingNavigator);
            this.Controls.Add(this.menuStrip1);
            this.MainMenuStrip = this.menuStrip1;
            this.Name = "Form1";
            this.Text = "2";
            this.Load += new System.EventHandler(this.Form1_Load);
            ((System.ComponentModel.ISupportInitialize)(this.database1DataSet1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.storyBindingSource)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.storyBindingNavigator)).EndInit();
            this.storyBindingNavigator.ResumeLayout(false);
            this.storyBindingNavigator.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.programmerBindingSource)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sprintBindingSource)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.storyDataGridView)).EndInit();
            this.tabControl.ResumeLayout(false);
            this.tabPage1.ResumeLayout(false);
            this.tabPage2.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.taskDataGridView)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.taskBindingSource)).EndInit();
            this.tabPage3.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.chart1)).EndInit();
            this.tabPage5.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
            this.menuStrip1.ResumeLayout(false);
            this.menuStrip1.PerformLayout();
            this.ResumeLayout(false);
            this.PerformLayout();

        }
예제 #4
0
        private void TaskToDB()
        {
            if (!IfTaskGreedChanged())
                return;

            DataManager dm = new DataManager();
            MathManager mm = new MathManager();
            //int col = 4;
            //int rows = taskDataGridView.Rows.Count;
            //int col;
            int rows;

            if (Convert.ToInt32(updatedTaskIndexes.Count.ToString()) == 0) // no changes were found, there fore no need to save any data
                return;

            //string[] read = new string[4];

            for(int i = 0; i < Convert.ToInt32(updatedTaskIndexes.Count.ToString()); i++)
                {
                    rows = updatedTaskIndexes.ElementAt(i).getRow();
                    int task_ID = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[1].Value.ToString());
                    if (mm.isTask_Id_Exist(task_ID) >= 0)
                    { //     task already exist, therefore we need only to update
                        int storyId = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[0].Value.ToString());
                        if (mm.isTask_Story_IDValid(storyId) >= 0)
                        {
                            int ans = dm.TaskSetTaskStoryID(task_ID, storyId);
                        }
                        else
                        {
                            MessageBox.Show("Invalid Story id at line:" + (rows + 1));
                            updatedTaskIndexes.RemoveAt(i);
                            return;
                        }

                        int priority = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[2].Value.ToString());
                        if (mm.isTask_PriorityValid(priority) >= 0)
                        {
                            dm.TaskSetTaskPriority(task_ID, priority);
                        }
                        else
                        {
                            MessageBox.Show("Invalid Priority value at line:" + (rows + 1));
                            updatedTaskIndexes.RemoveAt(i);
                            return;
                        }

                        string descriptions = taskDataGridView.Rows[rows].Cells[5].Value.ToString();
                        dm.TaskSetTaskDescription(task_ID, descriptions);

                        int ownerId = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[3].Value.ToString());
                        if (mm.isTask_Ovner_IdValid(ownerId) >= 0)
                        {
                            dm.TaskSetTaskOwner(task_ID, ownerId);
                        }
                        else
                        {
                            MessageBox.Show("Invalid Owner Id at line:" + (rows + 1));
                            updatedTaskIndexes.RemoveAt(i);
                            return;
                        }
                    }
                    else
                    {
                        int storyId = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[0].Value.ToString());
                        int priority = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[2].Value.ToString());
                        string descriptions = taskDataGridView.Rows[rows].Cells[5].Value.ToString();
                        int ownerId = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[3].Value.ToString());

                        int ans = dm.TaskAddNewTask(storyId, priority, descriptions,
                                                    ownerId);

                        MessageBox.Show("Added");
                        if (ans == -1)
                        {
                            MessageBox.Show("Error while creating new task");
                            updatedTaskIndexes.RemoveAt(i);
                            return;
                        }
                    }
            }
            int size = Convert.ToInt32(updatedTaskIndexes.Count.ToString());
            for (int i = 0; i < size; i++)
            {
                updatedTaskIndexes.RemoveAt(0);
            }
        }
예제 #5
0
        private void StoryToDb()
        {
            //systemId = storydataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["SystemId"].Value.ToString();
            string id = storyDataGridView.Rows[0].Cells[0].Value.ToString();

            if (!IfStoryGreedChanged())
                return;
            DataManager dm = new DataManager();
            MathManager mm = new MathManager();

            int rows;

            if (Convert.ToInt32(updatedStoryIndexes.Count.ToString()) == 0) // no changes were found, there fore no need to save any data
                return;

            //string[] read = new string[4];

            for(int i = 0; i < Convert.ToInt32(updatedStoryIndexes.Count.ToString()); i++)
                {
                    rows = updatedStoryIndexes.ElementAt(i).getRow();
                    //MessageBox.Show("6: " + storyDataGridView.Rows[rows].Cells[6].Value.ToString() + "1: " + storyDataGridView.Rows[rows].Cells[1].Value.ToString());
                    int story_ID = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[0].Value.ToString());
                    if (mm.isStory_Id_Exist(story_ID) >= 0)
                    {
                        int programmerID = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[2].Value.ToString());
                        if (mm.isProgrammer_Id_Exist(Convert.ToInt32(programmerID)) >= 0)
                        {
                            dm.StorySetOwnerID(story_ID, programmerID);
                        }
                        else
                        {
                            MessageBox.Show("Invalid story owner ID at line: " + (rows + 1));
                            return;
                        }
                        // if (mm.isStory_current_Sprint_valid(DateTime.Parse(read[1])) >= 0)
                        //{
                        dm.StorySetCurrentSprint(story_ID, DateTime.Parse(storyDataGridView.Rows[rows].Cells[3].Value.ToString()));
                        //}
                        /*else
                        {
                            MessageBox.Show("Invalid date of story_current_sprint at line: " + (i + 1));
                            return;
                        }*/
                        //dm.StorySetStoryDemoDes(story_ID, storyDataGridView.Rows[rows].Cells[4].Value.ToString());
                        //dm.StorySetStoryDemoPic(story_ID);
                        dm.StorySetStoryDescription(story_ID, storyDataGridView.Rows[rows].Cells[6].Value.ToString());
                        //MessageBox.Show("Passed here");
                        int priority = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[1].Value.ToString());
                        if (mm.isTask_PriorityValid(priority) >= 0)
                        {
                            dm.StorySetStoryPriority(story_ID, priority);
                        }
                        else
                        {
                            MessageBox.Show("Invalid priority value at line: " + (rows + 1));
                            return;
                        }
                        int workStatus = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[7].Value.ToString());
                        dm.StorySetStoryWorkStatus(story_ID, workStatus);
                    }
                    else
                    {
                        int workStatus = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[7].Value.ToString());
                        int priority = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[1].Value.ToString());

                        int programmerID = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[2].Value.ToString());

                        int ans = dm.StoryAddNewStory(programmerID, DateTime.Parse(storyDataGridView.Rows[rows].Cells[3].Value.ToString()), storyDataGridView.Rows[rows].Cells[4].Value.ToString(), null, storyDataGridView.Rows[rows].Cells[6].Value.ToString(),
                                                     priority, workStatus);
                        if (ans == -1)
                        {
                            MessageBox.Show("Error while creating new story");
                            return;
                        }
                    }
                }
        }