public async Task <ObjectResult> UpdateDepozitAsync([FromBody] GeneralDepozitRequest request, [FromRoute] int id)
{
Depozit result = _depozitServices.DepozitRepository.Update(request.ToDTO(id));
await _depozitServices.CommitChanges();
return(Ok(result));
}
public static Depozit GetDepozitByID(int id)
{
Depozit newdep = new Depozit();
using (SqlConnection connection = new SqlConnection(SqlConnectionDB.ConnectionString))
{
string oString = "Select * from Depozit where id=@cid";
SqlCommand oCmd = new SqlCommand(oString, connection);
oCmd.Parameters.AddWithValue("@cid", id);
connection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
if (oReader != null)
{
while (oReader.Read())
{
newdep.ID = Int32.Parse(oReader["id"].ToString());
newdep.Adresa = oReader["adresa"].ToString();
newdep.Dimensiune = oReader["dimensiune"].ToString();
newdep.Chirie = Int32.Parse(oReader["chirie"].ToString());
}
}
connection.Close();
}
}
return(newdep);
}
public async Task <ObjectResult> CreateDepozitAsync([FromBody] GeneralDepozitRequest request)
{
Depozit result = await _depozitServices.DepozitRepository.CreateAsync(request.ToDTO());
await _depozitServices.CommitChanges();
return(Ok(result));
}
public async Task <ObjectResult> DeleteDepozitAsync([FromRoute] int id)
{
Depozit depozit = await _depozitServices.DepozitRepository.GetByIdAsync(id);
_depozitServices.DepozitRepository.Delete(depozit);
await _depozitServices.CommitChanges();
return(Ok(depozit));
}
public void FurnizorConstructor()
{
Depozit depozit = new Depozit();
depozit.Furnizori.Add(new ConsignatieMagazinBiblioteca.Furnizor
{
Nume = "TORJE", Prenume = "David",
});
Assert.IsNotNull(depozit); //succes
}
public void ItemConstructor()
{
Depozit depozit = new Depozit();
Furnizor prov = new Furnizor();
depozit.Items.Add(new Item
{
Title = "Jane Eyre",
Descriere = "A book about a girl",
Pret = 1.50M,
NumberOfItems = 7,
Owner = prov
});
Assert.IsNotNull(depozit); //succes
}
public static Depozit GetAvailableDepozit()
{
Depozit newdep = new Depozit();
using (SqlConnection connection = new SqlConnection(SqlConnectionDB.ConnectionString))
{
string oString = @"
Select x.depid,COUNT(x.livid) as nrlivrari
FROM(
Select Depozit.id as depid,Depozit.adresa as adresa,Depozit.chirie as chirie,Depozit.dimensiune as dimensiune,Livraredepozit.id as livid
FROM Depozit
LEFT JOIN Livraredepozit ON Livraredepozit.depozitid = Depozit.id
WHERE Livraredepozit.status = 2 or Livraredepozit.status is null)as x
GROUP BY x.depid
ORDER BY nrlivrari
";
SqlCommand oCmd = new SqlCommand(oString, connection);
connection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
if (oReader != null)
{
if (oReader.Read())
{
newdep.ID = Int32.Parse(oReader["depid"].ToString());
}
}
connection.Close();
}
}
return(newdep);
}
private void ValidCommandHandler(object sender, ExecutedRoutedEventArgs e)
{
//pe baza lui currentItem fac un depozit
var request = depoziteViewSource.View.CurrentItem as Depozit_Requests;
Depozit depozit = new Depozit
{
CodClient = request.CodClient,
DataDepunerii = request.DataDepunerii,
Suma = (int)request.Suma
};
context.Depozits.Add(depozit);
context.SaveChanges();
MessageBox.Show("Depozit adaugat cu succes");
//adaug suma in Cont.sold
var query_addSuma = (from c in context.Conturis
where c.Client == request.CodClient
select c).FirstOrDefault();
query_addSuma.Sold += request.Suma;
context.SaveChanges();
//sterg intrarea din Depozit_Requests
var query_stergere = (from d in context.Depozit_Requests
where d.CodDepozitRequest == request.CodDepozitRequest
select d).FirstOrDefault();
context.Depozit_Requests.Remove(query_stergere);
context.SaveChanges();
initializeCollectionView();
initializeBoxes();
}
/// <summary>
/// create robot
/// создать робота
/// </summary>
public static BotPanel GetStrategyForName(string nameClass, string name, StartProgram startProgram, bool isScript)
{
BotPanel bot = null;
// примеры и бесплатные боты
if (isScript && bot == null)
{
bot = CreateScriptStrategyByName(nameClass, name, startProgram);
return(bot);
}
if (nameClass == "Breakdown")
{
bot = new Breakdown(name, startProgram);
}
if (nameClass == "Hftone")
{
bot = new Hftone(name, startProgram);
}
if (nameClass == "Frank_2")
{
bot = new Frank_2(name, startProgram);
}
if (nameClass == "Frankbol_for_bnb")
{
bot = new Frankbol_for_bnb(name, startProgram);
}
if (nameClass == "Frankbol")
{
bot = new Frankbol(name, startProgram);
}
if (nameClass == "Frank")
{
bot = new Frank(name, startProgram);
}
if (nameClass == "Storog")
{
bot = new Storog(name, startProgram);
}
if (nameClass == "Depozit")
{
bot = new Depozit(name, startProgram);
}
if (nameClass == "Ver_01")
{
bot = new Ver_01(name, startProgram);
}
if (nameClass == "NewParabol")
{
bot = new NewParabol(name, startProgram);
}
if (nameClass == "Start")
{
bot = new Start(name, startProgram);
}
if (nameClass == "RobotPriceChannel")
{
bot = new RobotPriceChannel(name, startProgram);
}
if (nameClass == "SmaScreener")
{
bot = new SmaScreener(name, startProgram);
}
if (nameClass == "ScreenerEngine")
{
bot = new ScreenerEngine(name, startProgram);
}
if (nameClass == "SmaTrendSample")
{
bot = new SmaTrendSample(name, startProgram);
}
if (nameClass == "TimeOfDayBot")
{
bot = new TimeOfDayBot(name, startProgram);
}
if (nameClass == "Fisher")
{
bot = new Fisher(name, startProgram);
}
if (nameClass == "FundBalanceDivergenceBot")
{
bot = new FundBalanceDivergenceBot(name, startProgram);
}
if (nameClass == "BbPowerTrade")
{
bot = new BbPowerTrade(name, startProgram);
}
if (nameClass == "BollingerRevers")
{
bot = new BollingerRevers(name, startProgram);
}
if (nameClass == "BollingerTrailing")
{
bot = new BollingerTrailing(name, startProgram);
}
if (nameClass == "CciTrade")
{
bot = new CciTrade(name, startProgram);
}
if (nameClass == "MacdRevers")
{
bot = new MacdRevers(name, startProgram);
}
if (nameClass == "MacdTrail")
{
bot = new MacdTrail(name, startProgram);
}
if (nameClass == "OneLegArbitrage")
{
bot = new OneLegArbitrage(name, startProgram);
}
if (nameClass == "PairRsiTrade")
{
bot = new PairRsiTrade(name, startProgram);
}
if (nameClass == "PriceChannelBreak")
{
bot = new PriceChannelBreak(name, startProgram);
}
if (nameClass == "PriceChannelVolatility")
{
bot = new PriceChannelVolatility(name, startProgram);
}
if (nameClass == "RsiTrade")
{
bot = new RsiTrade(name, startProgram);
}
if (nameClass == "RviTrade")
{
bot = new RviTrade(name, startProgram);
}
if (nameClass == "MomentumMACD")
{
bot = new MomentumMacd(name, startProgram);
}
if (nameClass == "Engine")
{
bot = new CandleEngine(name, startProgram);
}
if (nameClass == "ClusterEngine")
{
bot = new ClusterEngine(name, startProgram);
}
if (nameClass == "PairTraderSimple")
{
bot = new PairTraderSimple(name, startProgram);
}
if (nameClass == "EnvelopTrend")
{
bot = new EnvelopTrend(name, startProgram);
}
if (nameClass == "ClusterCountertrend")
{
bot = new ClusterCountertrend(name, startProgram);
}
if (nameClass == "PatternTrader")
{
bot = new PatternTrader(name, startProgram);
}
if (nameClass == "HighFrequencyTrader")
{
bot = new HighFrequencyTrader(name, startProgram);
}
if (nameClass == "PivotPointsRobot")
{
bot = new PivotPointsRobot(name, startProgram);
}
if (nameClass == "Williams Band")
{
bot = new StrategyBillWilliams(name, startProgram);
}
if (nameClass == "MarketMakerBot")
{
bot = new MarketMakerBot(name, startProgram);
}
if (nameClass == "ParabolicSarTrade")
{
bot = new ParabolicSarTrade(name, startProgram);
}
if (nameClass == "PriceChannelTrade")
{
bot = new PriceChannelTrade(name, startProgram);
}
if (nameClass == "WilliamsRangeTrade")
{
bot = new WilliamsRangeTrade(name, startProgram);
}
if (nameClass == "SmaStochastic")
{
bot = new SmaStochastic(name, startProgram);
}
if (nameClass == "PinBarTrade")
{
bot = new PinBarTrade(name, startProgram);
}
if (nameClass == "TwoLegArbitrage")
{
bot = new TwoLegArbitrage(name, startProgram);
}
if (nameClass == "ThreeSoldier")
{
bot = new ThreeSoldier(name, startProgram);
}
if (nameClass == "RsiContrtrend")
{
bot = new RsiContrtrend(name, startProgram);
}
if (nameClass == "PairTraderSpreadSma")
{
bot = new PairTraderSpreadSma(name, startProgram);
}
if (BotsWithAttribute.ContainsKey(nameClass))
{
Type botType = BotsWithAttribute[nameClass];
bot = (BotPanel)Activator.CreateInstance(botType, name, startProgram);
}
return(bot);
}
public async Task <ObjectResult> GetDepozitAsync([FromRoute] int id)
{
Depozit result = await _depozitServices.DepozitRepository.GetByIdAsync(id);
return(Ok(result));
}
