public async Task AddAsync(AppUser entity) { await DbContextManager.BeginTransactionAsync(); var spParameters = new SqlParameter[3]; spParameters[0] = new SqlParameter() { ParameterName = "EmailId", Value = entity.EmailId }; spParameters[1] = new SqlParameter() { ParameterName = "MobileNumber", Value = entity.MobileNumber }; spParameters[2] = new SqlParameter() { ParameterName = "Password", Value = entity.AppPassword }; var result = await DbContextManager.StoreProc <StoreProcResult>("[dbo].spSignIn", spParameters); try { await DbContextManager.CommitAsync(); } catch (Exception e) { DbContextManager.RollbackTransaction(); } }
public async Task AddAsync(Question entity) { await DbContextManager.BeginTransactionAsync(); var spParameter = new SqlParameter[3]; spParameter[0] = new SqlParameter() { ParameterName = "QuestionTitle", Value = entity.QuestionTitle }; spParameter[1] = new SqlParameter() { ParameterName = "QuestionBody", Value = entity.QuestionBody }; spParameter[2] = new SqlParameter() { ParameterName = "QuestionAuthorId", Value = entity.QuestionAuthorId }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spInsertQuestion", spParameter); try { await DbContextManager.CommitAsync(); } catch (Exception e) { DbContextManager.RollbackTransaction(); } }
public async Task AddAsync(Cart entity) { await DbContextManager.BeginTransactionAsync(); var spParameters = new SqlParameter[4]; spParameters[0] = new SqlParameter() { ParameterName = "FashionProductId", Value = entity.FashionProductId }; spParameters[1] = new SqlParameter() { ParameterName = "PaytmUserId", Value = entity.PaytmUserId }; spParameters[2] = new SqlParameter() { ParameterName = "ProductQuantity", Value = entity.ProductQuantity }; spParameters[3] = new SqlParameter() { ParameterName = "TotalAmount", Value = entity.TotalAmount }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spCart", spParameters); try { await DbContextManager.CommitAsync(); } catch { DbContextManager.RollbackTransaction(); } }
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 async Task AddAsync(Traveller entity) { await DbContextManager.BeginTransactionAsync(); if (entity.AppUserId == null) { entity.AppUserId = 0; } var spParameters = new SqlParameter[5]; spParameters[0] = new SqlParameter() { ParameterName = "AppUserId", Value = entity.AppUserId }; spParameters[1] = new SqlParameter() { ParameterName = "FirstName", Value = entity.FirstName }; spParameters[2] = new SqlParameter() { ParameterName = "LastName", Value = entity.LastName }; spParameters[3] = new SqlParameter() { ParameterName = "EmailId", Value = entity.EmailId }; spParameters[4] = new SqlParameter() { ParameterName = "MobileNumber", Value = entity.MobileNumber }; var result = await DbContextManager.StoreProc <StoreProcResult>("[dbo].spUser", spParameters); try { await DbContextManager.CommitAsync(); } catch (Exception e) { DbContextManager.RollbackTransaction(); } }
public async Task UpdateAsync(BankCardDetail entity) { await DbContextManager.BeginTransactionAsync(); var spParameters = new SqlParameter[7]; //spParameters[0] = new SqlParameter() { ParameterName = "PaytmUserId", Value = entity.PaytmUserId }; spParameters[1] = new SqlParameter() { ParameterName = "CardNumber", Value = entity.CardNumber }; spParameters[2] = new SqlParameter() { ParameterName = "CardName", Value = entity.CardName }; spParameters[3] = new SqlParameter() { ParameterName = "CardCVV", Value = entity.CardCVV }; spParameters[4] = new SqlParameter() { ParameterName = "CardType", Value = entity.CardType }; spParameters[5] = new SqlParameter() { ParameterName = "CardExpiryDate", Value = entity.CardExpiryDate }; //spParameters[6] = new SqlParameter() { ParameterName = "Amount", Value = entity.Amount }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spBankTransactionDetail", spParameters); try { await DbContextManager.CommitAsync(); } catch { DbContextManager.RollbackTransaction(); } }
public async Task UpdateAsync(Transaction entity) { await DbContextManager.BeginTransactionAsync(); var spParameters = new SqlParameter[6]; spParameters[0] = new SqlParameter() { ParameterName = "ApplicationObjectId", Value = entity.ApplicationObjectId }; spParameters[1] = new SqlParameter() { ParameterName = "TransactionDate", Value = entity.TransactionDate }; spParameters[2] = new SqlParameter() { ParameterName = "PaytmUserId", Value = entity.PaytmUserId }; spParameters[3] = new SqlParameter() { ParameterName = "ReceiverId", Value = entity.ReceiverId }; //spParameters[4] = new SqlParameter() { ParameterName = "WalletId", Value = entity.WalletId }; //spParameters[5] = new SqlParameter() { ParameterName = "Amount", Value = entity.Amount }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spWalletTransactionDetail", spParameters); try { await DbContextManager.CommitAsync(); } catch { DbContextManager.RollbackTransaction(); } }