public void Update(LibraryGroupInfo group)
{
var sqlString = $@"UPDATE {TableName} SET
{nameof(LibraryGroupInfo.GroupName)} = @{nameof(LibraryGroupInfo.GroupName)}
WHERE {nameof(LibraryGroupInfo.Id)} = @{nameof(LibraryGroupInfo.Id)}";
IDataParameter[] parameters =
{
GetParameter(nameof(LibraryGroupInfo.GroupName), DataType.VarChar, 200, group.GroupName),
GetParameter(nameof(LibraryGroupInfo.Id), DataType.Integer, group.Id)
};
ExecuteNonQuery(sqlString, parameters);
}
public int Insert(LibraryGroupInfo group)
{
var sqlString = $@"INSERT INTO {TableName}
({Attr.Type},
{nameof(LibraryGroupInfo.GroupName)})
VALUES
(@{Attr.Type},
@{nameof(LibraryGroupInfo.GroupName)})";
IDataParameter[] parameters =
{
GetParameter(Attr.Type, DataType.VarChar, 200, LibraryGroupInfo.GetValue(group.LibraryType)),
GetParameter(nameof(LibraryGroupInfo.GroupName), DataType.VarChar, 200, group.GroupName)
};
return(ExecuteNonQueryAndReturnId(TableName, nameof(LibraryGroupInfo.Id), sqlString, parameters));
}
private static LibraryGroupInfo GetLibraryGroupInfo(IDataRecord rdr)
{
if (rdr == null)
{
return(null);
}
var libraryGroupInfo = new LibraryGroupInfo();
var i = 0;
libraryGroupInfo.Id = rdr.IsDBNull(i) ? 0 : rdr.GetInt32(i);
i++;
libraryGroupInfo.LibraryType = LibraryGroupInfo.GetEnumType(rdr.IsDBNull(i) ? string.Empty : rdr.GetString(i));
i++;
libraryGroupInfo.GroupName = rdr.IsDBNull(i) ? string.Empty : rdr.GetString(i);
return(libraryGroupInfo);
}
public LibraryGroupInfo Get(int id)
{
LibraryGroupInfo accessTokenInfo = null;
var sqlString = $@"SELECT {nameof(LibraryGroupInfo.Id)},
{Attr.Type},
{nameof(LibraryGroupInfo.GroupName)}
FROM {TableName} WHERE {nameof(LibraryGroupInfo.Id)} = {id}";
using (var rdr = ExecuteReader(sqlString))
{
if (rdr.Read())
{
accessTokenInfo = GetLibraryGroupInfo(rdr);
}
rdr.Close();
}
return(accessTokenInfo);
}
public LibraryGroupInfo CreateGroup([FromBody] GroupRequest group)
{
var auth = new AuthenticatedRequest();
if (!auth.IsAdminLoggin ||
!auth.AdminPermissionsImpl.HasSitePermissions(group.SiteId,
ConfigManager.SitePermissions.Library))
{
return(Request.Unauthorized <LibraryGroupInfo>());
}
var libraryGroup = new LibraryGroupInfo
{
LibraryType = LibraryType.Text,
GroupName = group.Name
};
libraryGroup.Id = DataProvider.LibraryGroupDao.Insert(libraryGroup);
return(libraryGroup);
}
public bool IsExists(LibraryType type, string groupName)
{
var exists = false;
var sqlString = $@"SELECT {nameof(LibraryGroupInfo.Id)} FROM {TableName} WHERE {Attr.Type} = @{Attr.Type} AND {nameof(LibraryGroupInfo.GroupName)} = @{nameof(LibraryGroupInfo.GroupName)}";
IDataParameter[] parameters =
{
GetParameter(Attr.Type, DataType.VarChar, 200, LibraryGroupInfo.GetValue(type)),
GetParameter(nameof(LibraryGroupInfo.GroupName), DataType.VarChar, 200, groupName)
};
using (var rdr = ExecuteReader(sqlString, parameters))
{
if (rdr.Read() && !rdr.IsDBNull(0))
{
exists = true;
}
rdr.Close();
}
return(exists);
}
