private void OpenDetails(MoneyTransferModel model, bool isNew = false, bool?allowSaveIfNoChanges = null)
{
this.OpenDetailsWindow(new MoneyTransferDetailsView(_moneyTransferService, model, isNew, false, allowSaveIfNoChanges), () =>
{
RefreshTodayTransactions();
});
}
public static MoneyTransferModel GetMoneyTransfer(int id, SqlTransaction tran)
{
MoneyTransferModel info = new MoneyTransferModel();
string sql = "select * from MoneyTransfer where ID=@id";
SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int) };
parm[0].Value = id;
//SqlDataReader reader = DBHelper.ExecuteReader(tran, sql, parm, CommandType.Text);
DataTable dt = DBHelper.ExecuteDataTable(tran, sql, parm, CommandType.Text);
if (dt.Rows.Count > 0)
{
info.Id = Convert.ToInt32(dt.Rows[0]["ID"]);
info.Money = Convert.ToDouble(dt.Rows[0]["Money"]);
info.OutConfirmationTime = Convert.ToDateTime(dt.Rows[0]["OutConfirmationTime"]);
info.OutIsConfirm = Convert.ToInt32(dt.Rows[0]["OutIsConfirm"]);
info.OutNumber = dt.Rows[0]["OutNumber"].ToString();
info.Remark = dt.Rows[0]["Remark"].ToString();
info.TransferTime = Convert.ToDateTime(dt.Rows[0]["TransferTime"]);
info.TransferType = Convert.ToInt32(dt.Rows[0]["TransferType"]);
info.TrunConfirmationTime = Convert.ToDateTime(dt.Rows[0]["TrunConfirmationTime"]);
info.TrunIsConfirm = Convert.ToInt32(dt.Rows[0]["TrunIsConfirm"]);
info.TrunNumber = dt.Rows[0]["TrunNumber"].ToString();
}
return(info);
}
public MoneyTransferModel Create(MoneyTransferTemplateModel model, Action <MoneyTransferModel> overrides = null)
{
var moneyTransfer = new MoneyTransferModel()
{
Date = DateTime.Now,
StorageFromId = model.StorageFromId,
StorageToId = model.StorageToId,
CategoryId = model.CategoryId,
Commission = model.Commission,
CommissionType = model.CommissionType,
CurrencyExchangeRate = model.CurrencyExchangeRate,
Description = model.Description,
Remark = model.Remark,
TakeCommissionFromReceiver = model.TakeCommissionFromReceiver,
Value = model.Value,
StorageFrom = model.StorageFrom,
StorageFromCurrency = model.StorageFromCurrency,
StorageTo = model.StorageTo,
StorageToCurrency = model.StorageToCurrency,
StorageFromValue = model.StorageFromValue,
StorageToValue = model.StorageToValue,
Category = model.Category
};
overrides?.Invoke(moneyTransfer);
return(moneyTransfer);
}
public MoneyTransferDetailsView(IMoneyTransferService service, MoneyTransferModel entity, bool isNew,
bool showHiddenStorages, IEnumerable <StorageModel> storages, bool?allowSaveIfNoChanges = null)
: base(service, entity, isNew, allowSaveIfNoChanges)
{
InitializeComponent();
// init
_showHiddenStorages = showHiddenStorages;
_storages = storages;
// initialize datacontexts
IEnumerable <StorageModel> showStorages;
if (_showHiddenStorages)
{
showStorages = storages.OrderByDescending(_ => _.IsVisible).ThenBy(_ => _.Name);
}
else
{
showStorages = storages.Where(_ => _.IsVisible || entity.StorageFromId == _.Id || entity.StorageToId == _.Id)
.OrderBy(_ => _.Name);
}
comboFromStorage.ItemsSource = showStorages;
comboToStorage.ItemsSource = showStorages;
// set currencies list
compCurrencyExchangeRate.CurrencyIds = _storages.Select(_ => _.CurrencyId).Distinct().ToList();
// set header and commands panel context
LabelHeader.Content = ViewHeader;
CommandsPanel.DataContext = Commands;
}
public MoneyTransferDetailsView(IMoneyTransferService service, MoneyTransferModel entity, bool isNew,
bool showHiddenStorages, bool?allowSaveIfNoChanges = null)
: this(service, entity, isNew, showHiddenStorages,
(ServiceManager.ConfigureService <StorageService>() as IStorageService).GetListForUser(GlobalVariables.UserId),
allowSaveIfNoChanges)
{
}
private void OpenDetails(MoneyTransferModel model, bool isNew = false)
{
this.OpenDetailsWindow(new MoneyTransferDetailsView(_moneyTransferService, model, isNew, false), () =>
{
RefreshTodayTransactions();
});
}
private void UpdateStorages(MoneyTransferModel moneyTransfer)
{
var storageFrom = _storages.First(_ => _.Id == moneyTransfer.StorageFromId);
storageFrom.UpdateData(_service.Get(storageFrom.Id));
var storageTo = _storages.First(_ => _.Id == moneyTransfer.StorageToId);
storageTo.UpdateData(_service.Get(storageTo.Id));
}
public IActionResult CheckMobileNumber(MoneyTransferModel input)
{
if (input.MobileNumber == "8898862556")
{
return(View("BeneficiaryList"));
}
else
{
return(View("RegisterUser"));
}
}
public void SendMoneyTransferModel(MoneyTransferModel moneyTransferModel)
{
if (ConnectionExists())
{
using (var channel = _connection.CreateModel())
{
channel.QueueDeclare(queue: _queueName, durable: false, exclusive: false, autoDelete: false, arguments: null);
var json = JsonConvert.SerializeObject(moneyTransferModel);
var body = Encoding.UTF8.GetBytes(json);
channel.BasicPublish(exchange: "", routingKey: _queueName, basicProperties: null, body: body);
}
}
}
private void OpenDetails(MoneyTransferModel model, bool isNew = false)
{
this.OpenDetailsWindow(new MoneyTransferDetailsView(_moneyTransferService, model, isNew, true,
_storages.OrderByDescending(_ => _.IsVisible).ThenBy(_ => _.Name)), () =>
{
// update grid
if (isNew && _areMoneyTransfersLoaded)
{
_viewModel.MoneyTransfers.Insert(0, model);
}
// update storages view
UpdateStorages(model);
NotifyDataChanged();
});
}
private void OpenDetails(MoneyTransferModel model, bool isNew = false)
{
this.OpenDetailsWindow(new MoneyTransferDetailsView(_moneyTransferService, model, isNew, false), () =>
{
// update grid
if (isNew)
{
AddNew(model);
}
else
{
UpdatePlacement(model);
}
//NotifyDataChanged();
});
}
private void OpenDetails(MoneyTransferModel model, bool isNew = false, bool?allowSaveIfNoChanges = null)
{
this.OpenDetailsWindow(new MoneyTransferDetailsView(_moneyTransferService, model, isNew, false,
_storages.OrderByDescending(_ => _.IsVisible).ThenBy(_ => _.Name), allowSaveIfNoChanges), () =>
{
// update grid
if (isNew)
{
AddNew(model);
}
else
{
UpdatePlacement(model);
}
NotifyDataChanged();
});
}
public async Task <IActionResult> makeTransfer([FromHeader] Guid AccountId, [FromBody] MoneyTransferModel transfer)
{
try
{
var response = await _mediator.Send(new SendMoneyTransferCommand(AccountId, transfer));
return(Ok(response));
}
catch (BankAccountNotFoundException e)
{
return(BadRequest(e.Message));
}
catch (BalanceTooLowException e)
{
return(BadRequest(e.Message));
}
catch (TransferToSameAccountException e)
{
return(BadRequest(e.Message));
}
}
public async void TransferMoney(MoneyTransferModel moneyTransferModel)
{
try
{
var response = await _mediator.Send(new CreateMoneyTransferCommand
{
Transfer = moneyTransferModel
});
}
catch (BankAccountNotFoundException e)
{
Debug.WriteLine(e.Message);
}
catch (BalanceTooLowException e)
{
Debug.WriteLine(e.Message);
}
catch (TransferToSameAccountException e)
{
Debug.WriteLine(e.Message);
}
}
/// <summary>
/// 删除转账信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int DelTransfer(int id, MoneyTransferModel info)
{
if (info.TransferType == 1 && info.TrunIsConfirm == 0)
{
string sql = "update MemberInfo set TotalDefray=TotalDefray-@TotalDefray where Number=@Number";
SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@TotalDefray", SqlDbType.Money), new SqlParameter("@Number", SqlDbType.NVarChar, 50) };
parm[0].Value = info.Money;
parm[1].Value = info.OutNumber;
int num = DBHelper.ExecuteNonQuery(sql, parm, CommandType.Text);
}
if (info.TransferType == 2 && info.TrunIsConfirm == 0)
{
string sql = "update MemberInfo set Out=Out-@Out where Number=@Number";
SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@Out", SqlDbType.Money), new SqlParameter("@Number", SqlDbType.NVarChar, 50) };
parm[0].Value = info.Money;
parm[1].Value = info.OutNumber;
int num = DBHelper.ExecuteNonQuery(sql, parm, CommandType.Text);
}
string sql1 = "delete MoneyTransfer where id=@id";
SqlParameter[] parm1 = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int) };
parm1[0].Value = id;
return(DBHelper.ExecuteNonQuery(sql1, parm1, CommandType.Text));
}
public SendMoneyTransferCommand(Guid accountId, MoneyTransferModel transfer)
{
Transfer = transfer;
Transfer.SourceAccountId = accountId;
}
private void HandleMessage(MoneyTransferModel moneyTransferModel)
{
_moneyTransferService.TransferMoney(moneyTransferModel);
}
/// <summary>
/// 添加转账记录
/// </summary>
/// <param name="info"></param>
public static void AddTransfer(MoneyTransferModel info, out int outid)
{
ReleaseDAL.AddTransfer(info, out outid);
}
/// <summary>
/// 添加转账记录
/// </summary>
/// <param name="info"></param>
public static bool AddTransfer(SqlTransaction tran, MoneyTransferModel info, out int outid)
{
return(ReleaseDAL.AddTransfer(tran, info, out outid));
}
private void OpenDetails(MoneyTransferModel model)
{
this.OpenDetailsWindow(new MoneyTransferDetailsView(_moneyTransferService, model, false, false), ReloadActual);
}
public MoneyTransferDetailsView(MoneyTransferModel entity, bool isNew,
bool showHiddenStorages, IEnumerable <StorageModel> storages)
: this(ServiceManager.ConfigureService <MoneyTransferService>(), entity, isNew, showHiddenStorages, storages)
{
}
public MoneyTransferDetailsView(MoneyTransferModel entity, bool isNew, bool showHiddenStorages)
: this(ServiceManager.ConfigureService <MoneyTransferService>(), entity, isNew, showHiddenStorages,
(ServiceManager.ConfigureService <StorageService>() as IStorageService).GetListForUser(GlobalVariables.UserId))
{
}
/// <summary>
/// 删除转账信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int DelTransfer(int id, MoneyTransferModel info)
{
return(ECRemitDetailDAL.DelTransfer(id, info));
}
public MoneyTransferPresenter()
{
moneyTransferModel = new MoneyTransferModel();
}
private void OpenDetails(MoneyTransferModel model, bool isNew = false) => this.OpenDetailsWindow(new MoneyTransferDetailsView(model, isNew, false), () => NotifyDataChanged());
