Example #1
0
        protected void search(object sender, EventArgs e)
        {
            String query = SearchBox.Text;

            MedicineTable.DataSource = MedicineController.getMedicineListByQuery(query);
            MedicineTable.DataBind();
        }
Example #2
0
        public ActionResult SaveRecord(MedicineViewModel model)
        {
            try
            {
                SaglikDBEntities1 db = new SaglikDBEntities1();

                //SendEmail("", "İlaçların Tarihlerinin Geçmesine 1 Aydan Az Kaldı", DateList.ToString());
                MedicineTable newMedicine = new MedicineTable
                {
                    IsDeleted     = model.IsDeleted,
                    MedicineCount = model.MedicineCount,
                    MedicineDate  = model.MedicineDate,
                    MedicineId    = db.MedicineTables.ToList().Count,
                    MedicineName  = model.MedicineName,
                    MedicineUnit  = model.MedicineUnit
                };
                db.MedicineTables.Add(newMedicine);
                db.SaveChanges();
                MedicineViewModel.showFlag = true;
                return(RedirectToAction("Index4"));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Example #3
0
 public ActionResult deleteData(int id, FormCollection collection)
 {
     try
     {
         using (SaglikDBEntities1 db = new SaglikDBEntities1())
         {
             MedicineTable deletedMedicine = db.MedicineTables.Where(x => x.MedicineId == id).FirstOrDefault();
             db.Entry(deletedMedicine).CurrentValues.SetValues(
                 new MedicineTable
             {
                 IsDeleted    = true, MedicineCount = deletedMedicine.MedicineCount,
                 MedicineDate = deletedMedicine.MedicineDate, MedicineId = deletedMedicine.MedicineId,
                 MedicineName = deletedMedicine.MedicineName, MedicineUnit = deletedMedicine.MedicineUnit
             });
             db.SaveChanges();
         }
         MedicineViewModel.showFlag = true;
         return(RedirectToAction("Index2"));
     }
     catch
     {
         return(View());
     }
 }
Example #4
0
 protected void loadTable()
 {
     MedicineTable.DataSource = MedicineController.getAllMedicine();
     MedicineTable.DataBind();
 }