public async Task <object> GetBy(CreateBookBed parameters) { return(await Uow.Repository <vBookBed>().FindByAsync(t => t.UserId == parameters.UserId)); //return await Uow.Repository<vBookBed>().FirstOrDefaultAsync(t=>t.UserId==parameters.UserId); //throw new NotImplementedException(); }
public async Task DeleteAsync(CreateBookBed parameters) { var candidate = Uow.Repository <BookBed>().FindByKey(parameters.BookBedId); await Uow.RegisterDeletedAsync(candidate); await Uow.CommitAsync(); //await Uow.Repository<CreateBookBed>().FindByAsync(a => a.BedId == parameters.BedId); //throw new NotImplementedException(); }
public async Task AddAsync(CreateBookBed entity) { await DbContextManager.BeginTransactionAsync(); try { var spParameters = new SqlParameter[8]; spParameters[0] = new SqlParameter() { ParameterName = "userId", Value = entity.UserId }; spParameters[1] = new SqlParameter() { ParameterName = "rentalCity", Value = entity.RentalCity }; spParameters[2] = new SqlParameter() { ParameterName = "rentalType", Value = entity.RentalType }; spParameters[3] = new SqlParameter() { ParameterName = "paymentType", Value = entity.PaymentTypeId }; spParameters[4] = new SqlParameter() { ParameterName = "paymentAmount", Value = entity.PaymentAmount }; spParameters[5] = new SqlParameter() { ParameterName = "bedId", Value = entity.BedId }; spParameters[6] = new SqlParameter() { ParameterName = "startDate", Value = entity.StartDate }; spParameters[7] = new SqlParameter() { ParameterName = "endDate", Value = entity.EndDate }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spBookBed ", spParameters); await DbContextManager.CommitAsync(); } catch (Exception e) { Console.WriteLine(e); DbContextManager.RollbackTransaction(); } }
public HashSet <string> UpdateValidation(CreateBookBed entity) { return(ValidationMessages); }
public async Task <object> GetAsync(CreateBookBed parameters) { return(await Uow.Repository <vBookBed>().AllAsync()); //throw new NotImplementedException(); }
public HashSet <string> DeleteValidation(CreateBookBed parameters) { return(ValidationMessages); }
public async Task UpdateAsync(CreateBookBed entity) { await Uow.RegisterDirtyAsync(entity); await Uow.CommitAsync(); }