1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
command.Parameters.Add(new SqlParameter("@ID_project", SqlDbType.NVarChar, 50));
command.Parameters.Add(new SqlParameter("@Duration_Estimate_PH_0", SqlDbType.Float));
command.Parameters.Add(new SqlParameter("@Duration_Estimate_PH_1", SqlDbType.Float));
command.Parameters.Add(new SqlParameter("@Duration_Estimate_PH_2", SqlDbType.Float));
command.Parameters.Add(new SqlParameter("@Duration_Estimate_PH_3", SqlDbType.Float));
command.Parameters.Add(new SqlParameter("@Duration_Estimate_at_Completion", SqlDbType.Float));
command.Parameters.Add(new SqlParameter("@ETM_PH_0_", SqlDbType.Float));
command.Parameters.Add(new SqlParameter("@ETM_PH_1_", SqlDbType.Float));
command.Parameters.Add(new SqlParameter("@ETM_PH_2_", SqlDbType.Float));
command.Parameters.Add(new SqlParameter("@ETM_PH_3_", SqlDbType.Float));
command.Parameters["@ID_project"].Value = textBox_project_name.Text;
command.Parameters["@Duration_Estimate_PH_0"].Value = textBox_Duration_Estimate_PH_0.Text;
command.Parameters["@Duration_Estimate_PH_1"].Value = textBox_Duration_Estimate_PH_1.Text;
command.Parameters["@Duration_Estimate_PH_2"].Value = textBox_Duration_Estimate_PH_2.Text;
command.Parameters["@Duration_Estimate_PH_3"].Value = textBox_Duration_Estimate_PH_3.Text;
command.Parameters["@Duration_Estimate_at_Completion"].Value = textBox_Duration_Dstimate_at_Completion.Text;
command.Parameters["@ETM_PH_0_"].Value = textBox_ETM_Phase_0.Text;
command.Parameters["@ETM_PH_1_"].Value = textBox_ETM_Phase_1.Text;
command.Parameters["@ETM_PH_2_"].Value = textBox_ETM_Phase_2.Text;
command.Parameters["@ETM_PH_3_"].Value = textBox_ETM_Phase_3.Text;
Convert.ToDouble(textBox_Duration_Estimate_PH_0.Text, CultureInfo.InvariantCulture);
Convert.ToDouble(textBox_Duration_Estimate_PH_1.Text, CultureInfo.InvariantCulture);
Convert.ToDouble(textBox_Duration_Estimate_PH_2.Text, CultureInfo.InvariantCulture);
Convert.ToDouble(textBox_Duration_Estimate_PH_3.Text, CultureInfo.InvariantCulture);
Convert.ToDouble(textBox_Duration_Dstimate_at_Completion.Text, CultureInfo.InvariantCulture);
Convert.ToDouble(textBox_ETM_Phase_0.Text, CultureInfo.InvariantCulture);
Convert.ToDouble(textBox_ETM_Phase_1.Text, CultureInfo.InvariantCulture);
Convert.ToDouble(textBox_ETM_Phase_2.Text, CultureInfo.InvariantCulture);
Convert.ToDouble(textBox_ETM_Phase_3.Text, CultureInfo.InvariantCulture);
command.ExecuteNonQuery(); |
Partager