public async Task RemoveByUserIdAndRoleIdAndStoreIdAsync(TestRepositoryGeneration.Models.EmployeesInRolesSchedule employeesInRolesSchedule)
{
var sql = DeleteQueryBy + WhereQueryByUserIdAndRoleIdAndStoreId;
await DataAccessService.PersistObjectAsync(employeesInRolesSchedule, sql);
}
public async Task<System.Guid> InsertAsync(TestRepositoryGeneration.Models.EmployeesInRolesSchedule employeesInRolesSchedule)
{
var res = await DataAccessService.InsertObjectAsync(employeesInRolesSchedule, InsertQuery);
return (System.Guid)res;
}
/*
public void UpdateByScheduleId(TestRepositoryGeneration.Models.EmployeesInRolesSchedule employeesInRolesSchedule)
{
var sql = UpdateQueryBy + WhereQueryByScheduleId;
DataAccessService.PersistObject(employeesInRolesSchedule, sql);
}
public async Task UpdateByScheduleIdAsync(TestRepositoryGeneration.Models.EmployeesInRolesSchedule employeesInRolesSchedule)
{
var sql = UpdateQueryBy + WhereQueryByScheduleId;
await DataAccessService.PersistObjectAsync(employeesInRolesSchedule, sql);
}
*//*
public void UpdateByUserId(TestRepositoryGeneration.Models.EmployeesInRolesSchedule employeesInRolesSchedule)
{
var sql = UpdateQueryBy + WhereQueryByUserId;
DataAccessService.PersistObject(employeesInRolesSchedule, sql);
}
public async Task UpdateByUserIdAsync(TestRepositoryGeneration.Models.EmployeesInRolesSchedule employeesInRolesSchedule)
{
var sql = UpdateQueryBy + WhereQueryByUserId;
await DataAccessService.PersistObjectAsync(employeesInRolesSchedule, sql);
}
*/
public void UpdateByUserIdAndRoleIdAndStoreId(TestRepositoryGeneration.Models.EmployeesInRolesSchedule employeesInRolesSchedule)
{
var sql = UpdateQueryBy + WhereQueryByUserIdAndRoleIdAndStoreId;
DataAccessService.PersistObject(employeesInRolesSchedule, sql);
}
/*
public IEnumerable<TestRepositoryGeneration.Models.EmployeesInRolesSchedule> GetAll()
{
var sql = SelectAllQuery;
object parameters = null;
var result = DataAccessService.Get<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>(sql, parameters).ToList();
return result.ToList();
}
public async Task<IEnumerable<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>> GetAllAsync()
{
var sql = SelectAllQuery;
object parameters = null;
var result = (await DataAccessService.GetAsync<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>(sql, parameters));
return result.ToList();
}
*/
/*
public IEnumerable<TestRepositoryGeneration.Models.EmployeesInRolesSchedule> GetByScheduleId(System.Guid scheduleId)
{
object parameters = new {scheduleId};
var sql = SelectByQuery + WhereQueryByScheduleId;
var result = DataAccessService.Get<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>(sql, parameters);
return result.ToList();
}
public async Task<IEnumerable<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>> GetByScheduleIdAsync(System.Guid scheduleId)
{
object parameters = new {scheduleId};
var sql = SelectByQuery + WhereQueryByScheduleId;
var result = (await DataAccessService.GetAsync<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>(sql, parameters));
return result.ToList();
}
*/
/*
public IEnumerable<TestRepositoryGeneration.Models.EmployeesInRolesSchedule> GetByUserId(System.Guid userId)
{
object parameters = new {userId};
var sql = SelectByQuery + WhereQueryByUserId;
var result = DataAccessService.Get<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>(sql, parameters);
return result.ToList();
}
public async Task<IEnumerable<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>> GetByUserIdAsync(System.Guid userId)
{
object parameters = new {userId};
var sql = SelectByQuery + WhereQueryByUserId;
var result = (await DataAccessService.GetAsync<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>(sql, parameters));
return result.ToList();
}
*//*
public IEnumerable<TestRepositoryGeneration.Models.EmployeesInRolesSchedule> GetByUserIdAndRoleIdAndStoreId(System.Guid userId, System.Guid roleId, System.Guid storeId)
{
object parameters = new {userId, roleId, storeId};
var sql = SelectByQuery + WhereQueryByUserIdAndRoleIdAndStoreId;
var result = DataAccessService.Get<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>(sql, parameters);
return result.ToList();
}
public async Task<IEnumerable<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>> GetByUserIdAndRoleIdAndStoreIdAsync(System.Guid userId, System.Guid roleId, System.Guid storeId)
{
object parameters = new {userId, roleId, storeId};
var sql = SelectByQuery + WhereQueryByUserIdAndRoleIdAndStoreId;
var result = (await DataAccessService.GetAsync<TestRepositoryGeneration.Models.EmployeesInRolesSchedule>(sql, parameters));
return result.ToList();
}
*/
public System.Guid Insert(TestRepositoryGeneration.Models.EmployeesInRolesSchedule employeesInRolesSchedule)
{
var res = DataAccessService.InsertObject(employeesInRolesSchedule, InsertQuery);
return (System.Guid)res;
}
