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