public List <MedicineView> GetMedicinesAjax()
{
List <MedicineView> medicinesList = new List <MedicineView>();
DataTable dataTable = _sqlHelper.GetMedicinesAjax();
for (int index = 0; index < dataTable.Rows.Count; index++)
{
MedicineView medicine = new MedicineView();
medicine.Name = dataTable.Rows[index]["Name"].ToString();
medicine.Quantity = (int)dataTable.Rows[index]["Quantity"];
medicine.batchNumber = (string)dataTable.Rows[index]["BatchNumber"];
medicine.EntryDate = ((DateTime)(dataTable.Rows[index]["EntryDate"])).ToString("MMMM dd, yyyy");
medicine.ExpiryDate = ((DateTime)dataTable.Rows[index]["ExpiryDate"]).ToString("MMMM dd, yyyy");
medicine.medicineID = (int)dataTable.Rows[index]["ID"];
medicine.AvaiableQuantity = (int)dataTable.Rows[index]["AvailableQuantity"];
medicinesList.Add(medicine);
}
return(medicinesList);
}
public void AddMedicine(MedicineView medicine)
{
try
{
_connection.Open();
SqlCommand cmd = new SqlCommand("dbo.AddMedicine", _connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@medicineName", medicine.Name);
cmd.Parameters.AddWithValue("@quantity", medicine.Quantity);
cmd.Parameters.AddWithValue("@entryDate", medicine.EntryDate);
cmd.Parameters.AddWithValue("@expiryDate", medicine.ExpiryDate);
cmd.Parameters.AddWithValue("@batchNumber", medicine.batchNumber);
cmd.Parameters.AddWithValue("@isEssential", medicine.isEssential);
cmd.ExecuteNonQuery();
}
catch (Exception exception)
{
Console.WriteLine("Failed to get Medicine names because " + exception.Message);
}
}
public void EditMedicine(MedicineView medicine)
{
try
{
_connection.Open();
SqlCommand cmd = new SqlCommand("dbo.UpdateMedicine", _connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@medicineID", medicine.medicineID);
cmd.Parameters.AddWithValue("@medicineName", medicine.Name);
cmd.Parameters.AddWithValue("@qantity", Convert.ToInt32(medicine.Quantity));
cmd.Parameters.AddWithValue("@entryDate", medicine.EntryDate);
cmd.Parameters.AddWithValue("@availableQuantity", Convert.ToInt32(medicine.AvaiableQuantity));
cmd.Parameters.AddWithValue("@expiryDate", medicine.ExpiryDate);
cmd.Parameters.AddWithValue("@batchNumber", medicine.batchNumber);
cmd.ExecuteNonQuery();
}
catch (Exception exception)
{
Console.WriteLine("Failed to get Medicine names because " + exception.Message);
}
}
public void EditMedicine(MedicineView medicine)
{
_sqlHelper.EditMedicine(medicine);
}
public void AddMedicine(MedicineView medicine)
{
_sqlHelper.AddMedicine(medicine);
}
