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