public List<Medicine> GetAllMedicineByRepeater() { SqlConnection connection = new SqlConnection(databaseConString); string query = "SELECT * FROM view_medicineList"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List<Medicine> medicineList = new List<Medicine>(); int serialNo = 1; while (reader.Read()) { Medicine medicine = new Medicine(); medicine.SerialNo = serialNo++; medicine.MedicineCode = reader["medicine_code"].ToString(); medicine.MedicineName = reader["medicine_name"].ToString(); medicine.Description = reader["description"].ToString(); medicine.CategoryName = reader["category_name"].ToString(); medicine.CompanyName = reader["company_name"].ToString(); medicine.Price = double.Parse(reader["price"].ToString()); medicineList.Add(medicine); } reader.Close(); connection.Close(); return medicineList; }
public string Save(Medicine medicine) { if (medicineGateway.Save(medicine) > 0) { return "Added Successfully!"; } else { return "Could Not Added!"; } }
protected void addMedicineButton_Click(object sender, EventArgs e) { Medicine medicine = new Medicine(); medicine.MedicineCode = medicineCodeTextBox.Text; medicine.MedicineName = medicineNameTextBox.Text; medicine.Description = descriptionTextBox.Text; medicine.CategoryId = int.Parse(categoryNameDropDownList.SelectedValue); medicine.CompanyId = int.Parse(companyNameDropDownList.SelectedValue); medicine.Price = int.Parse(priceTextBox.Text); message.InnerHtml = medicineManager.Save(medicine); }
public int Save(Medicine medicine) { SqlConnection connection = new SqlConnection(databaseConString); string query = "INSERT INTO tbl_medicine VALUES ('" + medicine.MedicineCode + "','" + medicine.MedicineName + "','" + medicine.Description + "','" + medicine.CategoryId + "','" + medicine.CompanyId + "','" + medicine.Price + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return rowAffected; }