public List <Servicii> GetAll()
{
var listaServicii = new List <Servicii>();
using (SqlConnection connection = new SqlConnection(AppSettings.connectionString))
{
var queryString = "Select * from servicii";
using (SqlCommand command = new SqlCommand(queryString, connection))
{
connection.Open();
using (SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
var newServiciu = new Servicii
{
Id = Int32.Parse(dr["Id"].ToString()),
Nume = dr["Nume"].ToString(),
pret = Int32.Parse(dr["pret"].ToString())
};
listaServicii.Add(newServiciu);
}
}
}
connection.Close();
return(listaServicii);
}
}
public Servicii GetServiciu(int Id)
{
var newServiciu = new Servicii();
using (SqlConnection connection = new SqlConnection(AppSettings.connectionString))
{
var queryString = "Select * from servicii where Id=@Id";
using (SqlCommand command = new SqlCommand(queryString, connection))
{
command.Parameters.AddWithValue("@Id", Id);
connection.Open();
using (SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
newServiciu.Id = Int32.Parse(dr["Id"].ToString());
newServiciu.Nume = dr["Nume"].ToString();
newServiciu.pret = Int32.Parse(dr["pret"].ToString());
}
}
}
connection.Close();
return(newServiciu);
}
}
public List <Servicii> TakeServicesBySpecializareId(int Id)
{
var listaServicii = new List <Servicii>();
using (SqlConnection connection = new SqlConnection(AppSettings.connectionString))
{
var queryString = "Select Nume,pret from servicii as s join specializari_servicii as ss on s.Id=ss.Id_serviciu where ss.Id_specializare=@Id ";
using (SqlCommand command = new SqlCommand(queryString, connection))
{
command.Parameters.AddWithValue("@Id", Id);
connection.Open();
using (SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
var newServiciu = new Servicii
{
pret = Int32.Parse(dr["pret"].ToString()),
Nume = dr["Nume"].ToString(),
};
listaServicii.Add(newServiciu);
}
}
}
connection.Close();
return(listaServicii);
}
}
public void Insert(Servicii serviciu)
{
using (SqlConnection connection = new SqlConnection(AppSettings.connectionString))
{
var queryString = "Insert into servicii values(@Nume,@pret)";
using (SqlCommand command = new SqlCommand(queryString, connection))
{
command.Parameters.AddWithValue("@Nume", serviciu.Nume);
command.Parameters.AddWithValue("@pret", serviciu.pret);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public void Update(Servicii serviciu)
{
using (SqlConnection connection = new SqlConnection(AppSettings.connectionString))
{
var queryString = "Update servicii set Nume=@Nume, pret=@pret where Id=@Id";
using (SqlCommand command = new SqlCommand(queryString, connection))
{
command.Parameters.AddWithValue("@Nume", serviciu.Nume);
command.Parameters.AddWithValue("@Id", serviciu.Id);
command.Parameters.AddWithValue("@pret", serviciu.pret);
connection.Open();
command.ExecuteNonQuery();
}
}
}
public ActionResult Create(Servicii serviciu)
{
HttpClient hc = new HttpClient();
hc.BaseAddress = new Uri("https://localhost:44322/api/ServiciiCRUD");
var insert_serviciu = hc.PostAsJsonAsync <Servicii>("ServiciiCRUD", serviciu);
insert_serviciu.Wait();
var save_data = insert_serviciu.Result;
if (save_data.IsSuccessStatusCode)
{
return(RedirectToAction("Servicii"));
}
return(View("Create"));
}
public IHttpActionResult InsertSer(Servicii serviciu)
{
var insert_results = hotel.spCRUDServicii(0, serviciu.Nume, serviciu.Pret, "Insert").ToList();
return(Ok(insert_results));
}
