public string GetUserTranstionEntry(string usEntry)
{
UserBalanceModel ubm = new UserBalanceModel();
UserBalanceBL ubbl = new UserBalanceBL();
var IsExists = "";
if (ModelState.IsValid)
{
if (IsExists.Equals(null))
{
ModelState.AddModelError("UserName", "Already exists");
// return View(Object);
}
}
if (Session["UserInfo"] == null)
{
return("false");
}
string userInfo = Session["UserInfo"] as string;
string UserID = userInfo.Split('_')[0];
string[] USEntry = usEntry.Split('/');
ubm.PayDate = USEntry[0].ToString();
ubm.UserID = USEntry[1].ToString();
ubm.TransitionType = USEntry[2].ToString();
ubm.Amount = USEntry[3].ToString();
ubm.OperatorMode = UserID;
return(ubbl.GetUserTranstionEntry(ubm));
}
public string GetUserTranstionEntry(UserBalanceModel UBModel)
{
BaseDL BDL = new BaseDL();
Function FUN = new Function();
SqlParameter[] prms = new SqlParameter[5];
DateTime dt = DateTime.ParseExact(UBModel.PayDate.Replace("-", "/"), "dd/MM/yyyy", CultureInfo.GetCultureInfo("en-us"));
prms[0] = new SqlParameter("@PayDate", SqlDbType.Date)
{
Value = dt
};
prms[1] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = string.IsNullOrWhiteSpace(UBModel.UserID) ? (object)DBNull.Value : UBModel.UserID
};
prms[2] = new SqlParameter("@TransitionType", SqlDbType.TinyInt)
{
Value = string.IsNullOrWhiteSpace(UBModel.TransitionType) ? (object)DBNull.Value : UBModel.TransitionType
};
prms[3] = new SqlParameter("@Amount", SqlDbType.Int)
{
Value = string.IsNullOrWhiteSpace(UBModel.Amount) ? (object)DBNull.Value : UBModel.Amount
};
prms[4] = new SqlParameter("@OperatorMode", SqlDbType.VarChar)
{
Value = string.IsNullOrWhiteSpace(UBModel.OperatorMode) ? (object)DBNull.Value : UBModel.OperatorMode
};
if (BDL.InsertUpdateDeleteData("User_Transition_Insert", prms))
{
return("true");
}
return("false");
}
public string DataIsExists(UserBalanceModel UBModel)
{
BaseDL BDL = new BaseDL();
Function FUN = new Function();
SqlParameter[] prms = new SqlParameter[2];
DateTime dt = DateTime.ParseExact(UBModel.PayDate.Replace("-", "/"), "dd/MM/yyyy", CultureInfo.GetCultureInfo("en-us"));
prms[0] = new SqlParameter("@PayDate", SqlDbType.Date)
{
Value = dt
};
prms[1] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = string.IsNullOrWhiteSpace(UBModel.UserID) ? (object)DBNull.Value : UBModel.UserID
};
DataTable DtResult = BDL.SelectData("User_Transition_DataExists", prms);
if (DtResult.Rows.Count > 0)
{
return("true");
}
return("false");
}
public UserBalanceModel GetBalance()
{
long userid = long.Parse(Session["userid"].ToString());
var data = _db.userBalanceModels.Where(u => u.user_id == userid).ToList();
UserBalanceModel res = data.FirstOrDefault();
return(res);
}
public string GetUserBalanceByDetailDate(string id)
{
UserBalanceBL ubbl = new UserBalanceBL();
UserBalanceModel UBM = new UserBalanceModel();
UBM.UserID = id.Split('_')[0];
return(ubbl.GetUserBalanceByDetailDate(UBM));
}
public string GetDailyUserBalance_List(string UserID)
{
UserBalanceModel ubm = new UserBalanceModel();
ubm.UserID = UserID.ToString();
UserBalanceBL ubbl = new UserBalanceBL();
return(ubbl.GetDailyUserBalance_List(ubm));
}
public async Task <UserBalanceModel> GetBalances(string userId, bool calculateEstimate)
{
try
{
var model = new UserBalanceModel();
var currentUser = new Guid(userId);
using (var context = ExchangeDataContextFactory.CreateReadOnlyContext())
{
var query = from currency in context.Currency
from balance in context.Balance.Where(b => b.UserId == currentUser && b.CurrencyId == currency.Id).DefaultIfEmpty()
// from address in context.Address.Where(a => a.UserId == currentUser && a.CurrencyId == currency.Id).DefaultIfEmpty()
where currency.IsEnabled
orderby currency.Name
select new UserBalanceItemModel
{
//Address = address.AddressHash,
CurrencyId = currency.Id,
HeldForTrades = (decimal?)balance.HeldForTrades ?? 0,
PendingWithdraw = (decimal?)balance.PendingWithdraw ?? 0,
Name = currency.Name,
Symbol = currency.Symbol,
Status = currency.Status,
ListingStatus = currency.ListingStatus,
StatusMessage = currency.StatusMessage,
Total = (decimal?)balance.Total ?? 0,
Unconfirmed = (decimal?)balance.Unconfirmed ?? 0,
IsFavorite = (bool?)balance.IsFavorite ?? false,
CurrencyType = currency.Type,
BaseAddress = currency.BaseAddress
};
var balances = await query.ToListNoLockAsync().ConfigureAwait(false);
model.Balances = balances.DistinctBy(x => x.CurrencyId).ToList();
}
if (calculateEstimate)
{
await model.Balances.ForEachAsync(async b => b.EstimatedBTC = await BalanceEstimationService.GetEstimatedBTC(b.Total, b.CurrencyId));
model.BTCEstimate = model.Balances.Sum(x => x.EstimatedBTC);
model.BTCEstimateAlt = model.Balances.Where(x => x.CurrencyId != Constant.BITCOIN_ID).Sum(x => x.EstimatedBTC);
var verificationData = await UserVerificationReader.GetVerificationStatus(userId).ConfigureAwait(false);
model.HasWithdrawLimit = verificationData.Limit > 0;
model.WithdrawLimit = verificationData.Limit;
model.WithdrawTotal = verificationData.Current;
}
return(model);
}
catch (Exception)
{
return(new UserBalanceModel());
}
}
public string GetDailyUserBalance_List(UserBalanceModel UBModel)
{
BaseDL BDL = new BaseDL();
Function FUN = new Function();
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = string.IsNullOrWhiteSpace(UBModel.UserID) ? (object)DBNull.Value : UBModel.UserID
};
DataTable DtBLList = BDL.SelectData("M_UserBalance_BalanceSelect", prms);
return(FUN.DataTableToJSONWithJSONNet(DtBLList));
}
public string GetUserBalanceByDetailDate(UserBalanceModel UBModel)
{
BaseDL bdl = new BaseDL();
Function fun = new Function();
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = string.IsNullOrWhiteSpace(UBModel.UserID) ? (object)DBNull.Value : UBModel.UserID
};
DataTable DtCinemaIncome = bdl.SelectData("M_UserBalance_DetailSelect", prms);
return(fun.DataTableToJSONWithJSONNet(DtCinemaIncome));
}
public string DataIsExists(string data)
{
UserBalanceModel ubm = new UserBalanceModel();
UserBalanceBL ubbl = new UserBalanceBL();
if (Session["UserInfo"] == null)
{
return("false");
}
string[] USEntry = data.Split('/');
ubm.PayDate = USEntry[0].ToString();
ubm.UserID = USEntry[1].ToString();
return(ubbl.DataIsExists(ubm));
}
