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