public int SaveMedicineQuantity(MedicineQuantity medicineQuantity) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO DistributeMedicine VALUES('" + medicineQuantity.CenterId + "','" + medicineQuantity.MedicineId + "','" + medicineQuantity.Quantity + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowsAffected = command.ExecuteNonQuery(); connection.Close(); return rowsAffected; }
public int SaveMedicineQuantity(MedicineQuantity medicineQuantity) { return gateway.SaveMedicineQuantity(medicineQuantity); }