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