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