Esempio n. 1
0
 public Medicine Get(int id)
 {
     using (MedicineDBContext context = new MedicineDBContext())
     {
         return(context.Medicines.FirstOrDefault(e => e.Id == id));
     }
 }
Esempio n. 2
0
 public IEnumerable <Medicine> Get()
 {
     using (MedicineDBContext context = new MedicineDBContext())
     {
         return(context.Medicines.ToList());
     }
 }
Esempio n. 3
0
 public IHttpActionResult Delete(int id)
 {
     using (MedicineDBContext context = new MedicineDBContext())
     {
         Medicine m = context.Medicines.FirstOrDefault(e => e.Id == id);
         context.Medicines.Remove(m);
         context.SaveChanges();
         return(Ok());
     }
 }
Esempio n. 4
0
        public IHttpActionResult Post(Medicine m)
        {
            using (MedicineDBContext context = new MedicineDBContext())
            {
                context.Medicines.Add(new Medicine()
                {
                    MedicineName = m.MedicineName,
                    Stock        = m.Stock,
                    Price        = m.Price
                });

                context.SaveChanges();
                //var data = context.Medicines.ToList();
            }
            return(Ok());
        }
Esempio n. 5
0
        public IHttpActionResult Put(Medicine m)
        {
            using (MedicineDBContext context = new MedicineDBContext())
            {
                Medicine data = context.Medicines.Where(e => e.Id == m.Id).FirstOrDefault <Medicine>();

                if (data != null)
                {
                    data.MedicineName = m.MedicineName;
                    data.Stock        = m.Stock;
                    data.Price        = m.Price;
                    context.SaveChanges();
                }
                else
                {
                    return(NotFound());
                }

                return(Ok());
            }
        }