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