public List <CenterMedicineLinker> GetCenterMedicineLinker(int id)
{
List <CenterMedicineLinker> linkers = new List <CenterMedicineLinker>();
connection = new SqlConnection(connectionString);
string query = "SELECT * FROM center_medicine_linker WHERE cent_id = @id";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@id", id);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
CenterMedicineLinker aLinker = new CenterMedicineLinker()
{
CenterId = int.Parse(reader["cent_id"].ToString()),
Id = int.Parse(reader["id"].ToString()),
MedicineId = int.Parse(reader["med_id"].ToString()),
Qty = int.Parse(reader["qty"].ToString())
};
linkers.Add(aLinker);
}
reader.Close();
connection.Close();
return(linkers);
}
public JsonResult SendMeds(int centerid, int medid, int qty)
{
CenterMedicineLinker cml = new CenterMedicineLinker()
{
CenterId = centerid,
MedicineId = medid,
Qty = qty
};
if (cGate.SaveCenterMedicineLinker(cml))
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
//saves a CenterMedicineLinker in the database in the center_medicine_linker table
public bool SaveCenterMedicineLinker(CenterMedicineLinker cml)
{
connection = new SqlConnection(connectionString);
string query = "INSERT INTO center_medicine_linker VALUES (@cent_id, @med_id, @qty)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("cent_id", cml.CenterId);
command.Parameters.AddWithValue("med_id", cml.MedicineId);
command.Parameters.AddWithValue("qty", cml.Qty);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected > 0);
}
public ActionResult SendMedicine([Bind(Include = "CenterId, MedicineId, Qty")] CenterMedicineLinker cml)
{
ViewBag.CenterId = new SelectList(cGate.GetAll(), "Id", "Name");
ViewBag.MedicineId = new SelectList(mGate.GetAll(), "Id", "Name");
if (ModelState.IsValid)
{
if (cGate.SaveCenterMedicineLinker(cml))
{
ViewBag.Message = "Successful";
//return RedirectToAction("index", "Home");
return(View());
}
return(View());
}
return(View());
}
