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