public IActionResult CreateProprietar([FromBody] Proprietar proprietar) { if (!ModelState.IsValid) { return(BadRequest()); } SqlCommand cmd = new SqlCommand("INSERT INTO Proprietari VALUES (@Nume, @Prenume, @CNP, @SerieCI, @NumarCI, @Judet, @Localitate, @Adresa, @Telefon, @Email)", conn); //cmd.Parameters.Add("@Nume", SqlDbType.VarChar).Value = proprietar.Nume; cmd.Parameters.AddWithValue("@Nume", proprietar.Nume); cmd.Parameters.AddWithValue("@Prenume", proprietar.Prenume); cmd.Parameters.AddWithValue("@CNP", proprietar.CNP); cmd.Parameters.AddWithValue("@SerieCI", proprietar.SerieCI); cmd.Parameters.AddWithValue("@NumarCI", proprietar.NumarCI); cmd.Parameters.AddWithValue("@Judet", proprietar.Judet); cmd.Parameters.AddWithValue("@Localitate", proprietar.Localitate); cmd.Parameters.AddWithValue("@Adresa", proprietar.Adresa); cmd.Parameters.AddWithValue("@Telefon", proprietar.Telefon); cmd.Parameters.AddWithValue("@Email", proprietar.Email); this.conn.Open(); cmd.ExecuteNonQuery(); this.conn.Close(); return(Ok()); }
async Task CycleProprietari(string fileName, MemoryStream stream) { var judeteAllInclussive = new ConcurrentBag <Judet>(context.Judete.Include(z => z.UATs).ThenInclude(w => w.Localitati)); var x = await Importer.GetDTOs <OutputProprietarAdresa>(stream, fileName, new ImportConfig(), excelConfiguration); IAddressParser addressParser = (IAddressParser)serviceBuilder.GetService("AddressParser"); var addressMatcher = (IMatcher)serviceBuilder.GetService("AddressMatcher"); var matchProcessor = (IMatchProcessor)serviceBuilder.GetService("AddressMatchProcessor"); object locker = new object(); Parallel.ForEach(x, y => { var z = new Proprietar(); lock (locker) { context.Proprietari.Add(z); } z.FromDTO(y); z.Adresa.FromDTO(y, judeteAllInclussive, addressParser, addressMatcher, matchProcessor); z.Adresa.Intravilan = true; }); }
public ActionResult DeleteConfirmed(string id) { Proprietar proprietar = db.Proprietari.Find(id); db.Proprietari.Remove(proprietar); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Cnp,Nume,Prenume,Adresa")] Proprietar proprietar) { if (ModelState.IsValid) { db.Entry(proprietar).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(proprietar)); }
public ActionResult Create([Bind(Include = "Cnp,Nume,Prenume,Adresa")] Proprietar proprietar) { if (ModelState.IsValid) { db.Proprietari.Add(proprietar); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(proprietar)); }
private static void ExportProprietar(ISheet sheet, string[] columnNames, Proprietar proprietar, ProprietarValidator validatorP, AdresaValidator validatorA, string ruleSet) { var resultP = validatorP.Validate(proprietar, ruleSet: ruleSet); var resultA = validatorA.Validate(proprietar.Adresa, ruleSet: ruleSet); var excelDTO = new OutputProprietarAdresa(); excelDTO.FromPOCO(proprietar); excelDTO.FromPOCO(proprietar.Adresa); var row = sheet.CreateRow(excelDTO.RowIndex); writeRow(row, columnNames, excelDTO, false, resultP, resultA); }
public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Proprietar proprietar = db.Proprietari.Find(id); if (proprietar == null) { return(HttpNotFound()); } return(View(proprietar)); }
public static void FromPOCO(this OutputProprietarAdresa propDTO, Proprietar prop) { propDTO.RowIndex = prop.ExcelRow; propDTO.Index = prop.Index; propDTO.Nume = prop.Nume; propDTO.Initiala = prop.Initiala; propDTO.Prenume = prop.Prenume; propDTO.TipActIdentitate = prop.TipActIdentitate.HasValue ? prop.TipActIdentitate.ToString() : null; propDTO.Serie = prop.Serie; propDTO.Numar = prop.Numar; propDTO.Identificator = prop.Identificator; propDTO.Emitent = prop.Emitent; propDTO.DataEmiterii = prop.DataEmiterii; }
public Proprietar GetProprietar(int id) { this.conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM Proprietari WHERE ID = @id", conn); cmd.Parameters.AddWithValue("@id", id); using (SqlDataReader reader = cmd.ExecuteReader()) { reader.Read(); var proprietar = new Proprietar(reader, conn); return(proprietar); } }
public List <Proprietar> GetProprietari() { this.conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM Proprietari", conn); using (SqlDataReader reader = cmd.ExecuteReader()) { List <Proprietar> personRecords = new List <Proprietar>(); while (reader.Read()) { Proprietar p = new Proprietar(reader, conn); personRecords.Add(p); } return(personRecords); } }
public IActionResult UpdateProprietar(int id, [FromBody] Proprietar proprietar) { SqlCommand cmd = new SqlCommand("UPDATE Proprietari SET Nume = @nume, Prenume = @prenume, CNP=@cnp, SerieCI = @serieCI, NumarCI=@numarCI," + " Judet = @judet, Localitate = @localitate , Adresa = @adresa, Telefon = @telefon, Email = @email WHERE ID = @id ", conn); cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@nume", proprietar.Nume); cmd.Parameters.AddWithValue("@prenume", proprietar.Prenume); cmd.Parameters.AddWithValue("@cnp", proprietar.CNP); cmd.Parameters.AddWithValue("@serieCI", proprietar.SerieCI); cmd.Parameters.AddWithValue("@numarCI", proprietar.NumarCI); cmd.Parameters.AddWithValue("@judet", proprietar.Judet); cmd.Parameters.AddWithValue("@localitate", proprietar.Localitate); cmd.Parameters.AddWithValue("@adresa", proprietar.Adresa); cmd.Parameters.AddWithValue("@telefon", proprietar.Telefon); cmd.Parameters.AddWithValue("@email", proprietar.Email); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); return(Ok()); }
public static void FromDTO(this Proprietar prop, OutputProprietarAdresa propDTO) { prop.ExcelRow = propDTO.RowIndex; prop.Index = propDTO.Index.Value; prop.Nume = propDTO.Nume; prop.Initiala = propDTO.Initiala; prop.Prenume = propDTO.Prenume; object tipact; if (Enum.TryParse(typeof(TipActIdentitate), propDTO.TipActIdentitate, true, out tipact)) { prop.TipActIdentitate = (TipActIdentitate)tipact; } prop.Serie = propDTO.Serie; prop.Numar = propDTO.Numar; prop.Identificator = propDTO.Identificator; prop.Emitent = propDTO.Emitent; prop.DataEmiterii = propDTO.DataEmiterii; prop.TipPersoana = tipPersoana(prop); prop.Sex = prop.TipPersoana == TipPersoana.F ? prop.Identificator.HasValue && (int)prop.Identificator.ToString()[0] % 2 == 1 ? Sex.M : Sex.F : (Sex?)null; TipPersoana tipPersoana(Proprietar p) { if (string.IsNullOrEmpty(p.Nume) || p.Nume.Equals("NEDIENTIFICAT", StringComparison.InvariantCultureIgnoreCase)) { return(TipPersoana.N); } return(Validation.isValidCNP(p.Identificator) || !String.IsNullOrEmpty(p.Prenume) ? TipPersoana.F : TipPersoana.J); } }
public static void Initialize(LibraryContext context) { context.Database.EnsureCreated(); if (context.Camere.Any()) { return; // BD a fost creata anterior } var camere = new Camera[] { new Camera { CameraID = 01, Etaj = 0, TipPat = "Matrimonial", PretNoapte = Decimal.Parse("300"), }, new Camera { CameraID = 02, Etaj = 1, TipPat = "Simplu", PretNoapte = Decimal.Parse("250") }, new Camera { CameraID = 03, Etaj = 2, TipPat = "Dublu", PretNoapte = Decimal.Parse("270") }, new Camera { CameraID = 11, Etaj = 3, TipPat = "Matrimonial", PretNoapte = Decimal.Parse("270") }, new Camera { CameraID = 21, Etaj = 4, TipPat = "Simplu", PretNoapte = Decimal.Parse("320") }, new Camera { CameraID = 31, Etaj = 5, TipPat = "Matrimonial", PretNoapte = Decimal.Parse("400") } }; foreach (Camera s in camere) { context.Camere.Add(s); } context.SaveChanges(); var clienti = new Client[] { new Client { ClientID = 101, NumeClient = "AndreiMaria", Sex = "Feminin", DataDeNastere = DateTime.Parse("1989-10-07") }, new Client { ClientID = 102, NumeClient = "IonescuStefania", Sex = "Feminin", DataDeNastere = DateTime.Parse("1998-11-07") }, new Client { ClientID = 103, NumeClient = "MihaiAndrei", Sex = "Masculin", DataDeNastere = DateTime.Parse("1973-01-11") }, new Client { ClientID = 104, NumeClient = "DavidAnton", Sex = "Masculin", DataDeNastere = DateTime.Parse("1990-02-03") }, new Client { ClientID = 105, NumeClient = "AntoniaStefan", Sex = "Feminini", DataDeNastere = DateTime.Parse("2000-08-11") }, new Client { ClientID = 106, NumeClient = "VladConstantin", Sex = "Masculin", DataDeNastere = DateTime.Parse("1995-07-05") } }; foreach (Client c in clienti) { context.Clienti.Add(c); } context.SaveChanges(); var rezervari = new Rezervare[] { new Rezervare { ClientID = 101, CameraID = 01, NumarNopti = 1, DataRezervare = DateTime.Parse("03-15-2021") }, new Rezervare { ClientID = 102, CameraID = 03, NumarNopti = 4, DataRezervare = DateTime.Parse("11-13-2021") }, new Rezervare { ClientID = 103, CameraID = 02, NumarNopti = 5, DataRezervare = DateTime.Parse("08-23-2021") }, new Rezervare { ClientID = 106, CameraID = 11, NumarNopti = 10, DataRezervare = DateTime.Parse("02-21-2021") }, new Rezervare { ClientID = 104, CameraID = 21, NumarNopti = 3, DataRezervare = DateTime.Parse("08-14-2021") }, new Rezervare { ClientID = 105, CameraID = 31, NumarNopti = 7, DataRezervare = DateTime.Parse("06-17-2021") } }; foreach (Rezervare e in rezervari) { context.Rezervari.Add(e); } context.SaveChanges(); var facturi = new Factura[] { new Factura { ClientID = 101, Statut = "PersoanaFizica", NumarNopti = 1, PretNoapte = Decimal.Parse("270"), TotalFactura = Decimal.Parse("270") }, new Factura { ClientID = 102, Statut = "Persoajuridica", NumarNopti = 10, PretNoapte = Decimal.Parse("270"), TotalFactura = Decimal.Parse("2700") } }; foreach (Factura f in facturi) { context.Facturi.Add(f); } context.SaveChanges(); var proprietari = new Proprietar[] { new Proprietar { NumeProprietar = "Hotel International", Adress = "Strada Palat 5A, Iași 700032" }, new Proprietar { NumeProprietar = "Hotel International1", Adress = "Strada Palat 5A, Iași 700032" }, new Proprietar { NumeProprietar = "Hotel International2", Adress = "Strada Palat 5A, Iași 700032" }, new Proprietar { NumeProprietar = "Hotel International3", Adress = "Strada Palat 5A, Iași 700032" }, new Proprietar { NumeProprietar = "Hotel International4", Adress = "Strada Palat 5A, Iași 700032" }, new Proprietar { NumeProprietar = "Hotel International5", Adress = "Strada Palat 5A, Iași 700032" }, }; foreach (Proprietar p in proprietari) { context.Proprietari.Add(p); } context.SaveChanges(); var camerainchiriata = new CameraInchiriata[] { new CameraInchiriata { CameraID = camere.Single(c => c.Etaj == 0).CameraID, ProprietarID = proprietari.Single(i => i.NumeProprietar == "Hotel International").ProprietarID }, new CameraInchiriata { CameraID = camere.Single(c => c.Etaj == 1).CameraID, ProprietarID = proprietari.Single(i => i.NumeProprietar == "Hotel International1").ProprietarID }, new CameraInchiriata { CameraID = camere.Single(c => c.Etaj == 2).CameraID, ProprietarID = proprietari.Single(i => i.NumeProprietar == "Hotel International2").ProprietarID }, new CameraInchiriata { CameraID = camere.Single(c => c.Etaj == 3).CameraID, ProprietarID = proprietari.Single(i => i.NumeProprietar == "Hotel International3").ProprietarID }, new CameraInchiriata { CameraID = camere.Single(c => c.Etaj == 4).CameraID, ProprietarID = proprietari.Single(i => i.NumeProprietar == "Hotel International4").ProprietarID }, new CameraInchiriata { CameraID = camere.Single(c => c.Etaj == 5).CameraID, ProprietarID = proprietari.Single(i => i.NumeProprietar == "Hotel International5").ProprietarID } }; foreach (CameraInchiriata ci in camerainchiriata) { context.CamereInchiriate.Add(ci); } context.SaveChanges(); }
static string ExportProprietar(Proprietar proprietar) { StringBuilder builder = new StringBuilder("#07#"); switch (proprietar.TipPersoana) { case TipPersoana.N: builder.Append("sr").Append('|'); builder.Append("NEIDENTIFICAT").Append('|'); builder.Append("obs ").Append(proprietar.Observatii).Append('|'); builder.Append("$||||||||||||||||"); break; case TipPersoana.F: builder.Append("pf").Append('|'); builder.Append(proprietar.Nume.Trim().ToUpper()).Append('|'); builder.Append(proprietar.Prenume.Trim().ToUpper()).Append('|'); builder.Append(proprietar.Identificator ?? 9999999999999).Append('|'); //tiganie if (!proprietar.TipActIdentitate.HasValue || proprietar.TipActIdentitate.Value == TipActIdentitate.Deces) { builder.Append(0).Append('|'); //tip builder.Append('|').Append('|'); //serie numar } if (proprietar.TipActIdentitate.HasValue && proprietar.TipActIdentitate.Value != TipActIdentitate.Deces) { switch (proprietar.TipActIdentitate.Value) { case TipActIdentitate.BI: builder.Append(1).Append('|'); break; case TipActIdentitate.CI: builder.Append(2).Append('|'); break; case TipActIdentitate.Pasaport: builder.Append(3).Append('|'); break; } builder.Append(proprietar.Serie).Append('|'); builder.Append(proprietar.Numar).Append('|'); } builder.Append(proprietar.Initiala).Append('|'); builder.Append('|'); // nume anterior builder.Append("RO").Append('|'); //cetatenie builder.Append('|'); //telefon builder.Append('|'); //email if (proprietar.TipActIdentitate.HasValue && proprietar.TipActIdentitate.Value == TipActIdentitate.Deces) // u sure? { builder.Append(1).Append('|'); } else { builder.Append(0).Append('|'); } builder.Append("obs "); if (proprietar.TipActIdentitate.HasValue && proprietar.TipActIdentitate.Value == TipActIdentitate.Deces) { builder.Append("DECEDAT "); if (!string.IsNullOrEmpty(proprietar.Numar) || proprietar.DataEmiterii.HasValue) { builder.Append("Certificat de Deces "); if (!string.IsNullOrEmpty(proprietar.Numar)) { builder.Append($" Nr. {proprietar.Numar} "); } if (proprietar.DataEmiterii.HasValue) { builder.Append($"din {proprietar.DataEmiterii.Value.ToString("dd/MM/yyyy")}"); } } } builder.Append(proprietar.Observatii).Append('|'); break; case TipPersoana.J: builder.Append("pj").Append('|'); builder.Append(proprietar.Nume.Trim().ToUpper()).Append('|'); builder.Append(proprietar.Identificator).Append('|'); builder.Append('|'); //telefon builder.Append('|'); //email builder.Append("obs ").Append(proprietar.Observatii).Append('|'); break; } return(builder.ToString()); }