Exemplo n.º 1
0
        public bool UpdateUser(UserBLL user, LumexDBPlayer db)
        {
            bool status = false;

            try
            {
                //db.AddParameters("@Serial", user.Serial.Trim());
                db.AddParameters("@UserId", user.UserId.Trim());
                db.AddParameters("@UserName", user.UserName.Trim());
                //db.AddParameters("@EmployeeId", "");
                db.AddParameters("@UserGroupId", user.UserGroupId.Trim());
                //db.AddParameters("@Department", "");
                //db.AddParameters("@Designation", "");
                //db.AddParameters("@Address","");
                db.AddParameters("@ContactNumber", user.Cell.Trim());
                db.AddParameters("@Email", user.Email.Trim());
                //db.AddParameters("@NationalId", "");
                //db.AddParameters("@PassportNumber", "");
                // db.AddParameters("@BaranchId", user.Branch);
                db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
                //db.AddParameters("@Password", LumexLibraryManager.EncodeIntoMd5Hash(user.Password));

                status = Convert.ToBoolean(db.ExecuteNonQuery("UPDATE_USER_BY_ID", true));
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                user = null;
            }
            return(status);
        }
Exemplo n.º 2
0
        //            @StakeName	nvarchar(100)	,
        //@DailyAwardFrom	decimal(18, 2)	,
        //@DailyAwardTo	decimal(18, 2)	,
        //@Avarage	decimal(18, 2)	,
        //@TotalDuration	decimal(18, 2)	,
        //@BinaryCap	decimal(18, 2)	,
        //@Parcentage	decimal(18, 2)	,
        //@CreatedBy	varchar(50)	,
        //@CreatedFrom	varchar(50)
        internal System.Data.DataTable SaveStaKeInfo(BLL.StakeInfoBLL stakeInfoBLL, LumexDBPlayer db)
        {
            bool      status = true;
            DataTable dt     = new DataTable();

            try
            {
                db.AddParameters("@StakeName", stakeInfoBLL.StakeName);
                db.AddParameters("@Amount", stakeInfoBLL.Amount);
                db.AddParameters("@DailyAwardFrom", stakeInfoBLL.DailyAwardFrom);
                db.AddParameters("@DailyAwardTo", stakeInfoBLL.DailyAwardTo);
                db.AddParameters("@Avarage", stakeInfoBLL.AvgAward);
                db.AddParameters("@TotalDuration", stakeInfoBLL.TotalDuration);
                db.AddParameters("@BinaryCap", stakeInfoBLL.BinaryCap);
                db.AddParameters("@Parcentage", stakeInfoBLL.Parcentage);
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
                dt = db.ExecuteDataTable("[INSERT_STAKE_INFO]", true);
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemplo n.º 3
0
        internal void InsertReceivePaymentWhenDailybonus(LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@CreatedBy", (string)LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                db.ExecuteNonQuery("[INSERT_RECEIVE_PAYMENT_WHEN_DAILY_BONUS]", true);
            }
            catch (Exception)
            {
                //  throw;
            }
        }
Exemplo n.º 4
0
 internal void SaveGeneratedPin(DataTable dt, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@StakeGen", dt);
         db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
         db.ExecuteDataTable("INSERT_STAKE_PIN", true);
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemplo n.º 5
0
 internal DataTable InsertReceivePaymentWhenPinChange(LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@UserId", (string)LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("Amount", "5");
         db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
         DataTable dt = db.ExecuteDataTable("INSERT_RECEIVE_PAYMENT_WHEN_PINCHANGE", true);
         return(dt);
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemplo n.º 6
0
 internal void InsertReceivePaymentWhenActive(string UserId, string RefferId, string Commission, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@UserId", UserId);
         db.AddParameters("@RefferId", RefferId);
         db.AddParameters("@Commission", Commission);
         db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
         db.ExecuteNonQuery("[INSERT_RECEIVE_PAYMENT_WHEN_COMMISSION]", true);
     }
     catch (Exception)
     {
         //  throw;
     }
 }
Exemplo n.º 7
0
        internal void UpdateUserPin(string userId, string pin, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@UserId", userId);
                db.AddParameters("@Pin", pin);
                db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());

                db.ExecuteNonQuery("[UPDATE_USER_PIN_BY_ID]", true);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 8
0
 public void DeleteUserGroup(string userGroupId, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@UserGroupId", userGroupId);
         db.AddParameters("@DeletedBy", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@DeletedFrom", LumexLibraryManager.GetTerminal());
         db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
         db.ExecuteNonQuery("DELETE_USER_GROUP_BY_ID", true);
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemplo n.º 9
0
 internal void UpdateLookUpGroup(initialDataBLL lookUpDataBLL, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@ElementGrpId", lookUpDataBLL.ElementGroupId.Trim());
         db.AddParameters("@ElementGrpName", lookUpDataBLL.ElementGroupName.Trim());
         db.AddParameters("@Description", lookUpDataBLL.ElementGroupDes.Trim());
         db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
         db.ExecuteNonQuery("[UPDATE_ELEMENT_GROUP]", true);
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemplo n.º 10
0
        public void UpdateUserGroupActivation(string userGroupId, string activationStatus, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@UserGroupId", userGroupId);
                db.AddParameters("@IsActive", activationStatus);
                db.AddParameters("@ActivatedBy", LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@ActivatedFrom", LumexLibraryManager.GetTerminal());

                db.ExecuteNonQuery("UPDATE_USER_GROUP_ACTIVATION", true);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 11
0
        internal DataTable generateDailyBonus(string Date, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@CreatedBy", (string)LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("[INSERT_DAILY_BONUS]", true);

                return(dt);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 12
0
 internal void UpdateLookUpElementData(initialDataBLL lookUpDataBLL, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@ElementId", lookUpDataBLL.ElementDataId.Trim());
         db.AddParameters("@ElementName", lookUpDataBLL.ElementDataName.Trim());
         db.AddParameters("@ElementGrpId", lookUpDataBLL.ElementGroupId.Trim());
         db.AddParameters("@Suffix", lookUpDataBLL.ElementDataDescp.Trim());
         db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
         db.ExecuteNonQuery("[UPDATE_ELEMENT_DATA]", true);
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemplo n.º 13
0
        internal void InsertIntoGenolgyTree(string placeId, string position, string referId, string UserId, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@UserId", UserId);
                db.AddParameters("@RefferId", referId);
                db.AddParameters("@PleacementId", placeId);
                db.AddParameters("@PlacePosition", position);
                db.AddParameters("@JoinFrom", LumexLibraryManager.GetTerminal());

                int i = db.ExecuteNonQuery("INSERT INTO [dbo].[tblStakeJoining] (UserId,RefferId,PleacementId,PlacePosition,JoinDate,JoinFrom)VALUES(@UserId,@RefferId,@PleacementId,@PlacePosition,GETDATE(),@JoinFrom)");
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 14
0
        public void UpdateUserPassword(string userId, string password, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@UserId", userId);
                db.AddParameters("@Password", ProtectPassword(password));
                db.AddParameters("@ActualPass", password);
                //db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());

                db.ExecuteNonQuery("UPDATE_USER_PASSWORD_BY_ID", true);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 15
0
        internal DataTable ReceivePaymentMoney(string amount, LumexDBPlayer db)
        {
            DataTable dt = new DataTable();

            try
            {
                db.AddParameters("@Amount", amount);
                db.AddParameters("@GenerateBy", LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@GenerateFrom", LumexLibraryManager.GetTerminal());
                dt = db.ExecuteDataTable("[INSERT_RECEIVE_PAYMENT_WHEN_GENERATE_MONRY]", true);
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemplo n.º 16
0
        internal DataTable SaveLookUpGroup(initialDataBLL lookUpDataBLL, LumexDBPlayer db)
        {
            DataTable dt = new DataTable();

            try
            {
                db.AddParameters("@ElementGrpName", lookUpDataBLL.ElementGroupName.Trim());
                db.AddParameters("@Description", lookUpDataBLL.ElementGroupDes.Trim());
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
                dt = db.ExecuteDataTable("[INSERT_ELEMENT_GROUP]", true);
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemplo n.º 17
0
        internal void updateKeyonTransfer(BLL.StakeInfoBLL stakeInfoBLL, DataTable dt, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@StakeKey", dt);

                db.AddParameters("@SentTo", stakeInfoBLL.sendto);
                db.AddParameters("@SentBy", stakeInfoBLL.transferBy);
                db.AddParameters("@SendSms", stakeInfoBLL.sendSms);
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
                db.ExecuteDataTable("[UPDATE_STAKE_PIN_ON_TRANSFER]", true);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 18
0
 internal DataTable updateKeyWhenPurchase(string NoofPin, string UnitPrice, string StakeId, string payby, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@UserId", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@NoofPin", NoofPin);
         db.AddParameters("@PinAmount", UnitPrice);
         db.AddParameters("@StakeId", StakeId);
         db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
         db.AddParameters("@PayBy", payby);
         DataTable dt = db.ExecuteDataTable("[UPDATE_STAKE_PIN_ON_PURCHEAS_AND_PAYMENT]", true);
         return(dt);
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemplo n.º 19
0
        public DataTable SaveUser(UserBLL user, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@UserId", user.UserId.Trim());
                db.AddParameters("@UserName", user.UserName.Trim());
                db.AddParameters("@EmployeeId", "");
                db.AddParameters("@UserGroupId", "UG001");
                db.AddParameters("@Department", "");
                db.AddParameters("@Designation", "");
                db.AddParameters("@Address", "");
                db.AddParameters("@ContactNumber", user.Cell.Trim());
                db.AddParameters("@Email", user.Email.Trim());
                db.AddParameters("@NationalId", "");
                db.AddParameters("@PassportNumber", "");
                db.AddParameters("@Password", ProtectPassword(user.Password.Trim()));
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
                //db.AddParameters("@DOB",LumexLibraryManager.ParseAppDate(user.DOB.Trim()));
                //db.AddParameters("@Gender",user.Gender.Trim());

                if ((string)LumexSessionManager.Get("ActiveUserId") == "Developer")
                {
                    db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
                }

                else
                {
                    db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
                }
                db.AddParameters("@ValidDate", "");

                DataTable dt = db.ExecuteDataTable("INSERT_USER", true);
                return(dt);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                user = null;
            }
        }
Exemplo n.º 20
0
        internal System.Data.DataTable SaveNewsInfo(BLL.NewsFeedBLL newsFeedBLL, Lumex.Tech.LumexDBPlayer db)
        {
            DataTable dt = new DataTable();

            try
            {
                db.AddParameters("@NewsBody", newsFeedBLL.BodyText);
                db.AddParameters("@NewsTitale", newsFeedBLL.Title);
                db.AddParameters("@ValidDate", newsFeedBLL.Value);
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
                dt = db.ExecuteDataTable("INSERT INTO [dbo].[tblNewsFeed]([NewsBody],[NewsTitale],[ValidDate],[CreatedBy],[CreatedDate])VALUES(@NewsBody,@NewsTitale,@ValidDate,@CreatedBy,GETDATE())");
            }
            catch (Exception)
            {
                //throw;
            }
            return(dt);
        }
Exemplo n.º 21
0
        internal DataTable CalculateMatchingCommission(string UserId, decimal leftAmount, decimal rightAmount, LumexDBPlayer db)
        {
            DataTable dt = new DataTable();

            try
            {
                db.AddParameters("@UserId", UserId);
                db.AddParameters("@TotalLeft", leftAmount);
                db.AddParameters("@TotalRight", rightAmount);
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                dt = db.ExecuteDataTable("[INSERT_RECEIVE_PAYMENT_WHEN_MATCHING_COMMISSION]", true);
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemplo n.º 22
0
        internal DataTable updateWithdrawRequest(string Id, string Status, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@TransferId", Id);
                db.AddParameters("@Status", Status);
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
                db.AddParameters("@CreatedBy", (string)LumexSessionManager.Get("ActiveUserId"));


                DataTable dt = db.ExecuteDataTable("[INSERT_RECEIVE_PAYMENT_WHEN_TRANSFER_AMOUNT]", true);

                return(dt);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 23
0
        public DataTable UpdateUserVarificationCode(UserBLL userBLL, LumexDBPlayer db)
        {
            bool status = false;

            try
            {
                db.ClearParameters();
                db.AddParameters("@UserId", userBLL.UserId);
                db.AddParameters("@VarifyCode", userBLL.varifycode);
                db.AddParameters("@ActivatedBy", "");
                db.AddParameters("@ActivatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("[UPDATE_USER_VARIFICATION_CODE]", true);
                return(dt);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 24
0
        internal DataTable UpdateUserAccount(string UserId, string StakeId, string StakeKey, Lumex.Tech.LumexDBPlayer db)
        {
            bool      status = true;
            DataTable dt     = new DataTable();

            try
            {
                db.AddParameters("@UserId", UserId);
                db.AddParameters("@StakeId", StakeId);
                db.AddParameters("@StakeKey", StakeKey);
                db.AddParameters("@ActiveFrom", LumexLibraryManager.GetTerminal());
                dt = db.ExecuteDataTable("[Update_USER_ACCOUNT_ACTIVATION_BY_STAKE_KEY]", true);
            }
            catch (Exception)
            {
                throw;
            }

            return(dt);
        }
Exemplo n.º 25
0
        internal DataTable SaveUserInfo(UserBLL userBLL, LumexDBPlayer db)
        {
            bool      status = true;
            DataTable dt     = new DataTable();

            try
            {
                db.AddParameters("@UserId", userBLL.UserId);
                db.AddParameters("@FirstName", userBLL.FirstName);
                db.AddParameters("@LastName", userBLL.LastName);
                db.AddParameters("@PassportNo", userBLL.PassportNo);
                db.AddParameters("@Address", userBLL.Address);
                db.AddParameters("@Country", userBLL.Country);
                db.AddParameters("@House", userBLL.House);
                db.AddParameters("@Street", userBLL.Street);
                db.AddParameters("@Area", userBLL.Area);
                db.AddParameters("@MobileNo", userBLL.MobileNo);
                db.AddParameters("@Email", userBLL.Email);
                db.AddParameters("@EmrName", userBLL.EmrName);
                db.AddParameters("@EmarRelation", userBLL.EmrRelation);
                db.AddParameters("@EmrAdress", userBLL.EmrAddress);
                db.AddParameters("@EmrMobile", userBLL.EmrMobile);
                db.AddParameters("@EmrEmail", userBLL.EmeEmail);
                db.AddParameters("@EmrCountry", userBLL.EmeCountry);
                db.AddParameters("@IsActive", userBLL.IsActive);
                db.AddParameters("@isVarified", userBLL.Isvarified);
                db.AddParameters("@CreatedBy", userBLL.Createdby);
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
                db.AddParameters("@UserGroupId", userBLL.UserGroupId);
                db.AddParameters("@PerPhoto", userBLL.PerPhoto);
                db.AddParameters("@Password", userBLL.Password);
                db.AddParameters("@ActualPass", userBLL.ActualPass);
                db.AddParameters("@UserPin", userBLL.UserPin);
                dt = db.ExecuteDataTable("[INSERT_USER_INFO]", true);
            }
            catch (Exception)
            {
                throw;
            }
            return(dt);
        }
Exemplo n.º 26
0
        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);
        }
Exemplo n.º 27
0
 public void UpdateUserGroup(UserGroupBLL userGroup, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@UserGroupId", userGroup.UserGroupId.Trim());
         db.AddParameters("@UserGroupName", userGroup.UserGroupName.Trim());
         db.AddParameters("@Description", userGroup.Description.Trim());
         db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
         db.AddParameters("@GroupOrder", "1");
         db.ExecuteNonQuery("UPDATE_USER_GROUP_BY_ID", true);
     }
     catch (Exception)
     {
         throw;
     }
     finally
     {
         userGroup = null;
     }
 }
Exemplo n.º 28
0
 internal void UpdateStakeInfo(BLL.StakeInfoBLL stakeInfoBLL, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@StakeId", stakeInfoBLL.StakeId);
         db.AddParameters("@StakeName", stakeInfoBLL.StakeName);
         db.AddParameters("@Amount", stakeInfoBLL.Amount);
         db.AddParameters("@DailyAwardFrom", stakeInfoBLL.DailyAwardFrom);
         db.AddParameters("@DailyAwardTo", stakeInfoBLL.DailyAwardTo);
         db.AddParameters("@Avarage", stakeInfoBLL.AvgAward);
         db.AddParameters("@TotalDuration", stakeInfoBLL.TotalDuration);
         db.AddParameters("@BinaryCap", stakeInfoBLL.BinaryCap);
         db.AddParameters("@Parcentage", stakeInfoBLL.Parcentage);
         db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
         db.ExecuteDataTable("[UPDATE_STAKE_INFO]", true);
     }
     catch (Exception)
     {
         throw;
     }
 }
Exemplo n.º 29
0
 public DataTable SaveUserGroup(UserGroupBLL userGroup, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@UserGroupName", userGroup.UserGroupName.Trim());
         db.AddParameters("@Description", userGroup.Description.Trim());
         db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
         db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
         db.AddParameters("@GroupOrder", "1");
         DataTable dt = db.ExecuteDataTable("INSERT_USER_GROUP", true);
         return(dt);
     }
     catch (Exception)
     {
         throw;
     }
     finally
     {
         userGroup = null;
     }
 }
Exemplo n.º 30
0
        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;
            }
        }