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