| public updateAlterations ( string cindID, string notes, int straps, int darts, int zipper, int mending, int takeIn, int bust, int hem, string fgID ) : void | ||
| cindID | string | Cinderella's ID |
| notes | string | notes |
| straps | int | Straps (Int used for bool value in DB) |
| darts | int | darts (Int used for bool value in DB) |
| zipper | int | zipper (Int used for bool value in DB) |
| mending | int | mending (Int used for bool value in DB) |
| takeIn | int | takeIn (Int used for bool value in DB) |
| bust | int | bust (Int used for bool value in DB) |
| hem | int | hem (Int used for bool value in DB) |
| fgID | string | Seamstress ID# |
| return | void | |
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");
}
}
