CinderellasInAlteration() public method

displays the cinderellas that are currently in alterations (status of 6) and their end time of their alterations is null, indicating that the dress has not been completed in alterations. (currently being worked on or if more time is needed.)
public CinderellasInAlteration ( ) : string
return string
SQL_Queries Class Documentation
Beispiel #1
0
        private void submitButton_Click(object sender, EventArgs e)
        {
            try
            {

                string id = alterationsCinderellasDGV.SelectedRows[0].Cells[0].Value.ToString();

                // Only way I could find to do this, seems somewhat odd...
                DataRow selectedDataRow = ((DataRowView)alteratorsDropDownList.SelectedItem).Row;
                alterator = selectedDataRow["id"].ToString();

                int iZipper = Convert.ToInt32(zipper);
                int iBust = Convert.ToInt32(bust);
                int iDarts = Convert.ToInt32(darts);
                int iMending = Convert.ToInt32(mending);
                int iTakeIn = Convert.ToInt32(takeIn);
                int iHem = Convert.ToInt32(hem);
                int iStraps = Convert.ToInt32(straps);

                notes = notesTextBox.Text;
                SQL_Queries dbMagic = new SQL_Queries();
                string query = dbMagic.checkAlterations(id);
                SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);

                SqlCommand command = new SqlCommand(query, conn);
                conn.Open();
                SqlDataReader reader = command.ExecuteReader();

                bool exists = false;
                int rowCount = 0;
                while (reader.Read())
                {

                    rowCount++;
                }

                if (rowCount == 1)
                {
                    dbMagic.updateAlterations(id, notes, iStraps, iDarts, iZipper, iMending, iTakeIn, iBust, iHem, alterator);
                }
                else
                {
                    dbMagic.addAlterations(id);
                }

                alterationsCinderellasDGV.ClearSelection();
                strapsCheckBox.Checked = false;
                zipperCheckBox.Checked = false;
                bustCheckBox.Checked = false;
                dartsCheckBox.Checked = false;
                generalMendingCheckBox.Checked = false;
                generalTakeInCheckBox.Checked = false;
                hemCheckBox.Checked = false;
                notesTextBox.Text = "";

                //refresh left gridview
                SqlCommand refreshCommandAlt = new SqlCommand(dbMagic.CinderellasInAlteration());
                alterationsCinderellasDGVBindingSource.EndEdit();
                alterationsCinderellasDGVDataTable.Clear();

                alterationsCinderellasDGVDataAdapter.SelectCommand = refreshCommandAlt;
                alterationsCinderellasDGVDataAdapter.SelectCommand.Connection = connection;

                alterationsCinderellasDGVDataTable.Locale = System.Globalization.CultureInfo.InvariantCulture;
                alterationsCinderellasDGVDataAdapter.Fill(alterationsCinderellasDGVDataTable);

                alterationsCinderellasDGV.Refresh();
                alterationsCinderellasDGV.ClearSelection();
                // alterationsCinderellasDGV.AutoResizeColumns();
            }

            catch (Exception error)
            {
                MessageBox.Show("Input not valid");
            }
        }