public int SaveMedicine(Medicine aMedicine) { if (medicineGateway.IsThisMedicineExists(aMedicine.Name)) { return 0; } else { if (medicineGateway.SaveMedicine(aMedicine)) { return 1; } else { return -1; } } }
public List<Medicine> GetMedicine() { string searchMedicine = "SELECT * FROM tbl_medicine"; sqlConnection.Open(); sqlCommand.CommandText = searchMedicine; SqlDataReader reader = sqlCommand.ExecuteReader(); List<Medicine> medicineList = new List<Medicine>(); while (reader.Read()) { Medicine medicine = new Medicine(); medicine.Id = Convert.ToInt32(reader["id"].ToString()); medicine.Name = reader["MedicineName"].ToString(); medicineList.Add(medicine); } reader.Close(); sqlConnection.Close(); return medicineList; }
public List<Medicine> Getreport(int centerId) { sqlConnection.Open(); string query = "select tbl_medicine.MedicineName, tbl_send_medicine.Quentity from tbl_send_medicine join tbl_medicine on tbl_medicine.id = tbl_send_medicine.MedicineId where CenterId='" + centerId + "' ORDER BY MedicineName ASC "; sqlCommand.CommandText = query; SqlDataReader reader = sqlCommand.ExecuteReader(); List<Medicine> medicineReportList = new List<Medicine>(); while (reader.Read()) { Medicine aMedicine = new Medicine(); aMedicine.Name = reader["MedicineName"].ToString(); aMedicine.Quantity = Convert.ToInt32(reader["Quentity"].ToString()); medicineReportList.Add(aMedicine); } reader.Close(); sqlConnection.Close(); return medicineReportList; }
public List<Medicine> GetAllMedicineInfobyCenterId(object centerId) { string query = "Select tbl_medicine.MedicineName, tbl_medicine.id from tbl_medicine join tbl_send_medicine ON tbl_medicine.id=tbl_send_medicine.MedicineId Where tbl_send_medicine.CenterId='"+centerId+"' Order By MedicineName ASC"; sqlConnection.Open(); sqlCommand.CommandText = query; sqlCommand = new SqlCommand(query, sqlConnection); SqlDataReader reader = sqlCommand.ExecuteReader(); List<Medicine> medicineList = new List<Medicine>(); while (reader.Read()) { Medicine aMedicine = new Medicine(); aMedicine.Id = (int) reader["id"]; aMedicine.Name = reader["MedicineName"].ToString(); medicineList.Add(aMedicine); } reader.Close(); sqlConnection.Close(); return medicineList; }
protected void submitButton_Click(object sender, EventArgs e) { Medicine aMedicine = new Medicine(); aMedicine.Name = medicineNameTextBox.Text; int message = medicineManager.SaveMedicine(aMedicine); if (message>0) { messageLabel.Text = "Successfully Saved"; messageLabel.ForeColor= Color.Green; LoadAllMedicine(); } else if (message==0) { messageLabel.Text = "This medicine name alresdy saved"; messageLabel.ForeColor = Color.Red; } else { messageLabel.Text = "Saved Failed"; messageLabel.ForeColor = Color.Red; } }
public bool SaveMedicine(Medicine aMedicine) { string saveMedicine = "INSERT INTO tbl_medicine (MedicineName) VALUES(@name)"; sqlConnection.Open(); sqlCommand.CommandText = saveMedicine; sqlCommand.Parameters.AddWithValue("@name", aMedicine.Name); int rowAffected = sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); if (rowAffected > 0) { return true; } return false; }