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(vCartItem entity)
{
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);
await Uow.RegisterNewAsync(entity);
await Uow.CommitAsync();
}
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(RolePermissions entity)
{
await DbContextManager.BeginTransactionAsync();
var spParameters = new SqlParameter[1];
spParameters[0] = new SqlParameter()
{
ParameterName = "RolePermissions", Value = entity.ToString()
};
var result = await DbContextManager.StoreProc <RolePermissions>("[dbo].[spRolePermissionAdd]", spParameters);
}
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 <object> GetAsync(vChat parameters)
{
await DbContextManager.BeginTransactionAsync();
var spParameter = new SqlParameter[2];
spParameter[0] = new SqlParameter()
{
ParameterName = "SenderId",
Value = parameters.SenderId
};
spParameter[1] = new SqlParameter()
{
ParameterName = "ReceiverId",
Value = parameters.ReceiverId
};
//throw new NotImplementedException();
var result = await DbContextManager.StoreProc <StoreProcResult>("[dbo].ShowChat ", spParameter);
return(await Task.FromResult(result));
//throw new NotImplementedException();
}
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();
}
}