public JsonResult GetStoredProceduresFromSysObjects(string txt, int idProject) { string query = "GetStoredProcedures"; Tb_Projects tb = db.Tb_Projects.Find(idProject); string ConnStr; if (tb.LocalConnection.Value) { ConnStr = string.Format("data source=./;initial catalog={0};integrated security=True;MultipleActiveResultSets=True;App=EntityFramework", tb.ProjectDatabase); } else { ConnStr = string.Format("data source={0};initial catalog={1};persist security info=True;user id={2};password={3};multipleactiveresultsets=True;application name=EntityFramework", tb.Server, tb.ProjectDatabase, tb.ProjectUser, tb.Password); } //Parameters List <SqlParameter> listparams = new List <SqlParameter>(); listparams.Add(new SqlParameter("txt", txt)); List <SelectListItem> list = new List <SelectListItem>(); DataTable dt = DataAccessADO.GetDataTable(query, CommandType.StoredProcedure, listparams, ConnStr, null); list = dt.AsEnumerable().Select(x => new SelectListItem() { Text = x.Field <string>("name"), Value = x.Field <string>("id") }).ToList(); return(Json(list, JsonRequestBehavior.DenyGet)); }
public ActionResult DeleteConfirmed(int id) { if (ModelState.IsValid) { using (DbContextTransaction transaction = db.Database.BeginTransaction()) { try { List <Tb_Contexts> contexts = new List <Tb_Contexts>(); if (contexts.Where(x => x.ID_Project == id).Any()) { contexts = db.Tb_Contexts.Where(x => x.ID_Project == id).ToList(); db.Tb_Contexts.RemoveRange(contexts); db.SaveChanges(); } Tb_Projects tb_Projects = db.Tb_Projects.Find(id); db.Tb_Projects.Remove(tb_Projects); db.SaveChanges(); transaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { transaction.Rollback(); MessageBox.Show("Error: " + ex.Message); } } } return(RedirectToAction("Index")); }
// GET: Context/Create public ActionResult Create(int ID_Project) { ViewBag.idProject = ID_Project; Tb_Projects tb = db.Tb_Projects.Find(ID_Project); ViewBag.CurrentName = tb.ProjectName; return(View()); }
public ActionResult Edit([Bind(Include = "ID_Object,ID_Context,ObjectName,Entity,ObjDescription,ID_AuxObject")] Tb_Objects tb_Objects, int idProject) { if (ModelState.IsValid) { try { db.Entry(tb_Objects).State = EntityState.Modified; db.SaveChanges(); //Eliminamos de la base de datos los parametros agregados con anterioridad List <Tb_Parameters> tbParameters = db.Tb_Parameters.Where(x => x.ID_Object == tb_Objects.ID_Object).ToList(); if (tbParameters.Count > 0) { db.Tb_Parameters.RemoveRange(tbParameters); db.SaveChanges(); } string ConnStr; Tb_Projects tb = db.Tb_Projects.Find(idProject); if (tb.LocalConnection.Value) { ConnStr = string.Format("data source=./;initial catalog={0};integrated security=True;MultipleActiveResultSets=True;App=EntityFramework", tb.ProjectDatabase); } else { ConnStr = string.Format("data source={0};initial catalog={1};persist security info=True;user id={2};password={3};multipleactiveresultsets=True;application name=EntityFramework", tb.Server, tb.ProjectDatabase, tb.ProjectUser, tb.Password); }; List <SqlParameter> queryParams = new List <SqlParameter>(); queryParams.Add(new SqlParameter("idObject", tb_Objects.ID_AuxObject)); List <Tb_Parameters> listparams = new List <Tb_Parameters>(); DataTable dt = DataAccessADO.GetDataTable("GetParametersFromSP", CommandType.StoredProcedure, queryParams, ConnStr, null); listparams = dt.AsEnumerable().Select(x => new Tb_Parameters() { ParameterName = x.Field <string>("name"), DataType = x.Field <string>("name"), Length = x.Field <int>("max_length"), Presition = x.Field <int>("precision"), Nullable = x.Field <bool>("is_nullable"), IsOut = x.Field <bool>("is_output") }).ToList(); for (var i = 0; i < listparams.Count; i++) { listparams[i].ID_Object = tb_Objects.ID_Object; } db.Tb_Parameters.AddRange(listparams); db.SaveChanges(); return(RedirectToAction("Index", new { idContext = tb_Objects.ID_Context, idProject = idProject })); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } } ViewBag.ID_Context = new SelectList(db.Tb_Contexts, "ID_Context", "ContextName", tb_Objects.ID_Context); return(View(tb_Objects)); }
// GET: Context public ActionResult Index(int ID_Project) { ViewBag.CurrentProject = ID_Project; Tb_Projects proj = db.Tb_Projects.Find(ID_Project); ViewBag.CurrentName = proj.ProjectName; var tb_Contexts = db.Tb_Contexts.Include(t => t.Tb_Projects); return(View(tb_Contexts.Where(x => x.ID_Project == ID_Project).ToList())); }
// GET: Project/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Tb_Projects tb_Projects = db.Tb_Projects.Find(id); if (tb_Projects == null) { return(HttpNotFound()); } return(View(tb_Projects)); }
public ActionResult Create([Bind(Include = "ID_Project,ProjectName,FileDirectory,LocalConnection,Server,ProjectUser,ProjectDatabase,Password,CreationDate")] Tb_Projects tb_Projects) { if (ModelState.IsValid) { using (DbContextTransaction transaction = db.Database.BeginTransaction()) { try { string ConnStrFormat = ""; if (tb_Projects.LocalConnection.Value) { ConnStrFormat = string.Format("data source=./;initial catalog={0};integrated security=True;MultipleActiveResultSets=True;App=EntityFramework", tb_Projects.ProjectDatabase); } else { ConnStrFormat = string.Format("data source={0};initial catalog={1};persist security info=True;user id={2};password={3};multipleactiveresultsets=True;application name=EntityFramework", tb_Projects.Server, tb_Projects.ProjectDatabase, tb_Projects.ProjectUser, tb_Projects.Password); } using (SqlConnection connection = new SqlConnection(ConnStrFormat)) { connection.Open(); if (connection.State.ToString() == "Closed") { throw new Exception("Los datos proporcionados son incorrectos."); } } tb_Projects.CreationDate = DateTime.Now.Date; db.Tb_Projects.Add(tb_Projects); db.SaveChanges(); transaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { transaction.Rollback(); MessageBox.Show("Ha ocurrido un error: " + ex.Message); } } } return(View(tb_Projects)); }