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));
}