/// <summary>
///
/// </summary>
/// <param name="transferrecords">包含转账的乙方账号，转账金额,转账甲方账号，姓名</param>
/// <param name="card">密码</param>
/// <param name="v">传入1，代表储户操作</param>
/// <returns></returns>
public bool Transfer(Transferrecords transferrecord, string password)
{
bool boo = false;
Cards card1 = new Cards();
Cards card2 = new Cards();
Depositors depositor = new Depositors();
card1 = cardsService.CheakCardsService(transferrecord.TpartyBcid); //找对方账号，姓名,没加利息的账户
if (card1 != null && card1.Cid == transferrecord.TpartyBcid) //找对方银行卡号
{ //找到则找自己账号。钱够不够
card2 = cardsService.CheakCardsService(transferrecord.TpartyAcid); //没加利息的账户
if (card2 != null && card2.Cid == transferrecord.TpartyAcid && card2.Cpassword == password) //找甲方（自己）银行卡号并验证密码
{
card2.CflowBalance = cardsService.FlowBalanceService(card2.Cid)[1];
if (card2.CflowBalance >= transferrecord.TtransferBalance)
{
//够则修改自己的账户余额（减少） FlowBalanceService(int cid)
card2.CflowBalance = (double)(card2.CflowBalance - transferrecord.TtransferBalance);
cardsService.UpdataFlowBalanceService(card2);
//给对方增加钱,利息同时更新
card1.CflowBalance = (double)(cardsService.FlowBalanceService(card1.Cid)[1] + transferrecord.TtransferBalance);
cardsService.UpdataFlowBalanceService(card1);
transferrecord.TpartyBname = idcardService.QueryService(card1.Cicid).Icname;//找到名字并加入
transferRecordsService.AddtransferRecordsService(transferrecord);
boo = true;
}
}
}
return(boo);
}
/// <summary>
/// 验证密码页面，填写密码
/// </summary>
/// <param name="transfer">包含转账的乙方账号，转账金额</param>
/// <returns></returns>
public IActionResult VerifyPassword(Transferrecords transfer)
{
transferrecords.TpartyBcid = transfer.TpartyBcid; //将数据交给静态数据对象，暂时存起来。
transferrecords.TtransferBalance = transfer.TtransferBalance;
ViewBag.Cid = transfer.TpartyBcid; //向前端展示交易信息，确认
ViewBag.TtransferBalance = transfer.TtransferBalance;
return(View(ViewBag));
}
/// <summary>
/// 根据cid取出最后一次交易记录时间
/// </summary>
/// <param name="cid"></param>
/// <returns></returns>
public DateTime?TransferRecordsTimeData(int cid)
{
DateTime t2 = DateTime.MinValue;
Transferrecords record = new Transferrecords();
record = null;
using (bankContext dbContext = new bankContext())
{
int cid1 = cid;
//取出记录表中该卡活动的记录中取涉及转账时账号为cid的第一项记录，
//记录以降序排列，就可以取出最近对活期存款的操作记录//这里有巴哥
record = dbContext.Transferrecords.FromSql("select * from Transferrecords where TpartyAcid={0} or TpartyBcid={1} order by Tid desc", cid, cid1).AsNoTracking().ToList().FirstOrDefault();
if (record != null)
{
t2 = (DateTime)record.TtransferTime;
}
}
return(t2);
}
public void AddData(Transferrecords transferrecord)
{
using (var dbContext = new bankContext())
{
//修改数据库信息最好有一些事务操作
using (var transaction = dbContext.Database.BeginTransaction())
{
try
{
dbContext.Add(transferrecord);
dbContext.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
transaction.Rollback();
}
}
}
}
internal void AddtransferRecordsService(Transferrecords transferrecord)
{
acessTransferRecords.AddData(transferrecord);
}