//Method Delete public bool Delete(medicalClass m) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "DELETE FROM ambulance WHERE ambNo=@ambNo"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@ambNo", m.ambNo); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
// Update data public bool Update(medicalClass m) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "UPDATE ambulance SET pin=@pin, FirstName=@FirstName, LastName=@LastName, DataTime=@DataTime, mkb=@mkb, KLabKK=@KLabKK, KLabOther=@KLabOther, KLabUrina=@KLabUrina, Rentgen=@Rentgen, UZD=@UZD, KAT=@KAT, suture=@suture, foreignMatter=@foreignMatter, bandaging=@bandaging, Immobilization=@Immobilization, other=@other WHERE ambNo=@ambNo"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@ambNo", m.ambNo); cmd.Parameters.AddWithValue("@pin", m.pin); cmd.Parameters.AddWithValue("@FirstName", m.FirstName); cmd.Parameters.AddWithValue("@LastName", m.LastName); cmd.Parameters.AddWithValue("@DataTime", m.DataTime); cmd.Parameters.AddWithValue("@mkb", m.mkb); cmd.Parameters.AddWithValue("@KLabKK", KLabKK); cmd.Parameters.AddWithValue("@KLabOther", m.KLabOther); cmd.Parameters.AddWithValue("@KLabUrina", m.KLabUrina); cmd.Parameters.AddWithValue("@Rentgen", m.Rentgen); cmd.Parameters.AddWithValue("@UZD", m.UZD); cmd.Parameters.AddWithValue("@KAT", m.KAT); cmd.Parameters.AddWithValue("@suture", m.suture); cmd.Parameters.AddWithValue("@foreignMatter", m.foreignMatter); cmd.Parameters.AddWithValue("@bandaging", m.bandaging); cmd.Parameters.AddWithValue("@Immobilization", m.Immobilization); cmd.Parameters.AddWithValue("@other", m.other); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
//Inserting data from Database public bool Insert(medicalClass m) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "INSERT INTO ambulance (pin , FirstName, LastName, DataTime, mkb, KLabKK, KLabOther, KLabUrina, Rentgen, UZD, KAT, suture, foreignMatter, bandaging, Immobilization, other) VALUES (@pin , @FirstName, @LastName, @DataTime, @mkb, @KLabKK, @KLabOther, @KLabUrina, @Rentgen, @UZD, @KAT, @suture, @foreignMatter, @bandaging, @Immobilization, @other)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@pin", m.pin); cmd.Parameters.AddWithValue("@FirstName", m.FirstName); cmd.Parameters.AddWithValue("@LastName", m.LastName); cmd.Parameters.AddWithValue("@DataTime", m.DataTime); cmd.Parameters.AddWithValue("@mkb", m.mkb); cmd.Parameters.AddWithValue("@KLabKK", KLabKK); cmd.Parameters.AddWithValue("@KLabOther", m.KLabOther); cmd.Parameters.AddWithValue("@KLabUrina", m.KLabUrina); cmd.Parameters.AddWithValue("@Rentgen", m.Rentgen); cmd.Parameters.AddWithValue("@UZD", m.UZD); cmd.Parameters.AddWithValue("@KAT", m.KAT); cmd.Parameters.AddWithValue("@suture", m.suture); cmd.Parameters.AddWithValue("@foreignMatter", m.foreignMatter); cmd.Parameters.AddWithValue("@bandaging", m.bandaging); cmd.Parameters.AddWithValue("@Immobilization", m.Immobilization); cmd.Parameters.AddWithValue("@other", m.other); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }