public IEnumerable <ILatchModel> GetAll() { List <LatchModel> latchModelList = new List <LatchModel>(); using (MySqlConnection connection = new MySqlConnection(_connString)) { try { string queryString = "SELECT * FROM sql_latch_tests1.latches"; connection.Open(); using (MySqlCommand command = new MySqlCommand(queryString, connection)) using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { LatchModel model = new LatchModel(); model.ComponentID = Int32.Parse(reader["component_id"].ToString()); model.LatchID = Int32.Parse(reader["latch_id"].ToString()); model.Type = reader["type"].ToString(); latchModelList.Add(model); } } } catch (MySqlException ex) { throw new Exception(ex.Message.ToString(), ex); } finally { connection.Close(); } return(latchModelList); } }
// Introducing changes to db data private void BtnSubmitChanges_Click(object sender, EventArgs e) { try { foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[0].Value == null) { return; } switch (currentView) { case View.Component: CompModel componentModel = new CompModel(); componentModel.ComponentID = Convert.ToInt32(row.Cells[0].Value); componentModel.Type = row.Cells[1].Value.ToString(); componentModel.Status = Convert.ToBoolean(row.Cells[2].Value); componentRepository.Update(componentModel); break; case View.Latch: LatchModel latchModel = new LatchModel(); latchModel.LatchID = Convert.ToInt32(row.Cells[0].Value); latchModel.Type = row.Cells[1].Value.ToString(); latchModel.ComponentID = Convert.ToInt32(row.Cells[2].Value); latchRepository.Update(latchModel); break; case View.Test: TestModel testModel = new TestModel(); testModel.TestID = Convert.ToInt32(row.Cells[0].Value); testModel.LatchID = Convert.ToInt32(row.Cells[1].Value); testModel.EndTime = Convert.ToDateTime(row.Cells[2].Value); testModel.Date = Convert.ToDateTime(row.Cells[3].Value); testModel.Status = Convert.ToBoolean(row.Cells[4].Value); testModel.Cycles = Convert.ToInt32(row.Cells[5].Value); testModel.VideoLink = row.Cells[6].Value.ToString().Replace("\\", "\\\\"); testModel.Comments = row.Cells[7].Value.ToString(); testRepository.Update(testModel); break; default: break; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } ViewDataFromTable(currentView); // Refresh the data grid view }