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