protected void search(object sender, EventArgs e) { String query = SearchBox.Text; MedicineTable.DataSource = MedicineController.getMedicineListByQuery(query); MedicineTable.DataBind(); }
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; } }
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()); } }
protected void loadTable() { MedicineTable.DataSource = MedicineController.getAllMedicine(); MedicineTable.DataBind(); }