private void StoreData(Image inputFace, string PersonName) { if (DbConnection.State.Equals(ConnectionState.Closed)) { DbConnection.Open(); try { byte[] FaceAsByte = ConverImageToByte(inputFace); RowPosition = LocalDataTable.Rows.Count; RowPosition++; MessageBox.Show("Saving Image at Index:" + RowPosition.ToString()); SqlCommand InsertCommand = new SqlCommand("INSERT INTO pictureData (ImageID, Image, PersonName) VALUES('" + RowPosition.ToString() + "',@MyImage,'" + PersonName + "' )", DbConnection); // InsertCommand.Parameters.AddWithValue("@MyImage", inputFace); SqlParameter imageParameter = InsertCommand.Parameters.AddWithValue("@MyImage", inputFace); imageParameter.Value = FaceAsByte; imageParameter.Size = FaceAsByte.Length; int rowAffected = InsertCommand.ExecuteNonQuery(); MessageBox.Show("Image Data Successfully Uploaded in " + rowAffected.ToString() + "row"); RowPosition++; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); MessageBox.Show(ex.StackTrace.ToString()); } finally { refreshDBconnection(); } } }
public string CreateEntryDataSaveLine(string data_separator) { //we want // ent-data;entry-id=geog_222;title=GEOG 222;subtitle=Introduction to Geomatics;colour=#FFFF7272;prerequisites=[]; // corequisites=[];avail-col-ids=[20_fa,21_wi,21_fa,22_wi,22_fa,23_wi,23_fa,24_wi];set-col-id=;list-pos=0 Debug.WriteLine("CreateEntryDataSaveLine"); string return_data_line; string data_line_start = "ent-data"; return_data_line = data_line_start; foreach (string cur_data_parameter in Parameter_Names) { //should be like this // Parameter_Names = { "Entry_ProjectName", "EntryID", "Title", "Subtitle", // "ColourHex", "PrereqEntryIDs", "CoreqEntryIDs", "AvailColIDs", "SetColID", "RowPosition" }; // Parameter_Save_Names = { "", "entry-id", "title", "subtitle", // "colour", "prerequisites", "corequisites", "avail-col-ids", "set-col-id", "list-pos" }; //this one is skipped if (cur_data_parameter == "Col_ProjectName") { continue; } string cur_data_addition = ""; string cur_data_save_name = Parameter_Save_Names[Parameter_Names.IndexOf(cur_data_parameter)]; string data_val = ""; switch (cur_data_parameter) { case "EntryID": data_val = EntryID.ToString(); break; case "Title": data_val = Title.ToString(); break; case "Subtitle": data_val = Subtitle.ToString(); break; case "ColourHex": data_val = ColourHex.ToString(); break; case "PrereqEntryIDs": data_val = FormattedSaveDataFromList(PrereqEntryIDs); break; case "CoreqEntryIDs": data_val = FormattedSaveDataFromList(CoreqEntryIDs); break; case "AvailColIDs": data_val = FormattedSaveDataFromList(AvailColIDs); break; case "SetColID": data_val = SetColID.ToString(); break; case "RowPosition": data_val = RowPosition.ToString(); break; } cur_data_addition = string.Format("{0}={1}", cur_data_save_name, data_val); return_data_line += data_separator + cur_data_addition; } return(return_data_line); }
public void PrintEntryDataValues() { Debug.WriteLine("\nEntryData class paramters:"); foreach (string cur_param_name in Parameter_Names) { bool basic_formatting = false; bool list_formatting = false; string cur_param_val = ""; List <string> cur_param_lst = new List <string>(); switch (cur_param_name) { case "Entry_ProjectName": cur_param_val = Entry_ProjectName.ToString(); basic_formatting = true; break; case "EntryID": cur_param_val = EntryID.ToString(); basic_formatting = true; break; case "Title": cur_param_val = Title.ToString(); basic_formatting = true; break; case "Subtitle": cur_param_val = Subtitle.ToString(); basic_formatting = true; break; case "ColourHex": cur_param_val = ColourHex.ToString(); basic_formatting = true; break; case "PrereqEntryIDs": cur_param_lst = PrereqEntryIDs; list_formatting = true; break; case "CoreqEntryIDs": cur_param_lst = CoreqEntryIDs; list_formatting = true; break; case "SetColID": cur_param_val = SetColID.ToString(); basic_formatting = true; break; case "ActualColID": cur_param_val = ActualColID.ToString(); basic_formatting = true; break; case "RowPosition": cur_param_val = RowPosition.ToString(); basic_formatting = true; break; case "ColPosition": cur_param_val = ColPosition.ToString(); basic_formatting = true; break; case "AvailColIDs": cur_param_lst = AvailColIDs; list_formatting = true; break; case "Is_Selected": cur_param_val = Is_Selected.ToString(); basic_formatting = true; break; } if (basic_formatting) { Debug.WriteLine(string.Format(" {0,-18} = {1}", cur_param_name, cur_param_val)); } if (list_formatting) { Debug.Write(string.Format(" {0,-18} = ", cur_param_name)); foreach (string cur_val in cur_param_lst) { Debug.Write(string.Format("{0} ", cur_val)); } Debug.WriteLine(""); } } Debug.WriteLine(""); }