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