public void UpdateCantidadMolduraSuma(DtoMolde objDtoMolde)
{
SqlCommand command = new SqlCommand("update T_MOLDE set IML_Cantidad=((select IML_Cantidad from T_MOLDE where FK_IM_Cod=" + objDtoMolde.FK_IM_Cod + ")+" + objDtoMolde.IML_Cantidad + ") where FK_IM_Cod=" + objDtoMolde.FK_IM_Cod, conexion);
conexion.Open();
command.ExecuteNonQuery();
conexion.Close();
}
public void InsertarMolde(DtoMolde objDtoMolde)
{
SqlCommand command = new SqlCommand("Insert into T_MOLDE values (1," + objDtoMolde.IML_Cantidad + "," + objDtoMolde.FK_IM_Cod + ")", conexion);
conexion.Open();
command.ExecuteNonQuery();
conexion.Close();
}
public int SelectCantidadMoldexMoldura(DtoMolde objDtoMolde)
{
int cantidad;
string select = "select IsNULL((SELECT IML_Cantidad FROM T_MOLDE where FK_IM_Cod =" + objDtoMolde.FK_IM_Cod + "),0)";
SqlCommand command = new SqlCommand(select, conexion);
conexion.Open();
cantidad = (int)command.ExecuteScalar();
conexion.Close();
return(cantidad);
}
public DataTable SelectMoldesxCodigoMoldura(DtoMolde objDtoMolde)
{
DataTable dtmoldes = null;
conexion.Open();
SqlCommand command = new SqlCommand("select PK_IML_Cod,CASE WHEN VML_Disponibilidad=1 THEN 'Disponible' WHEN VML_Disponibilidad=0 THEN 'No disponible' END AS VML_Disponibilidad,IML_Cantidad,FK_IM_Cod from T_MOLDE where FK_IM_Cod=" + objDtoMolde.FK_IM_Cod, conexion);
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
dtmoldes = new DataTable();
daAdaptador.Fill(dtmoldes);
conexion.Close();
return(dtmoldes);
}
public bool SelectMoldexMoldura(DtoMolde objDtoMolde)
{
string select = "SELECT * FROM T_MOLDE WHERE FK_IM_Cod = '" + objDtoMolde.FK_IM_Cod + "'";
SqlCommand command = new SqlCommand(select, conexion);
conexion.Open();
SqlDataReader reader = command.ExecuteReader();
bool hayRegistros = reader.Read();
if (hayRegistros)
{
objDtoMolde.PK_IM_Cod = (int)reader[0];
objDtoMolde.IML_Cantidad = (int)reader[2];
}
conexion.Close();
return(hayRegistros);
}
public void AumentarMoldes(DtoMolde objDtoMolde)
{
objDaoMolde.UpdateCantidadMolduraSuma(objDtoMolde);
}
public void Restarmoldes(DtoMolde objDtoMolde)
{
objDaoMolde.UpdateCantidadMolduraResta(objDtoMolde);
}
public int CantidadMoldesxMoldura(DtoMolde objDtoMolde)
{
return(objDaoMolde.SelectCantidadMoldexMoldura(objDtoMolde));
}
public DataTable ListarMoldesxCodigoMoldura(DtoMolde objDtoMolde)
{
return(objDaoMolde.SelectMoldesxCodigoMoldura(objDtoMolde));
}
public bool ExistenciaMolde(DtoMolde objDtoMolde)
{
return(objDaoMolde.SelectMoldexMoldura(objDtoMolde));
}
public void RegistrarMolde(DtoMolde objDtoMolde)
{
objDaoMolde.InsertarMolde(objDtoMolde);
}
