public PartialViewResult GetBaseviewNamespaceList() { string sql = "SELECT * FROM listsettings.baseviewnamespace ORDER BY baseviewnamespace; "; var paramList = new List <KeyValuePair <string, string> >() { }; DataSet ds = DataServices.DataSetFromSQL(sql, paramList); BaseviewNamespaceModel baseviewNamespaceModel = new BaseviewNamespaceModel(); List <BaseviewNamespaceDto> baseviewNamespaceDto = ds.Tables[0].ToList <BaseviewNamespaceDto>(); return(PartialView("_BaseviewNamespace", baseviewNamespaceDto)); }
public IActionResult BaseviewNamespaceSave(BaseviewNamespaceModel model) { string sql = "INSERT INTO listsettings.baseviewnamespace(_createdsource, baseviewnamespace, baseviewnamespacedescription, _createdby) VALUES ('Synapse Studio', @baseviewnamespace, @baseviewnamespacedescription, @p_username);"; var paramList = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("baseviewnamespace", model.BaseviewNamespace), new KeyValuePair <string, string>("baseviewnamespacedescription", model.BaseviewNamespaceDescription == null ? "" : model.BaseviewNamespaceDescription), new KeyValuePair <string, string>("p_username", HttpContext.Session.GetString(SynapseSession.FullName)) }; DataServices.executeSQLStatement(sql, paramList); return(Json("OK")); }
public IActionResult BaseviewNamespace() { string sql = "SELECT * FROM listsettings.baseviewnamespace ORDER BY baseviewnamespace; "; var paramList = new List <KeyValuePair <string, string> >() { }; DataSet ds = DataServices.DataSetFromSQL(sql, paramList); BaseviewNamespaceModel baseviewNamespaceModel = new BaseviewNamespaceModel(); List <BaseviewNamespaceDto> baseviewNamespaceDto = ds.Tables[0].ToList <BaseviewNamespaceDto>(); baseviewNamespaceModel.BaseviewNamespaceDto = baseviewNamespaceDto; return(View(baseviewNamespaceModel)); }