/// <summary>
/// 根据封装登录信息的对象User（卡或储户）
/// </summary>
/// <param name="user">Id，Password，Identify</param>
/// <returns>Depositors</returns>
public DepositorAndCard QueryDepositorsService(User user)
{
Depositors depositor = new Depositors(); //接受返回值
DepositorAndCard depositors = new DepositorAndCard(); //函数将要返回的对象
depositor = accessDepositors.QueryDepositorsData(user);
if (depositor != null)
{
if (depositor.Uid != user.Id)
{
depositors = null;
}
else
{
depositors.Duid = depositor.Uid;
depositors.Dcid = depositor.Ucid;
if (depositor.Ucid == null)
{
depositors.Dname = "您还没有绑定银行卡";
}
else
{
depositors.Dname = idcardService.QueryService(depositor.Uicid).Icname;
}
}
}
else
{
depositors = null;
}
return(depositors);
}
/// <summary>
/// 查询卡通过传入的User查询。User：Id,Password,Identify
/// </summary>
/// <param name="user">传入登录信息，账号Id,Password,Identify</param>
/// <returns></returns>
public DepositorAndCard QueryCardsService(User user)
{
DepositorAndCard cards = new DepositorAndCard(); //函数将要返回的对象
Cards card = new Cards(); //接受查询结果数据
Depositors depositor = new Depositors(); //接受查询结果数据
card = CardsAccess.QueryCardsData(user);
if (card != null) //查询不空
{
if (card.Cid != user.Id) //不是要查询的对象
{
cards = null;
}
else
{
cards.Duid = (int)card.Cuid;//返回对象装入值
cards.Dcid = card.Cid;
cards.Dname = idcardService.QueryService(card.Cicid).Icname;
}
}
else
{
cards = null;
}
return(cards);
}
/// <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="uid"></param>
/// <returns></returns>
public Depositors CheakData(int uid)
{
Depositors depositor = new Depositors();
using (var dbContext = new bankContext())
{
return(depositor = dbContext.Depositors.FirstOrDefault(a => a.Uid == uid));
}
}
/// <summary>
/// 传入的对象为User
/// </summary>
/// <param name="user">传入登录信息，账号Id,Password,Identify</param>
/// <returns></returns>
public Depositors QueryDepositorsData(User user)
{
Depositors depositor = new Depositors();
using (var dbContext = new bankContext())
{
depositor = dbContext.Depositors.FromSql("select * from Depositors where Uid= {0} and Upassword={1} ",
user.Id, user.Password).AsNoTracking().ToList().FirstOrDefault();
return(depositor);
}
}
//2.将返回的信息进行处理，然后登陆系统主页
/// <summary>
/// 增加储户，并登录到储户系统
/// </summary>
/// <param name="depositor">传入前端页面填写的信息，参数对象Depositors：Uid，Uicid，Upassword </param>
/// <returns></returns>
public IActionResult AddLogin(Depositors depositor)
{
depositor.Upassword = MD5Encrypt64(depositor.Upassword);
DepositorAndCard depositors = new DepositorAndCard();
depositors = depositorServive.AddService(depositor);
if (depositors != null)
{
cooikeAdd(depositors);
return(RedirectToAction("Login", "Depositors", depositors));
}
else
{
return(Redirect(Url.Action("DepositoryExistError", "Errors")));
}
}
/// <summary>
/// 判断是否增加储户成功
/// </summary>
/// <param name="depositor">表单填写的储户信息Uid,Uname,UPassword</param>
/// <returns>DepositorAndCard</returns>
public DepositorAndCard AddService(Depositors depositor)
{
DepositorAndCard depositors = new DepositorAndCard();
Depositors depositor1 = new Depositors();
depositor1 = accessDepositors.CheakData(depositor.Uid);//查询有没有该储户
if (depositor1 != null)
{
depositors = null;
}
else
{
accessDepositors.AddData(depositor);
depositors.Duid = depositor.Uid;
depositors.Dname = "请绑定银行卡";
}
return(depositors);
}
/// <summary>
/// 增加账户
/// </summary>
/// <param name="depositor">传入前端页面填写的信息，参数对象Depositors：Uid，Uname，Upassword</param>
public void AddData(Depositors depositor)
{
using (var dbContext = new bankContext())
{
//修改数据库信息最好有一些事务操作
using (var transaction = dbContext.Database.BeginTransaction())
{
try
{
dbContext.Add(depositor);
dbContext.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
transaction.Rollback();
}
}
}
}
/// <summary>
/// 查询银行卡登录
/// </summary>
/// <param name="user">传入登录信息，账号Id,Password,Identify</param>
/// <returns></returns>
public DepositorAndCard QueryDepositorData(User user)
{
Depositors depositors = new Depositors(); //接受查询到的数据
DepositorAndCard dAndC = new DepositorAndCard(); //函数将返回DepositorAndCard对象
using (var dbContext = new bankContext())
{
depositors = dbContext.Depositors.FirstOrDefault(a => a.Uid == user.Id);
//判断是否为正确
if (depositors != null && depositors.Upassword == user.Password)
{
using (var viewContext = new ViewContext()) //视图查询环境
{
dAndC = viewContext.DepositorAndCard.FirstOrDefault(a => a.Dcid == depositors.Ucid); //返回储户和该用户默认的卡号组成的视图
}
}
else
{
dAndC = null;
}
}
return(dAndC);
}
/// <summary>
/// 储户绑定卡号,先找到该储户，然后找到该储户要绑定的银行卡，最后绑定
/// </summary>
/// <param name="depositor">前端传入DepositorAndCard对象，属性：Duid,Dname,Dcid</param>
/// <returns></returns>
public DepositorAndCard UpdataBandService(DepositorAndCard depositor)
{
Idcard idcard = new Idcard();
DepositorAndCard DAndC = new DepositorAndCard(); //返回对象
Cards card = new Cards(); //接受返回数据
Depositors depositor1 = new Depositors(); //接受查询到的数据
depositor1 = accessDepositors.CheakData(depositor.Duid); //查询有没有该储户
if (depositor1 != null) //有数据
{
if (depositor1.Uid == depositor.Duid) //判断查找到的储户是不是我们要找的
{
card = cardsService.CheakCardsService((int)depositor.Dcid);
if (card != null && card.Cuid == depositor.Duid && card.Cicid == depositor.Dicid) //判断查找到的银行卡是不是我们要找的
{
accessDepositors.UpdataBandData(depositor); //更新绑定卡号
idcard = idcardService.QueryService(card.Cicid);
DAndC.Dname = idcard.Icname;
DAndC.Dcid = depositor.Dcid;
DAndC.Duid = depositor.Duid;
}
else
{
DAndC = null;
}
}
else
{
DAndC = null;
}
}
else
{
DAndC = null;
}
return(DAndC);
}
