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); }