public List <Posicion> Get()
{
// var conectionString = Coneccion.Cadena.conexion;
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <Posicion>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("select idPosicion,Posicion from tbPosicion where irregular=1 order by Posicion", cn);
sqlcommand.CommandType = CommandType.Text;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new Posicion
{
idPosicion = Convert.ToInt32(dr["idPosicion"].ToString()),
nombre = dr["Posicion"].ToString(),
};
list.Add(obj);
}
return(list);
}
}
public string Post([FromBody] Irregular data)
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var command = new SqlCommand("spdSaveIrregularesCorteClienteCrudo", cn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@corte", SqlDbType.NChar, 25).Value = data.corte;
command.Parameters.Add("@idDefecto", SqlDbType.Int).Value = data.idDefecto;
command.Parameters.Add("@idPosicion", SqlDbType.Int).Value = data.idPosicion;
command.Parameters.Add("@talla", SqlDbType.NChar, 15).Value = data.talla;
command.Parameters.Add("@color", SqlDbType.NChar, 15).Value = data.color;
command.Parameters.Add("@area", SqlDbType.NVarChar, 2).Value = data.area;
command.Parameters.Add("@usuario", SqlDbType.NChar, 35).Value = data.usuarioRegistro;
command.Parameters.Add("@total", SqlDbType.Int).Direction = ParameterDirection.Output;
command.ExecuteNonQuery();
var total = int.Parse(command.Parameters["@total"].Value.ToString());
return("Ok");
}
}
/// <summary>
/// envio de unidades a heatTR
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
// POST: api/HeatTransfers
public string Post([FromBody] ProcesoHeatTransfer data)
{
try
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var command = new SqlCommand("spdIntexIngresoHeat", cn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@corteParam", SqlDbType.NVarChar).Value = data.corte;
command.Parameters.Add("@unidadesParam", SqlDbType.Int).Value = data.uniTransferencia;
command.ExecuteNonQuery();
return("Ok");
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
return(ex.Message);
}
}
/// <summary>
/// r3gistro de unidades dañadas en heat transfer
/// </summary>
/// <param name="data"></param>
/// <param name="id"></param>
/// <returns></returns>
// POST: api/HeatTransfers
public string Post([FromBody] ProcesoHeatTransfer data, int id)
{
try
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var command = new SqlCommand("spdIntexIngresoUnidaesDefecHeat", cn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@corteParam", SqlDbType.NVarChar).Value = data.corte;
command.Parameters.Add("@unidadesParam", SqlDbType.Int).Value = data.uniTransferencia;
command.Parameters.Add("@unidadesActualizadas", SqlDbType.Int).Direction = ParameterDirection.Output;
command.ExecuteNonQuery();
var unidades = Convert.ToInt32(command.Parameters["@unidadesActualizadas"].Value.ToString());
if (unidades < data.uniTransferencia)
{
return(unidades.ToString());
}
return("Ok");
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
return("error");//ex.Message;
}
}
//inventario en heat Transfer
// GET: api/HeatTransfers/5
public List <Disponible> Get(int id)
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <Disponible>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("spdIntexGetDisponibleEnHeat", cn);
sqlcommand.CommandType = CommandType.StoredProcedure;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new Disponible
{
corte = dr["corte"].ToString(),
estilo = dr["estilo"].ToString(),
color = dr["color"].ToString(),
disponible = Convert.ToInt32(dr["Unidades"].ToString()),
uniTransferencia = 0
};
list.Add(obj);
}
return(list);
}
}
public List <Porder> Get(string corte, int i = 1)
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <Porder>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("spdGetTallasUniXCorteCliente", cn);
sqlcommand.CommandType = CommandType.StoredProcedure;
sqlcommand.Parameters.Add("@corte", SqlDbType.NChar, 25).Value = corte;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new Porder
{
idCorte = Convert.ToInt32(dr["unidades"].ToString()),
corte = dr["Size"].ToString(),
};
list.Add(obj);
}
return(list);
}
}
public string Post([FromBody] Disponible data, int id)
{
try
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var command = new SqlCommand("spdIntexIgresoInventarioDevolucion", cn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@corteParam", SqlDbType.NChar, 15).Value = data.corte;
command.Parameters.Add("@estiloParam", SqlDbType.NChar, 15).Value = data.estilo;
command.Parameters.Add("@colorParam", SqlDbType.NChar, 15).Value = data.color;
command.Parameters.Add("@unidadesParam", SqlDbType.Int).Value = data.uniTransferencia;
command.ExecuteNonQuery();
return("Ok");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(ex.Message);
}
}
public List <Linea> Get()
{
// var conectionString = Coneccion.Cadena.conexion;
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <Linea>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("select id_linea as id,numero as linea from Linea where numero not like '%-%' order by convert(float, numero) asc", cn);
sqlcommand.CommandType = CommandType.Text;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new Linea
{
id = Convert.ToInt32(dr["id"].ToString()),
linea = dr["linea"].ToString()
};
list.Add(obj);
}
return(list);
}
}
// POST: api/ReprocesoLavados
public string Post([FromBody] ReprocesoLavado data)
{
try
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var command = new SqlCommand("spdIntexIngresoReprocesoLavado", cn);
command.CommandType = CommandType.StoredProcedure;
// command.Parameters.Add("@idInventarioMedidasParam", SqlDbType.Int).Value = data.id;
command.Parameters.Add("@unidadesParam", SqlDbType.Int).Value = data.unidades;
command.Parameters.Add("@xmlstringParam", SqlDbType.NVarChar).Value = data.xml;
command.ExecuteNonQuery();
return("Ok");
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
return(ex.Message);
}
}
public List <Reproceso> Get(int idorden, string type)
{
//var conectionString = Coneccion.Cadena.conexion;
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <Reproceso>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("spdGetReparaciones", cn);
sqlcommand.CommandType = CommandType.StoredProcedure;
sqlcommand.Parameters.Add("@idOrder", SqlDbType.Int).Value = idorden;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new Reproceso
{
objectId = Convert.ToInt32(dr["id"].ToString()),
idOrder = Convert.ToInt32(dr["idC"].ToString()),
talla = dr["talla"].ToString(),
totalPorTalla = Convert.ToInt32(dr["cantidadDevolucion"].ToString()), // Convert.ToInt32(dr["totalPorTalla"].ToString()),
cantidadDevolucion = Convert.ToInt32("0") // Convert.ToInt32("cantidadDevolucion")
};
list.Add(obj);
}
return(list);
}
}
public string Post([FromBody] Reparacion data)
{
//var config = Coneccion.Cadena.conexion;
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var command = new SqlCommand("spdGuardarReparaciones", cn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@idOrder", SqlDbType.Int).Value = data.idOrder;
command.Parameters.Add("@talla", SqlDbType.NChar, 10).Value = data.talla;
command.Parameters.Add("@idlinea", SqlDbType.Int).Value = data.idLinea;
command.Parameters.Add("@totalXtalla", SqlDbType.Int).Value = data.totalPorTalla;
command.Parameters.Add("@cantdev", SqlDbType.Int).Value = data.cantidadDevolucion;
command.Parameters.Add("@observacion", SqlDbType.NVarChar, 1000).Value = data.observacion;
command.Parameters.Add("@usuario", SqlDbType.NChar, 20).Value = data.usuario;
command.ExecuteNonQuery();
return("Ok");
}
}
public List <Reparacion> Get(int idorden)
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring(); // Coneccion.Cadena.conexion;
var list = new List <Reparacion>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("spdTotalesNoLavadoRepa", cn);
sqlcommand.CommandType = CommandType.StoredProcedure;
sqlcommand.Parameters.Add("@idorder", SqlDbType.Int).Value = idorden;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new Reparacion
{
idOrder = Convert.ToInt32(dr["Id_Order"].ToString()),
talla = dr["Size"].ToString(),
totalPorTalla = Convert.ToInt32(dr["Enviado"].ToString()),
cantidadDevolucion = Convert.ToInt32("0")
};
list.Add(obj);
}
return(list);
}
}
//detalle de tolereancias con medidas fuera de tolerancia menor
// GET: api/ReprocesosPlancha/5
public List <disponiblePlancha> Get(string corte)
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <disponiblePlancha>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("spdIntexGetDetalleDisponiblePlancha", cn);
sqlcommand.CommandType = CommandType.StoredProcedure;
sqlcommand.Parameters.Add("@corteParam", SqlDbType.NChar, 25).Value = corte;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new disponiblePlancha
{
// objectId = Convert.ToInt32(dr["id"].ToString()),
corte = dr["POrderClient"].ToString(),
estilo = dr["estilo"].ToString(),
tolerancia = dr["tolerancia"].ToString(),
Waist = Convert.ToInt32(dr["Waist"].ToString()),
Inseam = Convert.ToInt32(dr["Inseam"].ToString()),
WI = Convert.ToInt32(dr["WI"].ToString()),
// color = dr["color"].ToString(),
//unidadesCorte = Convert.ToInt32(dr["unidades"].ToString()),
disponible = Convert.ToInt32(dr["Total"].ToString()),
// uniTranferencia = 0
};
list.Add(obj);
}
return(list);
}
}
public IHttpActionResult Authenticate([FromBody] Usuario login)
{
if (login == null)
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
//TODO: Validate credentials Correctly, this code is only for demo !!
bool isCredentialValid = false;// (login.Password == "123456");
var conectionString = CreadorConection.Creador(CreadorConection.Packing).conectionstring();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("select isnull(idUser,0) as id from tbUser where nombre='" + login.Username + "' and CodigoAcceso='" + login.Password + "'", cn);
sqlcommand.CommandType = CommandType.Text;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var id = Convert.ToInt32(dr["id"].ToString());
isCredentialValid = id > 0 ? true : false;
}
if (isCredentialValid)
{
var token = TokenGenerator.GenerateTokenJwt(login.Username);
return(Ok(token));
}
else
{
return(Unauthorized());
}
}
}
// disponible para enviar a reproceso de plancha
// GET: api/ReprocesosPlancha
public List <disponiblePlancha> Get()
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <disponiblePlancha>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
string query = "select * from vwIntexGetDisponibleEnvioPlancha";
var sqlcommand = new SqlCommand(query, cn);
sqlcommand.CommandType = CommandType.Text;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new disponiblePlancha
{
// objectId = Convert.ToInt32(dr["id"].ToString()),
corte = dr["PorderClient"].ToString(),
estilo = dr["estilo"].ToString(),
Waist = Convert.ToInt32(dr["Waist"].ToString()),
Inseam = Convert.ToInt32(dr["Inseam"].ToString()),
WI = Convert.ToInt32(dr["WI"].ToString()),
// color = dr["color"].ToString(),
//unidadesCorte = Convert.ToInt32(dr["unidades"].ToString()),
disponible = Convert.ToInt32(dr["Total"].ToString()),
uniTransferencia = 0
};
list.Add(obj);
}
return(list);
}
}
public string Post([FromBody] Reparacion data, int id)
{
//var config = Coneccion.Cadena.conexion;
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var command = new SqlCommand("spdGuardarDetReparaciones", cn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@idObjectRepa", SqlDbType.Int).Value = id;// data.objectIdReparaciones;
command.Parameters.Add("@cantidadRet ", SqlDbType.Int).Value = data.cantidadDevolucion;
command.Parameters.Add("@observacion ", SqlDbType.NVarChar).Value = data.observacion;
command.Parameters.Add("@usuario ", SqlDbType.NChar, 20).Value = data.usuario;
command.ExecuteNonQuery();
return("Ok");
}
}
// GET: api/IrregularesCrudo/5
public List <Irregular> Get(string corte)
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <Irregular>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("spdGetListaIrregularesXCorteClienteCrudo", cn);
sqlcommand.CommandType = CommandType.StoredProcedure;
sqlcommand.Parameters.Add("@corte", SqlDbType.NChar, 25).Value = corte;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new Irregular
{
// idOrder = Convert.ToInt32(dr["idOrder"].ToString()),
corte = dr["orden"].ToString(),
talla = dr["talla"].ToString(),
idDefecto = Convert.ToInt32(dr["idDefecto"].ToString()),
idPosicion = Convert.ToInt32(dr["idPosicion"].ToString()),
unidades = Convert.ToInt32(dr["total"].ToString()),
defecto = dr["Defecto"].ToString(),
posicion = dr["Posicion"].ToString(),
area = dr["area"].ToString()
};
list.Add(obj);
}
return(list);
}
}
public List <Porder> Get(string pre)
{
// var conectionString = Coneccion.Cadena.conexion;
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <Porder>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("spdBuscarPoCliente", cn);
sqlcommand.CommandType = CommandType.StoredProcedure;
sqlcommand.Parameters.Add("@porder", SqlDbType.NChar, 15).Value = pre;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new Porder
{
//idCorte = Convert.ToInt32(dr["Id_Order"].ToString()),
corte = dr["Porder"].ToString(),
estilo = dr["Style"].ToString(),
cantidad = Convert.ToInt32(dr["Quantity"].ToString()),
washed = Convert.ToBoolean(dr["Washed"]),
descrip = dr["Describir"].ToString()
};
list.Add(obj);
}
return(list);
}
}
// GET: api/DisponibleEnMedidas/5
public List <Disponible> Get(string corte)
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <Disponible>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
// string query= $"select * from vwGetCortesMedidaG where POrderClient='{ corte }'";
var sqlcommand = new SqlCommand("spdIntexGetMedidaDisponible", cn);
sqlcommand.CommandType = CommandType.StoredProcedure;
sqlcommand.Parameters.Add("@corteParam", SqlDbType.NChar, 20).Value = corte;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new Disponible
{
corte = dr["POrderClient"].ToString(),
estilo = dr["Medida"].ToString(),
color = dr["tolerancia"].ToString(),
disponible = Convert.ToInt32(dr["unidades"].ToString()),
//disponible = Convert.ToInt32(dr["disponible"].ToString()),
uniTransferencia = 0
};
list.Add(obj);
}
return(list);
}
}
/// <summary>
/// unidades disponibles para dar de baja del area de reproceso de plancha
/// </summary>
/// <param name="corte"></param>
/// <param name="id"></param>
/// <returns></returns>
// GET: api/ReprocesosPlancha/5
public List <disponiblePlancha> Get(string corte, int id)
{
var conectionString = CreadorConection.Creador(CreadorConection.Auditoria).conectionstring();
var list = new List <disponiblePlancha>();
using (SqlConnection cn = new SqlConnection(conectionString))
{
cn.Open();
var sqlcommand = new SqlCommand("spdIntexGetEnPlanchaMedido", cn);
sqlcommand.CommandType = CommandType.StoredProcedure;
// sqlcommand.Parameters.Add("@corte", SqlDbType.Int).Value = corte;
var dr = sqlcommand.ExecuteReader();
while (dr.Read())
{
var obj = new disponiblePlancha
{
objectId = Convert.ToInt32(dr["id"].ToString()),
corte = dr["corte"].ToString(),
estilo = dr["estilo"].ToString(),
color = dr["color"].ToString(),
disponible = Convert.ToInt32(dr["Unidades"].ToString()),
uniTransferencia = 0
};
list.Add(obj);
}
return(list);
}
}
