public TheMetaAppTypeEntity GetById(int id) { string sql = "select app_type_id as AppTypeId, app_type_name as AppTypeName from meta_app_type where Id = ?"; using (var sqliteConn = connectionProvider.GetConnection()) { return(sqliteConn.QueryFirstOrDefault <TheMetaAppTypeEntity>(sql, new { Id = id })); } }
public void Create(MetaAppTypeEntity entity) { string sql = "insert into meta_app_type(app_type_id, app_type_name) values (@AppTypeId, @AppTypeName);"; using (var sqliteConn = connectionProvider.GetConnection()) { sqliteConn.Execute(sql, new { AppTypeId = entity.AppTypeId, AppTypeName = entity.AppTypeName }); } }
public void Create(AppEntity entity) { string sql = "insert into cms_app(app_id, app_ename, app_name, app_type_id, data_status, description) values (@AppId, @AppEname, @AppName, @AppTypeId, @DataStatus, @Description);"; using (var sqliteConn = connectionProvider.GetConnection()) { sqliteConn.Execute(sql, new { AppId = entity.AppId, AppEname = entity.AppEname, AppName = entity.AppName, AppTypeId = entity.AppTypeId, DataStatus = entity.DataStatus, Description = entity.Description }); } }
public void Create(MetaRepositoryTypeEntity entity) { string sql = "insert into meta_repository_type(repository_type_id, repository_type_name) values (@RepositoryTypeId, @RepositoryTypeName);"; using (var sqliteConn = connectionProvider.GetConnection()) { sqliteConn.Execute(sql, new { RepositoryTypeId = entity.RepositoryTypeId, RepositoryTypeName = entity.RepositoryTypeName }); } }
public void Create(RepositoryEntity entity) { string sql = "insert into cms_repository(repository_name, repository_type_id, gitlab_project_fullname, data_status, description) values (@RepositoryName, @RepositoryTypeId, @GitlabProjectFullname, @DataStatus, @Description);"; using (var sqliteConn = connectionProvider.GetConnection()) { sqliteConn.Execute(sql, new { RepositoryName = entity.RepositoryName, RepositoryTypeId = entity.RepositoryTypeId, GitlabProjectFullname = entity.GitlabProjectFullname, DataStatus = entity.DataStatus, Description = entity.Description }); } }