public Serviciu getServiciu(String nume) { Serviciu ser = null; String sql = "SELECT * FROM serviciu WHERE nume=@numeServiciu"; try { _conn.Open(); SqlCommand cmd = new SqlCommand(sql, _conn); cmd.Parameters.AddWithValue("@numeServiciu", nume); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { ser = new Serviciu(reader["nume"].ToString(), float.Parse(reader["pret"].ToString())); } _conn.Close(); } catch (SqlException e) { Console.WriteLine(e.Message); return(null); } return(ser); }
public async Task <IActionResult> DeleteConfirmed(int id) { Serviciu serviciu = _serviciuService.GetServiciu(id); _serviciuService.StergereServiciu(serviciu); return(RedirectToAction(nameof(Index))); }
public async Task <IHttpActionResult> Put(int id, [FromBody] Serviciu serviciu) { if (serviciu.numeServiciu == "") { return(BadRequest("The name cannot be blank or is not privided")); } if (serviciu.pret == 0) { return(BadRequest("The price cannot be 0 or is not provided")); } var code = await ServiciiDao.updateServiciuAsync(id, serviciu); if (code == 1) { return(Ok("Service updated")); } else if (code == 0) { return(NotFound()); } else { return(Content(HttpStatusCode.InternalServerError, "Error occured.")); } }
public async Task <IHttpActionResult> Post([FromBody] Serviciu serviciu) { try { if (serviciu.numeServiciu == "") { return(BadRequest("The name cannot be blank")); } if (serviciu.pret == 0) { return(BadRequest("The price cannot be 0")); } if (await ServiciiDao.addServiciuAsync(serviciu) == 1) { return(Content(HttpStatusCode.Created, "Service created")); } else { return(Content(HttpStatusCode.InternalServerError, "Error occured")); } } catch (NullReferenceException e) { return(Content(HttpStatusCode.BadRequest, e)); } }
public List <Serviciu> getAllServicii() { String sql = "SELECT * FROM serviciu"; List <Serviciu> servicii = new List <Serviciu>(); try { _conn.Open(); SqlCommand cmd = new SqlCommand(sql, _conn); SqlDataReader reader = cmd.ExecuteReader(); Serviciu serviciu = null; while (reader.Read()) { serviciu = new Serviciu(reader["nume"].ToString(), float.Parse(reader["pret"].ToString())); servicii.Add(serviciu); } _conn.Close(); } catch (SqlException e) { Console.WriteLine(e.Message); return(null); } return(servicii); }
public static async Task <List <Serviciu> > findAllServiciiAsync() { List <Serviciu> servicii = new List <Serviciu>(); const string getAllQuery = "select * from hotelDB.dbo.ServiciiSuplimentare;"; var conn = DBConnection.openConn(); using (var cmd = new SqlCommand(getAllQuery, conn)) using (var reader = await cmd.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { Serviciu curr = new Serviciu(); curr.id = reader.GetInt32(0); curr.numeServiciu = reader.GetString(1); curr.pret = reader.GetInt32(2); servicii.Add(curr); } cmd.Dispose(); reader.Close(); } return(servicii); }
public static async Task <int> addServiciuAsync(Serviciu newServiciu) { const string insertQuery = "insert into hotelDB.dbo.ServiciiSuplimentare(nume, pret) values (@numeServiciu, @pretServiciu);"; var conn = DBConnection.openConn(); using (var cmd = new SqlCommand(insertQuery, conn)) using (var dataAdapter = new SqlDataAdapter()) { cmd.Parameters.AddWithValue("@numeServiciu", newServiciu.numeServiciu); cmd.Parameters.AddWithValue("@pretServiciu", newServiciu.pret); try { dataAdapter.InsertCommand = cmd; await dataAdapter.InsertCommand.ExecuteNonQueryAsync(); cmd.Dispose(); dataAdapter.Dispose(); return(1); } catch { return(-1); } } }
public static async Task <int> updateServiciuAsync(int id, Serviciu updated) { if (await findServiciuByIdAsync(id) == null) { return(0); } const string updateQuery = "update hotelDB.dbo.ServiciiSuplimentare set nume = @numeServiciu, pret = @pretServiciu where id = @id;"; var conn = DBConnection.openConn(); using (var cmd = new SqlCommand(updateQuery, conn)) using (var dataAdapter = new SqlDataAdapter()) { cmd.Parameters.AddWithValue("@numeServiciu", updated.numeServiciu); cmd.Parameters.AddWithValue("@pretServiciu", updated.pret); cmd.Parameters.AddWithValue("@id", id); try { dataAdapter.UpdateCommand = cmd; await dataAdapter.UpdateCommand.ExecuteNonQueryAsync(); cmd.Dispose(); dataAdapter.Dispose(); return(1); } catch (Exception e) { Debug.WriteLine(e); return(-1); } } }
public List <Programare> listaProgramariClient(String numeClient) { List <Programare> programari = _programareDAO.getProgramariClient(numeClient); if (programari != null) { foreach (Programare programare in programari) { List <ProgramareServiciu> programareServiciuList = _programareServiciuDAO.selectServiciiClient(programare.getId()); List <Serviciu> servicii = new List <Serviciu>(); foreach (ProgramareServiciu programareServiciu in programareServiciuList) { Serviciu serv = _serviciuDAO.getServiciu(programareServiciu.getNumeServiciu()); servicii.Add(serv); } programare.setServicii(servicii); } } else { return(null); } return(programari); }
public static async Task <Serviciu> findServiciuByIdAsync(int id) { Serviciu serviciu = null; const string getAllQuery = "select * from hotelDB.dbo.ServiciiSuplimentare where id = @id;"; var conn = DBConnection.openConn(); using (var cmd = new SqlCommand(getAllQuery, conn)) { cmd.Parameters.AddWithValue("@id", id); var reader = await cmd.ExecuteReaderAsync(); if (await reader.ReadAsync()) { serviciu = new Serviciu(); serviciu.id = reader.GetInt32(0); serviciu.numeServiciu = reader.GetString(1); serviciu.pret = reader.GetInt32(2); } cmd.Dispose(); reader.Close(); } return(serviciu); }
public List <Programare> listaProgramari(String data) { DateTime dataP = DateTime.ParseExact(data, "yyyy-MM-dd", null); List <Programare> programari = _programareDAO.getProgramari(dataP); if (programari != null) { foreach (Programare programare in programari) { List <ProgramareServiciu> programareServiciuList = _programareServiciuDAO.selectServiciiClient(programare.getId()); List <Serviciu> servicii = new List <Serviciu>(); foreach (ProgramareServiciu programareServiciu in programareServiciuList) { Serviciu serv = _serviciuDAO.getServiciu(programareServiciu.getNumeServiciu()); servicii.Add(serv); } programare.setServicii(servicii); } } else { return(null); } return(programari); }
public List <Serviciu> getServicii() { List <Serviciu> listaServicii = new List <Serviciu>(); Serviciu u = null; String sql = "SELECT * FROM service"; try { _conn.Open(); SqlCommand cmd = new SqlCommand(sql, _conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { u = new Serviciu(Int32.Parse(reader["id"].ToString()), reader["name"].ToString(), Int32.Parse(reader["price"].ToString())); listaServicii.Add(u); } _conn.Close(); } catch (Exception e) { Console.WriteLine(e.Message); return(null); } return(listaServicii); }
public String addProgramare(String date, String name, String telefon, String services, String ora) { Type obj = Type.GetType(ConfigurationManager.AppSettings["DefaultRepositoryServicii"]); ConstructorInfo constructor = obj.GetConstructor(new Type[] { }); IServiciiDAO serviciiRepository = (IServiciiDAO)constructor.Invoke(null); String[] s = services.Split(','); int cost = 0; foreach (String w in s) { if (verifIfTaken(w, date, ora)) { return("ERROR! Service: " + w + " is taken. Choose another!"); } Serviciu u = serviciiRepository.getService(w); if (u == null) { return(null); } else { cost += u.getPrice(); } } String result = _repository.addProgramare(date, ora, name, telefon, services, cost); return(result); }
public async Task <IActionResult> Edit(int id, [Bind("ServiciuId,numeServiciu,pret")] Serviciu serviciu) { if (id != serviciu.ServiciuId) { return(NotFound()); } if (ModelState.IsValid) { try { _serviciuService.UpdateServiciu(serviciu); } catch (DbUpdateConcurrencyException) { if (!ServiciuExists(serviciu.ServiciuId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(serviciu)); }
private Serviciu _construireServiciu(Serviciu serviciu) { serviciu.denumire = tbDenumire.Text; serviciu.descriere = tbDescriere.Text; serviciu.durata_medie = int.Parse(tbDurataMedie.Text.ToString()); return(serviciu); }
private void btnModifica_Click(object sender, RoutedEventArgs e) { serviciuSelectat = lvServicii.SelectedItem as Serviciu; if (serviciuSelectat != null) { this.NavigationService.Navigate(new FormularServiciu(serviciuSelectat)); } }
public async Task <IActionResult> Create([Bind("ServiciuId,numeServiciu,pret")] Serviciu serviciu) { if (ModelState.IsValid) { _serviciuService.AdaugareServiciu(serviciu); return(RedirectToAction(nameof(Index))); } return(View(serviciu)); }
public bool Equal(Serviciu p) { if (p == null) { return(false); } return(this.Id == p.Id && this.Nume == p.Nume && this.CodIntern == p.CodIntern); }
public void AdaugareServicii(Serviciu serv) { bool exist = elemente.Any(item => item.Nume == serv.Nume && item.CodIntern == serv.CodIntern && item.Pret == serv.Pret && item.Categorie == serv.Categorie); if (exist) { Console.WriteLine("Serviciul exista deja!"); } else { elemente.Add(serv); Console.WriteLine("Serviciu adaugat!"); } }
// GET: Serviciu/Edit/5 public async Task <IActionResult> Edit(int?id) { if (id == null) { return(NotFound()); } Serviciu serviciu = _serviciuService.GetServiciu(id.GetValueOrDefault()); if (serviciu == null) { return(NotFound()); } return(View(serviciu)); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Serviciu = await _context.Serviciu.FirstOrDefaultAsync(m => m.ID == id); if (Serviciu == null) { return(NotFound()); } return(Page()); }
public FormularServiciu(Serviciu serviciuSelectat = null) { InitializeComponent(); if (serviciuSelectat != null) { this.serviciuSelectat = serviciuSelectat; _afisareServiciu(serviciuSelectat); btnAdaugareServiciu.Visibility = Visibility.Collapsed; } else { btnModificareServiciu.Visibility = Visibility.Collapsed; } }
public bool adaugareServiciu(String nume, String pret) { float pretFloat = 0.0f; try { pretFloat = float.Parse(pret, CultureInfo.InvariantCulture.NumberFormat); }catch (FormatException e) { return(false); } //float pretFloatR= (float)Math.Round(pretFloat * 100f) / 100f; // rotunjire cu 2 zecimale Serviciu serviciu = new Serviciu(nume, pretFloat); return(_serviciuDAO.addServiciu(serviciu)); }
bool CompareServ(Serviciu obj) { bool ok = true; for (int i = 0; i < elemente.Count; i++) { if (elemente[i] is Serviciu) { if (obj.Equal((Serviciu)elemente[i])) { return(false); } } } return(ok); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Serviciu = await _context.Serviciu.FindAsync(id); if (Serviciu != null) { _context.Serviciu.Remove(Serviciu); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
private void btnAdaugareServiciu_Click(object sender, RoutedEventArgs e) { try { Serviciu serviciu = new Serviciu(); serviciu = _construireServiciu(serviciu); db.Serviciu.Add(serviciu); db.SaveChanges(); this.NavigationService.Navigate(new ListaServicii()); } catch { MessageBox.Show("Serviciul nu a putut fi adăugat în baza de date."); } }
private void btnModificareServiciu_Click(object sender, RoutedEventArgs e) { try { Serviciu serviciu = db.Serviciu.Where(x => x.id_serviciu == serviciuSelectat.id_serviciu).FirstOrDefault(); serviciu = _construireServiciu(serviciu); db.Serviciu.AddOrUpdate(serviciu); db.SaveChanges(); this.NavigationService.Navigate(new ListaServicii()); } catch { MessageBox.Show("Serviciul nu a putut fi modificat din baza de date."); } }
public void WriteServicii() { Console.Write("Nr. servicii:"); int nrServicii = int.Parse(Console.ReadLine()); // citim serviciile for (int cnt = 0; cnt < nrServicii; cnt++) { Console.WriteLine("Introdu un serviciu: \n"); Console.Write("Numele:"); String nume = Console.ReadLine(); Console.Write("Codul intern:"); String codIntern = Console.ReadLine(); Serviciu serv = new Serviciu(cnt, nume, codIntern); bool exists = false; int counter = 0; if (servicii[0] == null) { servicii[0] = serv; } else { while (servicii[counter] != null) { if (servicii[counter].Nume.Equals(serv.Nume)) { Console.WriteLine("Serviciul {0} exista deja", serv.Nume); exists = true; cnt--; nrServicii--; break; } counter++; } if (exists == false) { servicii[cnt] = serv; } } } }
public void InitListafromXML() { XmlDocument doc = new XmlDocument(); doc.Load("D:\\Anul II\\OOP\\labs\\lab-6\\POS\\app1\\Servicii.xml"); XmlNodeList lista_noduri = doc.SelectNodes("/servicii/Serviciu"); foreach (XmlNode nod in lista_noduri) { string nume = nod["Nume"].InnerText; string codIntern = nod["CodIntern"].InnerText; int pret = int.Parse(nod["Pret"].InnerText); string categorie = nod["Categorie"].InnerText; Serviciu serv = new Serviciu(elemente.Count + 1, nume, codIntern, pret, categorie); AdaugareServicii(serv); } }
public void Init(Pachet pachet) { XmlDocument doc = new XmlDocument(); doc.Load("D:\\Anul II\\OOP\\labs\\lab-6\\POS\\app1\\Servicii.xml"); XmlNodeList lista_noduri = doc.SelectNodes("/servicii/Serviciu"); foreach (XmlNode nod in lista_noduri) { string nume = nod["Nume"].InnerText; string codIntern = nod["CodIntern"].InnerText; int pret = int.Parse(nod["Pret"].InnerText); string categorie = nod["Categorie"].InnerText; Serviciu serv = new Serviciu(elemente.Count + 1, nume, codIntern, pret, categorie);// think about another id not related to elemente.Count same in PacheteMgr pachet.Add_element(serv); } }