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); }
// @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); }
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; } }
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; } }
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; } }
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; } }
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; } }
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; } }
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; } }
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; } }
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; } }
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; } }
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; } }
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; } }
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); }
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); }
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; } }
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; } }
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; } }
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); }
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); }
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; } }
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; } }
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); }
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); }
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); }
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; } }
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; } }
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; } }
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; } }