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