static public void Add_Dinamic(string Nume)
{
using (Model1Container context = new Model1Container())
{
Proprietate p = new Proprietate()
{
Name = Nume
};
context.Proprietati.Add(p);
context.SaveChanges();
}
}
public void buyProp(Proprietate p)
{
if (money - p.pret > 0)
{
plata(Base.banca, p.pret);
p.SetOwner(this);
Base.offBuyScreen();
p.ownedByBank = false;
p.Updateprop();
}
else
{
UImagic.showERR = 1;
}
}
public async Task <int> UpdateProprietate(Proprietate proprietate)
{
DynamicParameters p = new DynamicParameters();
p.Add("Cnp", proprietate.Cnp);
p.Add("NrVehicol", proprietate.NrVehicol);
p.Add("DataCumpararii", proprietate.DataCumpararii);
p.Add("Pret", proprietate.Pret);
p.Add("PropId", proprietate.PropId);
var query = @"UPDATE proprietate SET cnp = :Cnp, nrvehicol = :NrVehicol, datacumpararii = :DataCumpararii, pret = :Pret";
var result = await dataAccess.SaveData(query, p, connectionString.OracleConnectionName);
return(result);
}
public async Task <int> CreateProprietate(Proprietate proprietate)
{
DynamicParameters p = new DynamicParameters();
p.Add("Cnp", proprietate.Cnp);
p.Add("NrVehicol", proprietate.NrVehicol);
p.Add("DataCumpararii", proprietate.DataCumpararii);
p.Add("Pret", proprietate.Pret);
var query = @"INSERT INTO proprietate(cnp,nrvehicol,datacumpararii,pret) values(:Cnp,:NrVehicol,Cast(:DataCumpararii as DATE),:Pret)";
var result = await dataAccess.SaveData(query, p, connectionString.OracleConnectionName);
return(result);
}
public ActionResult Put([FromBody] Proprietate proprietate)
{
proprietateData.UpdateProprietate(proprietate);
return(Ok());
}
