public List<Medicine> GetllMedicines() { List<Medicine> medicines = new List<Medicine>(); SqlConnection connection = new SqlConnection(connectionstring); string query = "SELECT * FROM Table_Medicine"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Medicine medicine=new Medicine(); medicine.Id = int.Parse(reader["medicine_Id"].ToString()); medicine.Name = reader["medicine_Name"].ToString(); medicines.Add(medicine); } return medicines; }
public string Insert(Medicine medicine) { if (medicine.Name == "") { return "medicine name is missing"; } else if (medicineGateway.IsThisMedicineNameExists(medicine.Name)) { return "medicine name already exists!!"; } else { int value = medicineGateway.Insert(medicine); if (value > 0) { return "Saved Successfully"; } else { return "Operation Failed"; } } }
public int Insert(Medicine medicine) { SqlConnection connection = new SqlConnection(connectionstring); string query = "INSERT INTO Table_Medicine VALUES('" + medicine.Name + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowsAffected = command.ExecuteNonQuery(); connection.Close(); return rowsAffected; }