public async Task <Tuple <bool, string> > UpdateFundsTransfer(FundRequest fundRequestModel)
{
int requestStatus = -1;
Tuple <bool, string> updateFundsTransferResult = null;
try
{
using (SqlConnection con = new SqlConnection(_dcDb))
{
var parameters = new DynamicParameters();
parameters.Add("@FromUserID", UserID, DbType.Int32);
parameters.Add("@Amount", fundRequestModel.ApprovedAmount, DbType.Decimal);
parameters.Add("@ToUserID", fundRequestModel.RequestToUserID, DbType.Int32);
parameters.Add("@CreatedBy", UserID, DbType.Int32);
requestStatus = await con.ExecuteScalarAsync <int>("dbo.Update_FundTransfer", parameters, commandType : CommandType.StoredProcedure);
if (requestStatus == 0)
{
updateFundsTransferResult = Tuple.Create(true, "Transfer funds successfully.");
}
else
{
updateFundsTransferResult = Tuple.Create(false, "Transfer funds failed.Please try again.");
}
}
}
catch (Exception ex)
{
ErrorLog.Write(ex);
updateFundsTransferResult = Tuple.Create(false, "Oops! Transfer funds failed.Please try again.");
}
return(updateFundsTransferResult);
}
public async Task <Tuple <bool, string> > RequestFunds(FundRequest fundRequestModel)
{
int requestStatus = -1;
Tuple <bool, string> requestFundsResult = null;
try
{
using (SqlConnection con = new SqlConnection(_dcDb))
{
var parameters = new DynamicParameters();
parameters.Add("@UserID", UserID, DbType.Int32);
parameters.Add("@RequestedAmount", fundRequestModel.RequestedAmount, DbType.Decimal);
parameters.Add("@RequestToUserID", fundRequestModel.RequestToUserID, DbType.Int32);
parameters.Add("@RequestStatusID", fundRequestModel.RequestStatusID, DbType.Int32);
parameters.Add("@CreatedBy", UserID, DbType.Int32);
requestStatus = await con.ExecuteScalarAsync <int>("dbo.Insert_FundRequest", parameters, commandType : CommandType.StoredProcedure);
if (requestStatus == 0)
{
requestFundsResult = Tuple.Create(true, "Your funds request successfully.");
}
else
{
requestFundsResult = Tuple.Create(false, "Your funds request failed.");
}
}
}
catch (Exception ex)
{
ErrorLog.Write(ex);
requestFundsResult = Tuple.Create(false, "Oops! Your funds request failed.");
}
return(requestFundsResult);
}
private void button1_Click(object sender, EventArgs e)
{
string itemName = textBox1.Text;
int total = int.Parse(textBox2.Text);
FundRequest fr = new FundRequest();
fr.ItemName = itemName;
fr.Total = total;
db.FundRequest.Add(fr);
db.SaveChanges();
}
private void button1_Click(object sender, EventArgs e)
{
int count = (from x in db.PurchaseRequest where x.Deleted == 0 select x).Count();
for (int i = 0; i < count; i++)
{
FundRequest fr = new FundRequest();
fr.ItemName = dataGridView1.SelectedRows[i].Cells[1].Value.ToString();
fr.Total = int.Parse(dataGridView1.SelectedRows[i].Cells[4].Value.ToString());
fr.Deleted = 0;
}
MessageBox.Show("Success");
}
public static FundRequest create(int departmentID, string information, int money)
{
FundRequest f = new FundRequest();
f.DepartmentId = departmentID;
f.Information = information;
f.AmountMoney = money;
f.Date = DateTime.Now;
f.Note = "";
f.Status = "Pending";
return(f);
}
public async Task <Tuple <bool, string> > UpdateFundsTransfer(FundRequest fundRequestModel)
{
Tuple <bool, string> result = null;
try
{
result = await _repo.UpdateFundsTransfer(fundRequestModel);
}
catch (Exception ex)
{
ErrorLog.Write(ex);
}
return(result);
}
public async Task <Tuple <bool, string> > ApproveFundsRequest(FundRequest fundRequestModel)
{
Tuple <bool, string> result = null;
try
{
result = await _repo.ApproveFundsRequest(fundRequestModel);
}
catch (Exception ex)
{
ErrorLog.Write(ex);
}
return(result);
}
public void update(int staffId, int raiseTotal)
{
FundRequest fr = new FundRequest();
fr.ItemName = "Raise Salary";
fr.Total = raiseTotal;
fr.Deleted = 2;
var req = (from x in db.RaiseRequest where x.StaffId == staffId select x).FirstOrDefault();
req.Deleted = 3;
db.SaveChanges();
var obj = (from x in db.Staff where x.StaffId == staffId select x).FirstOrDefault();
obj.StaffSalary += raiseTotal;
db.SaveChanges();
}
public async Task <FundResponse> FundIn(FundRequest request)
{
ValidateAccountFrozenStatus();
var transferFundRequest = new TransferFundRequest
{
PlayerId = PlayerId,
Amount = request.Amount,
TransferType = Mapper.Map <Core.Common.Data.TransferFundType>(request.TransferFundType),
WalletId = request.WalletId.ToString(),
BonusCode = request.BonusCode
};
return(new FundResponse
{
TransferId = await _transferFundCommands.AddFund(transferFundRequest)
});
}
/// <summary>
/// 查询用户竞猜列表
/// author：陶林辉
/// </summary>
/// <param name="userId">用户id</param>
/// <param name="type">1000 全部、1001 收入、1002 支出、1010 中奖、1012 充值、1014 退款、1016 兑换、1017 投注</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页面大小</param>
/// <returns></returns>
public OrderList AcquireOrder(long userId, int type, int pageIndex, int pageSize)
{
FundRequest Fund = new FundRequest
{
FuserId = userId,
Type = type
};
ZhangYuRequest Request = new ZhangYuRequest();
Request.Page = new pagerequest
{
PageIndex = pageIndex == 0 ? 1 : pageIndex,
PageSize = pageSize == 0 ? 20 : pageSize,
};
Request.AppKey = _options.Value.AppKey;
Request.Data = _sys.Base64Encode(Encoding.UTF8, JsonHelper.SerializeObject(Fund));
Request.Sign = _sys.Sha512Encode($"{Request.AppKey}{_options.Value.AppSecret}{Request.Data}{Request.Nonce}{Request.Timestamp}");
string strUrl = string.Format(_options.Value.Url, "v1", "orderList");
string strJson = JsonHelper.SerializeObject(Request);
_log.Info($"查询用户竞猜列表请求参数{strJson}");
var response = JsonHelper.DeserializeJsonToObject <ZhangYuResponse>(_sys.PostJsonData(strUrl, strJson, Encoding.UTF8));
_log.Info($"查询用户竞猜列表返回值{JsonHelper.SerializeObject(response)}");
if (response.Code == "0")
{
var vResult = JsonHelper.DeserializeJsonToObject <OrderList>(_sys.Base64Decode(response.Data));
if (vResult != null)
{
vResult.Page = new PageInfo()
{
Count = response.Page.Count,
PageIndex = response.Page.PageIndex,
PageSize = response.Page.PageSize,
PageTotal = response.Page.PageTotal,
Totaltotal = response.Page.Totaltotal,
};
}
return(vResult);
}
return(null);
}
public static void add(FundRequest f)
{
db.FundRequests.Add(f);
db.SaveChanges();
}
public void WithdrawFunds([FromBody] FundRequest fundRequest)
{
}
public void AddFunds([FromBody] FundRequest fundRequest)
{
}
public void add(int departmentId, string information, int money)
{
FundRequest f = FundRequestFactory.create(departmentId, information, money);
FundRequestRepository.add(f);
}
public static void CreateFundRequest(FundRequest newFundRequest)
{
newFundRequest.FundStatus = "Pending Request";
DatabaseSingleton.GetInstance().FundRequests.Add(newFundRequest);
DatabaseSingleton.GetInstance().SaveChanges();
}
public async Task <FundResponse> FundIn(FundRequest request)
{
return(await _memberApiProxy.FundInAsync(request));
}
public async Task <FundResponse> FundInAsync(FundRequest request)
{
var result = await HttpClient.SecurePostAsJsonAsync(Token, "api/Payment/FundIn", request);
return(await EnsureApiResult <FundResponse>(result));
}
