public List<Medicine> GetAllMedicines() { aGateway.command.CommandText = "SELECT * FROM MedicineList_tbl"; aGateway.sqlConnection.Open(); SqlDataReader reader = aGateway.command.ExecuteReader(); List<Medicine> medicinesList = new List<Medicine>(); if (reader != null) while (reader.Read()) { Medicine aMedicine = new Medicine(); aMedicine.ID = Convert.ToInt16(reader["ID"].ToString()); aMedicine.MedicineName = reader["MedicineNameWithML"].ToString(); medicinesList.Add(aMedicine); } reader.Close(); aGateway.sqlConnection.Close(); return medicinesList; }
public int SaveMedicine(Medicine aMedicine) { string query = "insert into MedicineList_tbl(MedicineNameWithML) values('" + aMedicine.MedicineName + "')"; aGateway.sqlConnection.Open(); aGateway.command.CommandText = query; int rowAffected = aGateway.command.ExecuteNonQuery(); aGateway.sqlConnection.Close(); return rowAffected; }
public int SaveMedicine(Medicine aMedicine) { return aHeadOfficeGateway.SaveMedicine(aMedicine); }
public List<Medicine> MedicineList() { List<Medicine> MedicineList=new List<Medicine>(); aGateway.command.CommandText = "SELECT * FROM MedicineList_tbl ORDER BY MedicineNameWithML ASC"; aGateway.sqlConnection.Open(); SqlDataReader reader = aGateway.command.ExecuteReader(); while (reader.Read()) { Medicine newMedicine =new Medicine(); newMedicine.MedicineName = reader[1].ToString(); MedicineList.Add(newMedicine); } reader.Close(); aGateway.sqlConnection.Close(); return MedicineList; }
public void GetMedicineList() { medicineStockList = aCenterManager.GetAllMedicineByCenterID(newCenter); foreach (CenterMedicineStock medicine in medicineStockList) { Medicine newMedicine = new Medicine(); newMedicine.ID = medicine.MedicineID; newMedicine.MedicineName = aCenterManager.GetMedicineInfo(medicine.MedicineID); newMedicineList.Add(newMedicine); } }