public ActionResult Index(Acceso login)
{
RespAcceso respuesta = new RespAcceso();
try {
SqlDataReader reader = null;
SqlConnection myConnection = new SqlConnection();
try
{
myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString;
myConnection.Open();
SqlCommand command = new SqlCommand("select * from RESTAURANT a, EMPLEADO b where b.EMPL_COD = " + login.num_empleado + " and a.REST_ID = " + login.rest_id + " and b.EMPL_STAT ='ALTA'", myConnection);
reader = command.ExecuteReader();
Empleado emp = new Empleado();
Restaurant rest = new Restaurant();
while (reader.Read())
{
rest.rest_des = reader["rest_des"].ToString();
rest.rest_id = Convert.ToInt32(reader["rest_id"].ToString());
rest.succ_id = Convert.ToInt32(reader["succ_id"].ToString());
emp.empl_apm = reader["empl_apm"].ToString();
emp.empl_app = reader["empl_app"].ToString();
emp.empl_cod = Convert.ToInt32(reader["empl_cod"].ToString());
emp.empl_nom = reader["empl_nom"].ToString();
emp.empl_stat = reader["empl_stat"].ToString();
emp.empl_tipo = reader["empl_tipo"].ToString();
emp.succ_id = Convert.ToInt32(reader["succ_id"].ToString());
}//end while
respuesta.restaurant = rest;
respuesta.empleado = emp;
}
catch (SqlException sqlExc)
{
respuesta.success = false;
respuesta.message = "ERROR " + sqlExc.Message;
}
finally
{
myConnection.Close();
}
//fin try-catch SQL
}catch(Exception ex){
respuesta.success = false;
respuesta.message = "ERROR " + ex.Message;
}//Fin Try-catch General
respuesta.success = true;
respuesta.message = "OK";
return Json(respuesta);
}
public ActionResult appEntrar(Acceso login)
{
log.Info("Solicitando appEntrar");
RespAcceso respuesta = new RespAcceso();
try
{
SqlDataReader reader = null;
SqlConnection myConnection = new SqlConnection();
Empleado emp = null;
RestDetalle rest = null;
log.Debug("Restaurante " +login.rest_id);
log.Debug(" |Validando contraseña " + login.password); // " contra contraseña de restaurant " + ConfigurationManager.AppSettings[login.rest_id].ToString());
log.Debug("1= " + ConfigurationManager.AppSettings["1"].ToString());
log.Debug("?= " + ConfigurationManager.AppSettings[""+login.rest_id].ToString());
string pass = null;
try
{
pass = ConfigurationManager.AppSettings["" + login.rest_id].ToString();
}catch(Exception exrr){
log.Error("ERROR VALIDANDO CONTRASEÑA EN "+ exrr.Message);
}
if(pass== null){
log.Debug("Configuracion de contraseña, incorrecta");
respuesta.success = false;
respuesta.message = "CONFIGURACION DE CONTRASEÑA, INCORRECTA";
respuesta.restaurant = rest;
respuesta.empleado = emp;
}
else if ( pass == login.password)
{
log.Debug("Contraseña Valida");
try
{
myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString;
myConnection.Open();
//SqlCommand command = new SqlCommand("select * from RESTAURANT a, EMPLEADO b where b.EMPL_COD = " + login.num_empleado + " and a.REST_ID = " + login.rest_id + " and b.EMPL_STAT ='ALTA'", myConnection);
SqlCommand command = new SqlCommand("select (select SUCC_DES from SUCURSAL where SUCC_ID = a.SUCC_ID) as SUCC_DES, * from RESTAURANT a, ff_cat_usuario b where b.usr_numempleado = " + login.num_empleado + " and a.REST_ID = " + login.rest_id, myConnection);
reader = command.ExecuteReader();
while (reader.Read())
{
emp = new Empleado();
rest = new RestDetalle();
rest.rest_des = reader["rest_des"].ToString();
rest.rest_id = Convert.ToInt32(reader["rest_id"].ToString());
rest.succ_id = Convert.ToInt32(reader["succ_id"].ToString());
rest.succ_des = reader["succ_des"].ToString();
emp.empl_apm = "";
emp.empl_app = "";
emp.empl_cod = Convert.ToInt32(reader["usr_numempleado"].ToString());
emp.empl_nom = reader["usr_nombre"].ToString();
emp.empl_stat = "ALTA";
emp.empl_tipo = "MESERO";
emp.succ_id = Convert.ToInt32(reader["succ_id"].ToString());
}//end while
if (emp != null && rest != null)
{
respuesta.success = true;
respuesta.message = "OK";
respuesta.restaurant = rest;
respuesta.empleado = emp;
}
else
{
respuesta.success = false;
respuesta.message = "CONTRASEÑA INVÁLIDA";
respuesta.restaurant = rest;
respuesta.empleado = emp;
}
}
catch (SqlException sqlExc)
{
log.Error("Error en SQLException appEntrar en " + sqlExc.Message);
respuesta.success = false;
respuesta.message = "ERROR " + sqlExc.Message;
return Json(respuesta);
}
finally
{
myConnection.Close();
}
}
else
{
log.Debug("Contraseña incorrecta");
respuesta.success = false;
respuesta.message = "CONTRASEÑA INVÁLIDA";
respuesta.restaurant = rest;
respuesta.empleado = emp;
}
//fin try-catch SQL
}
catch (Exception ex)
{
log.Error("Error solicitando appEntrar en "+ ex.Message);
respuesta.success = false;
respuesta.message = "ERROR " + ex.Message;
return Json(respuesta);
}//Fin Try-catch General
return Json(respuesta);
}
public ActionResult getOrdenesActivas(Acceso acceso)
{
log.Info("Solicitando getOrdenesActivas");
RespOrdenesActivas ordenesActivas = new RespOrdenesActivas();
try
{
SqlDataReader reader = null;
SqlConnection myConnection = new SqlConnection();
List<OrdenActiva> listaOrdenes = new List<OrdenActiva>();
try
{
myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString;
myConnection.Open();
//SqlCommand command = new SqlCommand("select a.ORDN_ID,a.ORDN_NPER, a.ORDN_IMPTOT, a.ORDN_STAT, a.MESA_ID, (select d.ordn_hmov from ORDEN_CTRL d where d.ORDN_ID = a.ORDN_ID) as ORDN_HMOV, (select c.MESA_cve from MESA c where c.MESA_ID = a.MESA_ID) as MESA_CVE from orden a where a.ORDN_MESE= "+acceso.num_empleado+" and a.ORDN_STAT= 'INIC' or a.ORDN_STAT = 'CAMM'", myConnection);
SqlCommand command = new SqlCommand("select a.ORDN_ID,a.ORDN_NPER, a.ORDN_IMPTOT, a.ORDN_STAT, a.MESA_ID, (select d.ordn_hmov from ORDEN_CTRL d where d.ORDN_ID = a.ORDN_ID) as ORDN_HMOV, (select c.MESA_cve from MESA c where c.MESA_ID = a.MESA_ID) as MESA_CVE from orden a where a.ORDN_MESE= " + acceso.num_empleado + " and (select c.rest_id from MESA c where c.MESA_ID =a.MESA_ID) = "+acceso.rest_id + " and a.ORDN_STAT= 'INIC' or a.ORDN_STAT = 'CAMM'", myConnection);
reader = command.ExecuteReader();
while (reader.Read())
{
OrdenActiva orden = new OrdenActiva();
orden.mesa_cve = reader["mesa_cve"].ToString();
orden.mesa_id = Convert.ToInt32(reader["mesa_id"].ToString());
orden.ordn_hmov = Convert.ToInt32(reader["ordn_hmov"].ToString());
orden.ordn_id = Convert.ToInt32(reader["ordn_id"].ToString());
orden.ordn_imptot = Convert.ToDecimal(reader["ordn_imptot"].ToString());
orden.ordn_nper = Convert.ToInt32(reader["ordn_nper"].ToString());
orden.ordn_stat = reader["ordn_stat"].ToString();
listaOrdenes.Add(orden);
}
ordenesActivas.total_ordenes = listaOrdenes.Count;
ordenesActivas.ordenesActivas = listaOrdenes;
}
catch (SqlException sqlex)
{
log.Error("Error en SQLException getOrdenesActivas en " + sqlex.Message);
ordenesActivas.success = false;
ordenesActivas.message = "ERROR " + sqlex;
return Json(ordenesActivas);
}
finally
{
myConnection.Close();
}
}
catch (Exception exc)
{
log.Error("Error getOrdenesActivas en " + exc.Message);
ordenesActivas.success = false;
ordenesActivas.message = "ERROR " + exc.Message;
return Json(ordenesActivas);
}
ordenesActivas.success = true;
ordenesActivas.message = "OK";
return Json(ordenesActivas);
}
public ActionResult Index(Acceso acceso)
{
RespOrdenesActivas ordenesActivas = new RespOrdenesActivas();
try
{
SqlDataReader reader = null;
SqlConnection myConnection = new SqlConnection();
List<OrdenActiva> listaOrdenes = new List<OrdenActiva>();
try
{
myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["BaseComercial"].ConnectionString;
myConnection.Open();
SqlCommand command = new SqlCommand("SELECT " +
"A.ORDN_ID, " +
"A.ORDN_NPER, " +
"A.ORDN_IMPTOT," +
"A.ORDN_STAT, " +
"A.MESA_ID, " +
"B.ORDN_HMOV, " +
"C.MESA_CVE "+
" FROM "+
"ORDEN A, "+
"ORDEN_CTRL B, "+
"MESA C "+
" WHERE " +
"A.ORDN_STAT = 'INIC' "+
" AND A.ORDN_MESE = " +acceso.num_empleado +
" AND B.ORDN_ID = A.ORDN_ID"+
" AND C.MESA_ID = A.MESA_ID;", myConnection);
reader = command.ExecuteReader();
while(reader.Read()){
OrdenActiva orden = new OrdenActiva();
orden.mesa_cve = reader["mesa_cve"].ToString();
orden.mesa_id = Convert.ToInt32(reader["mesa_id"].ToString());
orden.ordn_hmov = Convert.ToInt32(reader["ordn_hmov"].ToString());
orden.ordn_id = Convert.ToInt32(reader["ordn_id"].ToString());
orden.ordn_imptot = Convert.ToDecimal(reader["ordn_imptot"].ToString());
orden.ordn_nper = Convert.ToInt32(reader["ordn_nper"].ToString());
orden.ordn_stat = reader["ordn_stat"].ToString();
listaOrdenes.Add(orden);
}
ordenesActivas.total_ordenes = listaOrdenes.Count;
ordenesActivas.ordenesActivas = listaOrdenes;
}
catch(SqlException sqlex){
ordenesActivas.success = false;
ordenesActivas.message = "ERROR " + sqlex;
return Json(ordenesActivas);
}
finally{
myConnection.Close();
}
}
catch(Exception exc)
{
ordenesActivas.success = false;
ordenesActivas.message = "ERROR " + exc.Message;
return Json(ordenesActivas);
}
ordenesActivas.success = true;
ordenesActivas.message = "OK";
return Json(ordenesActivas);
}