public int GetMedicineIdByName(string name) { string query = string.Format("SELECT MedicineId FROM Medicine Where MedicineName='{0}'", name); SqlConnection connection=new SqlConnection(connectionString); SqlCommand command=new SqlCommand(query,connection); connection.Open(); Medicine aMedicine=new Medicine(); aMedicine.Serial= Convert.ToInt32(command.ExecuteScalar()); connection.Close(); return aMedicine.Serial; }
public string Save(Medicine aMedicine) { if (aGateway.IsMedicineNameExists(aMedicine)) { return "Medicine Already Exist."; } else if (aGateway.Save(aMedicine) > 0) { return "Successfully Saved."; } else { return "Saving Failed."; } }
public List<Medicine> PopulateMedicineDropDownList(int centerId) { List<Medicine> medicineList = new List<Medicine>(); SqlConnection connection = new SqlConnection(connectionString); string query = string.Format("SELECT Medicine.MedicineId,Medicine.MedicineName FROM DistributeMedicine INNER JOIN Medicine ON Medicine.MedicineId=DistributeMedicine.MedicineId Where CenterId='{0}'", centerId); connection.Open(); SqlCommand command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Medicine medicine = new Medicine(); medicine.Serial = Convert.ToInt32(reader["MedicineId"]); medicine.MedicineName = reader["MedicineName"].ToString(); medicineList.Add(medicine); } reader.Close(); connection.Close(); return medicineList; }
public List<Medicine> PopulateMedicineDropDownList() { List<Medicine> medicineList = new List<Medicine>(); SqlConnection connection = new SqlConnection(connectionString); string query = string.Format("SELECT * FROM Medicine"); connection.Open(); SqlCommand command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Medicine aMedicine = new Medicine(); aMedicine.Serial = Convert.ToInt32(reader["MedicineId"]); aMedicine.MedicineName= reader["MedicineName"].ToString(); medicineList.Add(aMedicine); } reader.Close(); connection.Close(); return medicineList; }