public async Task AddAsync(PostMessage entity) { await DbContextManager.BeginTransactionAsync(); var spParameters = new SqlParameter[2]; spParameters[0] = new SqlParameter() { ParameterName = "userid", Value = entity.UserId }; spParameters[1] = new SqlParameter() { ParameterName = "post", Value = entity.Message }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spInsertPostMessages", spParameters); try { await DbContextManager.CommitAsync(); } catch (Exception) { DbContextManager.RollbackTransaction(); } }
public async Task AddAsync(Scratch parameters) { await DbContextManager.BeginTransactionAsync(); var spParameters = new SqlParameter[4]; spParameters[0] = new SqlParameter() { ParameterName = "rewardAmount", Value = parameters.RewardAmount }; spParameters[1] = new SqlParameter() { ParameterName = "recieverId", Value = parameters.RecieverId }; spParameters[2] = new SqlParameter() { ParameterName = "sendDate", Value = parameters.sendDate }; spParameters[3] = new SqlParameter() { ParameterName = "rewardId", Value = parameters.RewardId }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spRewards ", spParameters); try { await DbContextManager.CommitAsync(); } catch (Exception e) { DbContextManager.RollbackTransaction(); } }
public async Task AddAsync(ChatMessage entity) { await DbContextManager.BeginTransactionAsync(); var spParameters = new SqlParameter[3]; spParameters[0] = new SqlParameter() { ParameterName = "senderid", Value = entity.SenderId }; spParameters[1] = new SqlParameter() { ParameterName = "receiverid", Value = entity.ReceiverId }; spParameters[2] = new SqlParameter() { ParameterName = "chat", Value = entity.Message }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spInsertChatMessage", spParameters); try { await DbContextManager.CommitAsync(); } catch (Exception e) { DbContextManager.RollbackTransaction(); } }
public async Task AddAsync(Transaction parameters) { await DbContextManager.BeginTransactionAsync(); var spParameters = new SqlParameter[7]; spParameters[0] = new SqlParameter() { ParameterName = "amount", Value = parameters.Amount }; spParameters[1] = new SqlParameter() { ParameterName = "senderId", Value = parameters.SenderId }; spParameters[2] = new SqlParameter() { ParameterName = "recieverId", Value = parameters.ReciverId }; spParameters[3] = new SqlParameter() { ParameterName = "sendDate", Value = parameters.SendDate }; spParameters[4] = new SqlParameter() { ParameterName = "transactionStatus", Value = parameters.TransactionStatus }; spParameters[5] = new SqlParameter() { ParameterName = "remark", Value = parameters.Remarks }; spParameters[6] = new SqlParameter() { ParameterName = "upiId", Value = parameters.UPIId }; // spParameters[7] = new SqlParameter() { ParameterName = "Flag", Value = "@flag" }; // spParameters[7].Direction = System.Data.ParameterDirection.Output; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spTransactions ", spParameters); try { await DbContextManager.CommitAsync(); } catch (Exception e) { DbContextManager.RollbackTransaction(); } }
public async Task UpdateAsync(EmployeeCreate entity) { await DbContextManager.BeginTransactionAsync(); try { var spParameters = new SqlParameter[7]; spParameters[0] = new SqlParameter() { ParameterName = "EmpId", Value = entity.EmployeeId }; spParameters[1] = new SqlParameter() { ParameterName = "FirstName", Value = entity.FirstName }; spParameters[2] = new SqlParameter() { ParameterName = "LastName", Value = entity.LastName }; spParameters[3] = new SqlParameter() { ParameterName = "Email", Value = entity.Email }; spParameters[4] = new SqlParameter() { ParameterName = "MobileNumber", Value = entity.MobileNumber }; spParameters[5] = new SqlParameter() { ParameterName = "Salary", Value = entity.Salary }; spParameters[6] = new SqlParameter() { ParameterName = "JoinDate", Value = entity.JoinDate }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spEmployeeUpdate", spParameters); await DbContextManager.CommitAsync(); } catch (Exception e) { Console.WriteLine(e); DbContextManager.RollbackTransaction(); } }
public async Task AddAsync(EmployeeCreate entity) { PasswordResult passwordResult = PasswordHash.Encrypt(entity.employeePassword); await DbContextManager.BeginTransactionAsync(); try { var spParameters = new SqlParameter[10]; spParameters[0] = new SqlParameter() { ParameterName = "FirstName", Value = entity.FirstName }; spParameters[1] = new SqlParameter() { ParameterName = "LastName", Value = entity.LastName }; spParameters[2] = new SqlParameter() { ParameterName = "Email", Value = entity.Email }; spParameters[3] = new SqlParameter() { ParameterName = "MobileNumber", Value = entity.MobileNumber }; spParameters[4] = new SqlParameter() { ParameterName = "Password", Value = passwordResult.Signature }; spParameters[5] = new SqlParameter() { ParameterName = "Salt", Value = passwordResult.Salt }; spParameters[6] = new SqlParameter() { ParameterName = "LoginBlocked", Value = entity.LoginBlocked }; spParameters[7] = new SqlParameter() { ParameterName = "StatusId", Value = entity.StatusId }; spParameters[8] = new SqlParameter() { ParameterName = "Salary", Value = entity.Salary }; spParameters[9] = new SqlParameter() { ParameterName = "JoinDate", Value = entity.JoinDate }; await DbContextManager.StoreProc <StoreProcResult>("[dbo].spEmployeeCreate", spParameters); await DbContextManager.CommitAsync(); } catch (Exception e) { Console.WriteLine(e); DbContextManager.RollbackTransaction(); } //User user = new User(); //user.StatusId = Status.Active; //user.FirstName = entity.FirstName; //user.LastName = entity.LastName; //user.Email = entity.Email; //user.MobileNumber = entity.MobileNumber; //await Uow.RegisterNewAsync<User>(user); //int UserId = await Uow.CommitAsync(); //Employee employee = new Employee(); //employee.UserId = UserId; //employee.Salary = entity.Salary; //employee.JoinDate = entity.JoinDate; //await Uow.RegisterNewAsync<Employee>(employee); //await Uow.CommitAsync(); }