public string Save(Medicine aMedicine) { if (aMedicineDbGateway.Find(aMedicine.Name) == null) { aMedicineDbGateway.Save(aMedicine); return("Saved"); } else { return("Already Exists"); } }
public string SaveMedicine(Medicine aMedicine) { Medicine medicineFound = aMedicineDBGateway.Find(aMedicine.Name); if (medicineFound == null) { aMedicineDBGateway.SaveMedicine(aMedicine); return("Medicine Successfully Saved...!!!"); } else { return("This medicine already exist"); } }
public List <Stock> GetAll(int centerId) { string query = "SELECT *FROM tbl_stock where centerId=" + centerId; ASqlConnection.Open(); ASqlCommand = new SqlCommand(query, ASqlConnection); ASqlDataReader = ASqlCommand.ExecuteReader(); List <Stock> stockList = new List <Stock>(); while (ASqlDataReader.Read()) { MedicineDBGateway aGateway = new MedicineDBGateway();; Stock aStock = new Stock(); Medicine aMedicine = aGateway.Find(Convert.ToInt32(ASqlDataReader["id"])); aStock.MedicineName = aMedicine.Name + "_" + aMedicine.MgMl; aStock.Quantity = (int)ASqlDataReader["quantity"]; stockList.Add(aStock); } ASqlDataReader.Close(); ASqlConnection.Close(); return(stockList); }
public Medicine Find(string name) { return(aMedicineDbGateway.Find(name)); }
internal Medicine Find(string medicineId) { return(aMedicineDbGateway.Find(medicineId)); }