public ActionResult DeleteConfirmed(string id) { Asigurare asigurare = db.Asigurari.Find(id); db.Asigurari.Remove(asigurare); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "NrInmatriculare,Proprietar,DataValabilitate,Durata")] Asigurare asigurare) { if (ModelState.IsValid) { db.Entry(asigurare).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(asigurare)); }
public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Asigurare asigurare = db.Asigurari.Find(id); if (asigurare == null) { return(HttpNotFound()); } return(View(asigurare)); }
private void b_calculeaza_Click(object sender, EventArgs e) { lAsigurare.Clear(); string nume = tbClientNume.Text; string prenume = tbClientPrenume.Text; int varsta = Convert.ToInt32(tbClientVarsta.Text); string sex = cbClientSex.selectedValue; string cnp = tbClientCNP.Text; string adresa = tbClientAdresa.Text; string nrTelefon = tbClientNrTelefon.Text; string status; StareSanatate.fumator = rbFumator.Checked; if (StareSanatate.fumator == true) { status = "FM"; } else { status = "NFM"; } double sumaAsigurata = Convert.ToDouble(tbSumaAsigurata.Text); double prima = 0; string periadaPlata = cbPerioadaPlata.selectedValue; Random random = new Random(); double lat = random.NextDouble() * (44.539139 - 44.336109) + 44.336109; double lng = random.NextDouble() * (26.236712 - 25.960738) + 25.960738; Asigurare asigurare = new Asigurare(sumaAsigurata, prima, periadaPlata, new DateTime(), nume, prenume, varsta, sex, cnp, adresa, nrTelefon, status); asigurare.Client.Lat = lat; asigurare.Client.Lng = lng; lAsigurare.Add(asigurare); if (cbRezolvaPentru.selectedValue == "Prima Totala") { Asigurare.primaTotala = Convert.ToDouble(tbPrimaTotala.Text); prima = Asigurare.primaTotala - (Asigurare.primaTotala * Asigurare.extraPrima * 100 / (Asigurare.extraPrima * 100 + 100)); tbSumaAsigurata.Text = Convert.ToString(asigurare.calucleazaSumaAsigurare(prima, Constante.MIN_SUMA_ASIG, Constante.MAX_SUMA_ASIG, 0)); } else { prima = asigurare.calculeazaPrima(); Asigurare.primaTotala = prima + (prima * Asigurare.extraPrima); tbPrimaTotala.Text = Convert.ToString(Asigurare.primaTotala); } RezumatIlustrare(); }
public ActionResult Create([Bind(Include = "NrInmatriculare,Proprietar,DataValabilitate,Durata")] Asigurare asigurare) { ProprietarDBContext dbp = new ProprietarDBContext(); AutovehiculDBContext dba = new AutovehiculDBContext(); AsigurareDBContext dbAsig = new AsigurareDBContext(); if (ModelState.IsValid) { string xp = asigurare.Proprietar; string xa = asigurare.NrInmatriculare; var proprietari = from m in dbp.Proprietari select m; var autovehicule = from m in dba.Autovehicule select m; var asigurari = from m in dbAsig.Asigurari select m; proprietari = proprietari.Where(s => s.Cnp.Contains(xp)); autovehicule = autovehicule.Where(s => s.NrInmatriculare.Contains(xa)); // var asigurari1 = asigurari.Where(s => s.Proprietar.Contains(xp)); var asigurari2 = asigurari.Where(s => s.NrInmatriculare.Contains(xa)); int okProprietar = proprietari.Count(); int okAutovehicul = autovehicule.Count(); // int okAsigProprietar = asigurari1.Count(); int okAsigAutovehicul = asigurari2.Count(); if (okProprietar != 0 && okAutovehicul != 0 && okAsigAutovehicul == 0) { db.Asigurari.Add(asigurare); db.SaveChanges(); return(RedirectToAction("Index")); } } return(View(asigurare)); }