public Task <TResult> SelectVmmServerCollectionAsync <TResult>(
Func <SqlDataReader, TResult> translateFunc) where TResult : class
{
return(this.ExecuteProcedureReaderAsync <TResult>(
SqlCommandFactory.SelectVmmServerCollectionProc,
translateFunc,
SqlCommandFactory.SelectVmmServerCollectionParameters()));
}
public Task <TResult> SelectProtetionGroupsBySubscriptionAsync <TResult>(
Guid subscriptionId,
Func <SqlDataReader, TResult> translateFunc) where TResult : class
{
return(this.ExecuteProcedureReaderAsync <TResult>(
SqlCommandFactory.SelectProtetionGroupsBySubscriptionProc,
translateFunc,
SqlCommandFactory.SelectProtetionGroupsBySubscriptionParameters(subscriptionId)));
}
public Task <TResult> SelectServerGroupByIdAsync <TResult>(
Guid groupId,
Func <SqlDataReader, TResult> translateFunc) where TResult : class
{
return(this.ExecuteProcedureReaderAsync <TResult>(
SqlCommandFactory.SelectServerGroupByIdProc,
translateFunc,
SqlCommandFactory.SelectServerGroupByIdParameters(groupId)));
}
public Task <TResult> SelectProtetionGroupByVirtualmachineAsync <TResult>(
Guid subscriptionId,
Guid hyperVId,
Func <SqlDataReader, TResult> translateFunc) where TResult : class
{
return(this.ExecuteProcedureReaderAsync <TResult>(
SqlCommandFactory.SelectProtectionGroupByVirtualMachineProc,
translateFunc,
SqlCommandFactory.SelectProtectionGroupByVirtualMachineParameters(subscriptionId, hyperVId)));
}
public Task <TResult> InsertServerGroupAsync <TResult>(
Guid groupId,
string groupName,
bool azureBackupEnabled,
Func <SqlDataReader, TResult> translateFunc) where TResult : class
{
return(this.ExecuteProcedureReaderAsync <TResult>(
SqlCommandFactory.InsertServerGroupProc,
translateFunc,
SqlCommandFactory.InsertServerGroupParameters(groupId, groupName, azureBackupEnabled)));
}
public Task <TResult> UpdateBackupServerAsync <TResult>(
Guid serverId,
string userName,
byte[] password,
Func <SqlDataReader, TResult> translateFunc) where TResult : class
{
return(this.ExecuteProcedureReaderAsync <TResult>(
SqlCommandFactory.UpdateBackupServerProc,
translateFunc,
SqlCommandFactory.UpdateBackupServerParameters(serverId, userName, password)));
}
public Task <TResult> InsertOrUpdateSpfServerAsync <TResult>(
string adminUrl,
string userName,
byte[] password,
Func <SqlDataReader, TResult> translateFunc) where TResult : class
{
return(this.ExecuteProcedureReaderAsync <TResult>(
SqlCommandFactory.InsertOrUpdateSpfServerProc,
translateFunc,
SqlCommandFactory.InsertOrUpdateSpfServerParameters(adminUrl, userName, password)));
}
public Task <TResult> InsertVirtaulMachineRecordAsync <TResult>(
Guid subscriptionId,
Guid vmmId,
Guid hyperVId,
string vmName,
Func <SqlDataReader, TResult> translateFunc) where TResult : class
{
return(this.ExecuteProcedureReaderAsync <TResult>(
SqlCommandFactory.InsertVirtualMachineRecordProc,
translateFunc,
SqlCommandFactory.InsertVirtualMachineRecordParameters(subscriptionId, vmmId, hyperVId, vmName)));
}
public Task UpdateVirtualMachineActionStateAsync(Guid subscriptionId, Guid hyperVId, int actionStateId)
{
return(this.ExecuteNonQueryProcedureAsync(
SqlCommandFactory.UpdateVirtualMachineActionStateProc,
SqlCommandFactory.UpdateirtualMachineActionStateParameters(subscriptionId, hyperVId, actionStateId)));
}
public Task DeleteVirtualMachineRecordAsync(Guid subscriptionId, Guid hyperVId)
{
return(this.ExecuteNonQueryProcedureAsync(
SqlCommandFactory.DeleteVirtualMachineRecordProc,
SqlCommandFactory.DeleteVirtualMachineRecordParameters(subscriptionId, hyperVId)));
}
public Task DeleteServerGroupAsync(Guid groupId)
{
return(this.ExecuteNonQueryProcedureAsync(
SqlCommandFactory.DeleteServerGroupProc,
SqlCommandFactory.DeleteServerGroupParameters(groupId)));
}
public Task DeleteBackupServerAsync(Guid serverId)
{
return(this.ExecuteNonQueryProcedureAsync(
SqlCommandFactory.DeleteBackupServerProc,
SqlCommandFactory.DeleteBackupServerParameters(serverId)));
}