public ActionResult getRestoOrdenes(ReqDeleteRestaurant rest) { log.Info("Solicitando getRestoOrdenes en restaurant "+rest.rest_id); RespOrdenDescripcionCorta resp = new RespOrdenDescripcionCorta(); SqlDataReader reader = null; SqlConnection myConnection = new SqlConnection(); try { myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString; myConnection.Open(); //SqlCommand command = new SqlCommand("select a.ordn_id, b.empl_nom,b.empl_app, c.mesa_cve, a.ordn_imptot, a.ordn_nper from orden a, empleado b, mesa c where a.mesa_id = c.mesa_id and a.ordn_mese = b.empl_cod and c.rest_id = @REST and a.ordn_stat <> 'FINC' ", myConnection); //command.Parameters.AddWithValue("@REST", rest.rest_id); SqlCommand command = new SqlCommand("select distinct count( ordn_mese) as countt, (select usr_nombre from ff_cat_usuario where usr_numempleado= a.ordn_mese) as nom,a.ordn_mese as codigo from orden a where a.ordn_stat <>'FINC' group by a.ordn_mese", myConnection); reader = command.ExecuteReader(); List<OrdenDescripcionCorta> ordenes = new List<OrdenDescripcionCorta>(); while (reader.Read()) { OrdenDescripcionCorta ord = new OrdenDescripcionCorta(); ord.empl_nom = reader["nom"].ToString(); ord.empl_cod = Convert.ToInt32(reader["codigo"].ToString()); ord.ordn_nctas = Convert.ToInt32(reader["countt"].ToString()); ordenes.Add(ord); }//fin while resp.ordenes_rest = ordenes; resp.message = "OK"; resp.success = true; if (ordenes.Count == 0) { resp.success = false; resp.message = "NO HAY MAS ORDENES EN ESTE RESTAURANTE"; return Json(resp); } } catch(Exception ex) { log.Error("Error en getRestoOrdenes en " + ex.Message); resp.success = false; resp.message = "ERROR "+ex.Message; return Json(resp); } finally { myConnection.Close(); } return Json(resp); }
public ActionResult getDetalleRest(ReqDeleteRestaurant idRest) { DetalleRest detalles = new DetalleRest(); SqlDataReader reader = null; SqlConnection myConnection = new SqlConnection(); try { myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString; myConnection.Open(); SqlCommand command = new SqlCommand("select REST_DES, (select succ_des from SUCURSAL where SUCC_ID = a.SUCC_ID) as succ_des from RESTAURANT a where a.REST_ID="+idRest.rest_id, myConnection); reader = command.ExecuteReader(); while (reader.Read()) { detalles.rest_des = reader["rest_des"].ToString(); detalles.succ_des = reader["succ_des"].ToString(); } } catch (Exception ex) { detalles.success = false; detalles.message = "ERROR " + ex.Message; return Json(detalles); } finally { myConnection.Close(); } detalles.success = true; detalles.message = "OK"; return Json(detalles); }
public ActionResult getMesas(ReqDeleteRestaurant rest) { log.Info("Solicitando getMesas"); RespMesas mesas = new RespMesas(); try { SqlDataReader reader = null; SqlConnection myConnection = new SqlConnection(); List<Mesa> listaMesas = new List<Mesa>(); try { myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString; myConnection.Open(); SqlCommand command = new SqlCommand("SELECT * FROM MESA WHERE MESA_STAT = 'ALTA' AND REST_ID =@REST", myConnection); command.Parameters.AddWithValue("@REST", rest.rest_id); reader = command.ExecuteReader(); while (reader.Read()) { Mesa mesa = new Mesa(); mesa.mesa_cve = reader["mesa_cve"].ToString(); mesa.mesa_des = reader["mesa_des"].ToString(); mesa.mesa_id = Convert.ToInt32(reader["mesa_id"].ToString()); mesa.mesa_stat = reader["mesa_stat"].ToString(); mesa.rest_id = Convert.ToInt32(reader["rest_id"].ToString()); mesa.ubic_consec = Convert.ToInt32(reader["ubic_consec"].ToString()); listaMesas.Add(mesa); } mesas.mesas = listaMesas; if (listaMesas.Count>0 ) { mesas.success = true; mesas.message = "OK"; } else { mesas.success = false; mesas.message = "No hay mesas disponibles"; } } catch (SqlException exc) { log.Error("Error SQLExc solicitando getMesas en " + exc.Message); mesas.success = false; mesas.message = "ERROR " + exc.Message; } } catch (Exception ex) { log.Error("Error solicitando getMesas en " + ex.Message); mesas.success = false; mesas.message = "ERROR " + ex.Message; } return Json(mesas); }
public ActionResult deleteRestaurante(ReqDeleteRestaurant req) { Respuesta resp = new Respuesta(); SqlConnection myConnection = new SqlConnection(); try { myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString; myConnection.Open(); SqlCommand command = new SqlCommand("DELETE FROM RESTAURANT WHERE REST_ID = @RESTID", myConnection); command.Parameters.AddWithValue("@RESTID", req.rest_id); command.ExecuteNonQuery(); } catch (Exception ex) { resp.success = false; resp.message = "ERROR " + ex.Message; return Json(resp); } finally { myConnection.Close(); } resp.success = true; resp.message = "OK"; return Json(resp); }