internal void updateUserAccountforTransfer(BLL.UserAccountBLL userAccountBLL, LumexDBPlayer db)
{
try
{
db.AddParameters("@Amount", userAccountBLL.Amount);
db.AddParameters("@userId", (string)LumexSessionManager.Get("ActiveUserId"));
db.ExecuteNonQuery("Update tblUserAccounts Set Income = ISNULL( Income,0)-@Amount where UserId=@userId");
}
catch (Exception)
{
throw;
}
}
internal System.Data.DataTable GetTransiction(BLL.UserAccountBLL userAccountBLL, Lumex.Tech.LumexDBPlayer db)
{
bool status = true;
DataTable dt = new DataTable();
try
{
}
catch (Exception)
{
throw;
}
return(dt);
}
internal DataTable InsertReceivePaymentWhenAffectIncome(BLL.UserAccountBLL userAccountBLL, LumexDBPlayer db)
{
DataTable dt = new DataTable();
try
{
db.AddParameters("@UserId", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@AffectforId", userAccountBLL.AffectforId);
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.AddParameters("@RPType", userAccountBLL.RPType);
db.AddParameters("@Amount", userAccountBLL.TotalAmount.ToString());
db.AddParameters("@Particular", userAccountBLL.Particular);
db.AddParameters("@AffectFor", userAccountBLL.Affectfor);
dt = db.ExecuteDataTable("[INSERT_RECEIVE_PAYMENT_WHEN_AFFECT_INCOME]", true);
}
catch (Exception)
{
throw;
}
return(dt);
}
internal DataTable RequestToTransfer(BLL.UserAccountBLL userAccountBLL, LumexDBPlayer db)
{
try
{
db.AddParameters("@UserId", (string)LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@TransferTo", userAccountBLL.TransferTo);
db.AddParameters("@TransferType", userAccountBLL.transfarType);
db.AddParameters("@BankName", userAccountBLL.BankAccountNo);
db.AddParameters("@SwiftCode", userAccountBLL.SwiftCode);
db.AddParameters("@Amount", userAccountBLL.Amount);
db.AddParameters("@TransferNote", userAccountBLL.TransferNote);
db.AddParameters("@Status", userAccountBLL.Status);
db.AddParameters("@CreatedBy", (string)LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("[INSERT_WITHDRAW_REQUEST]", true);
return(dt);
}
catch (Exception)
{
throw;
}
}
