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()); }