public ActionResult Index() { 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';", myConnection); 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; }catch(SqlException exc){ mesas.success = false; mesas.message = "ERROR " + exc.Message; } }catch(Exception ex){ mesas.success = false; mesas.message = "ERROR " + ex.Message; } mesas.success = true; mesas.message = "OK"; return Json(mesas); }
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 updateMesa(Mesa mesa) { Respuesta resp = new Respuesta(); SqlConnection myConnection = new SqlConnection(); try { myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString; myConnection.Open(); SqlCommand command = new SqlCommand("UPDATE MESA SET MESA_CVE = @MESACVE, MESA_DES =@MESADES, MESA_STAT =@MESASTAT, REST_ID = @RESTID, UBIC_CONSEC= @UBIC WHERE MESA_ID = @MESAID", myConnection); command.Parameters.AddWithValue("@MESACVE", mesa.mesa_cve); command.Parameters.AddWithValue("@MESADES", mesa.mesa_des); command.Parameters.AddWithValue("@RESTID", mesa.rest_id); command.Parameters.AddWithValue("@UBIC", mesa.ubic_consec); command.Parameters.AddWithValue("@MESAID", mesa.mesa_id); command.Parameters.AddWithValue("@MESASTAT", mesa.mesa_stat); if (0 < command.ExecuteNonQuery()) { resp.success = true; resp.message = "OK"; } else { resp.success = false; resp.message = "NO SE CREO LA UBICACION"; return Json(resp); } } catch (Exception ex) { resp.success = false; resp.message = "ERROR " + ex.Message; return Json(resp); } finally { myConnection.Close(); } return Json(resp); }
public ActionResult getMesas(ReqMesa reqMesa) { RespMesas mesas = new RespMesas(); SqlDataReader reader = null; SqlConnection myConnection = new SqlConnection(); try { myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString; myConnection.Open(); SqlCommand command = new SqlCommand("SELECT * FROM MESA WHERE REST_ID =@REST AND UBIC_CONSEC = @CONSEC", myConnection); command.Parameters.AddWithValue("@REST", reqMesa.rest_id); command.Parameters.AddWithValue("@CONSEC", reqMesa.ubic_consec); reader = command.ExecuteReader(); List<Mesa> listaMesas = new List<Mesa>(); 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; mesas.success = true; mesas.message = "OK "; } catch (Exception ex) { mesas.success = false; mesas.message = "ERROR " + ex.Message; return Json(mesas); } finally { myConnection.Close(); } return Json(mesas); }