public ActionResult Create(list_of_diagnoses model) { try { diagnosesDAO.CreateDiagnosis(model); return(RedirectToAction("Index")); } catch (Exception ex) { } return(RedirectToAction("Index")); }
public list_of_diagnoses DetailsDiagnosis(int List_diagnoses_id) { List <list_of_diagnoses> listDiagnoses = new List <list_of_diagnoses>(); list_of_diagnoses list = new list_of_diagnoses(); using (var ctx = new PolyclinicEntities()) { string query = "SELECT * FROM list_of_diagnoses where List_diagnoses_id = @P0"; list = ctx.Database.SqlQuery <list_of_diagnoses>(query, List_diagnoses_id).ToList().First(); } return(list); }
public ActionResult Edit(list_of_diagnoses model) { try { int id = Convert.ToInt32(ControllerContext.RouteData.Values.Values.ElementAt(2)); diagnosesDAO.EditDiagnosis(model, id); return(RedirectToAction("Index")); } catch (Exception ex) { } return(RedirectToAction("Index")); }
public void EditDiagnosis(list_of_diagnoses model, int List_diagnoses_id) { using (var ctx = new PolyclinicEntities()) { string query = "update list_of_diagnoses set Diagnose_name=@P1, Description=@P2 where List_diagnoses_id=@P0"; List <object> parameterList = new List <object> { List_diagnoses_id, model.Diagnose_name, model.Description }; object[] parameters = parameterList.ToArray(); int result = ctx.Database.ExecuteSqlCommand(query, parameters); } }
public void CreateDiagnosis(list_of_diagnoses model) { try { using (var ctx = new PolyclinicEntities()) { string query = "INSERT INTO list_of_diagnoses (Diagnose_name, Description) VALUES(@P0, @P1)"; List <object> parameterList = new List <object> { model.Diagnose_name, model.Description }; object[] parameters = parameterList.ToArray(); int result = ctx.Database.ExecuteSqlCommand(query, parameters); } } catch (Exception ex) { } }