public string saveMedicine(Medicine aMedicine) { if (aGateway.IsMedicineNameExists(aMedicine)) { return "Medicine Name is Already Exists"; } else if(aGateway.saveMedicine(aMedicine) > 0) { return "Medicine Saved Successfully."; } else { return "Medicine not saved."; } }
public bool IsMedicineNameExists(Medicine aMedicine) { SqlConnection connection=new SqlConnection(connectionString); string query = "SELECT * FROM tbl_Medicine WHERE MedicineName='" + aMedicine.MedicineName + "'"; SqlCommand command=new SqlCommand(query,connection); bool isMedicineNameExists = false; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { isMedicineNameExists = true; } reader.Close(); connection.Close(); return isMedicineNameExists; }
public int saveMedicine(Medicine aMedicine) { SqlConnection connection = new SqlConnection(connectionString); string query = "insert into tbl_Medicine values('"+aMedicine.MedicineName+"')"; SqlCommand command = new SqlCommand(query,connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return rowAffected; }
public List<Medicine> LoadAllMedicine() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_Medicine"; SqlCommand command = new SqlCommand(query, connection); List<Medicine> medicineList=new List<Medicine>(); connection.Open(); SqlDataReader reader = command.ExecuteReader(); int serial = 1; while (reader.Read()) { Medicine aMedicine=new Medicine(); aMedicine.ID = serial; aMedicine.MedicineName = reader["MedicineName"].ToString(); medicineList.Add(aMedicine); serial++; } reader.Close(); connection.Close(); return medicineList; }