public SetAsSelled(DealEntity deal)
{
this.deal = deal;
SetDealInfo();
InitializeComponent();
DataContext = this;
}
public DealForm(DealEntity newDeal, int userID)
{
this.userID = userID;
this.newDeal = newDeal;
InitializeComponent();
fillType();
DataContext = this;
}
private async Task DoAdd(SqlConnection conn, SqlTransaction transaction, IPositionHistory positionHistory, IDeal deal)
{
var positionEntity = PositionsHistoryEntity.Create(positionHistory);
await conn.ExecuteAsync($"insert into {TableName} ({GetColumns}) values ({GetFields})",
positionEntity,
transaction);
if (deal != null)
{
var entity = DealEntity.Create(deal);
await conn.ExecuteAsync(
$@"INSERT INTO [dbo].[Deals] ({string.Join(",", DealsSqlRepository.DealInsertColumns)}) VALUES (@{string.Join(",@", DealsSqlRepository.DealInsertColumns)})",
new
{
entity.DealId,
entity.Created,
entity.AccountId,
entity.AssetPairId,
entity.OpenTradeId,
entity.OpenOrderType,
entity.OpenOrderVolume,
entity.OpenOrderExpectedPrice,
entity.CloseTradeId,
entity.CloseOrderType,
entity.CloseOrderVolume,
entity.CloseOrderExpectedPrice,
entity.Direction,
entity.Volume,
entity.Originator,
entity.OpenPrice,
entity.OpenFxPrice,
entity.ClosePrice,
entity.CloseFxPrice,
entity.Fpl,
entity.PnlOfTheLastDay,
entity.AdditionalInfo,
entity.CorrelationId
},
transaction);
await conn.ExecuteAsync("INSERT INTO [dbo].[DealCommissionParams] (DealId) VALUES (@DealId)",
new { deal.DealId },
transaction);
}
}
private void AddDealButton_Click(object sender, RoutedEventArgs e)
{
DealEntity newDeal = new DealEntity();
DealForm df = new DealForm(newDeal, this.user.ID);
new Thread(x =>
{
while (true)
{
if (df.FlagIsClosed)
{
DealOption.AddnewItem(newDeal);
daySpent += newDeal.Price;
ReadyToRefresh = true;
break;
}
}
}).Start();
df.Show();
}
public static string AddnewItem(DealEntity pladged)
{
using (var dbConnection = new DatabaseContext())
{
try
{
dbConnection.Deals.Add(pladged);
dbConnection.SaveChanges();
//user.spent += pladged.Price;
//UserOption.updateUser(ref user);
return("Готово");
}
catch (Exception)
{
return("Something went wrong");
}
}
}
public static void updateDeal(DealEntity ModifiedDeal)
{
using (var dbConnection = new DatabaseContext())
{
int pladgedID = ModifiedDeal.ID;
var deal = dbConnection.Deals.SingleOrDefault(x => x.ID == pladgedID);
if (deal != null)
{
deal.DealType = ModifiedDeal.DealType;
deal.IsClosed = ModifiedDeal.IsClosed;
deal.ItemDesc = ModifiedDeal.ItemDesc;
deal.SelledFor = ModifiedDeal.SelledFor;
deal.ClientName = ModifiedDeal.ClientName;
dbConnection.SaveChanges();
}
else
{
dbConnection.Deals.Add(ModifiedDeal);
dbConnection.SaveChanges();
}
}
}
