public DataTable CalcularSubtotal(DtoMoldura objmoldura, DtoTipoMoldura objtipo, double cant)
{
DataTable dt = null;
conexion.Open();
SqlCommand command = new SqlCommand("SP_CalcularSubtotal", conexion);
command.Parameters.AddWithValue("@codMol", objmoldura.PK_IM_Cod);
command.Parameters.AddWithValue("@cantidad", cant);
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
command.CommandType = CommandType.StoredProcedure;
dt = new DataTable();
daAdaptador.Fill(dt);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
objmoldura.PK_IM_Cod = int.Parse(reader["PK_IM_Cod"].ToString());
objmoldura.VBM_Imagen = Encoding.ASCII.GetBytes(reader["VBM_Imagen"].ToString());
objtipo.VTM_Nombre = reader["VTM_Nombre"].ToString();
objmoldura.DM_Largo = Double.Parse(reader["DM_Largo"].ToString());
objmoldura.DM_Ancho = Double.Parse(reader["DM_Ancho"].ToString());
objmoldura.IM_Stock = int.Parse(reader["IM_Stock"].ToString());
objmoldura.DM_Precio = Convert.ToDouble(reader["DM_Precio"].ToString());
//objmoldura.DM_subtotal = Double.Parse(reader["Subtotal"].ToString());
}
conexion.Close();
return(dt);
}
public void ObtenerMXU(DtoMoldura objmoldura, DtoMolduraXUsuario objmxu, DtoTipoMoldura tm)
{
SqlCommand command = new SqlCommand("SP_Detalle_MXU_C", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Id", objmxu.PK_IMU_Cod);
DataSet ds = new DataSet();
conexion.Open();
SqlDataAdapter moldura = new SqlDataAdapter(command);
moldura.Fill(ds);
moldura.Dispose();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
objmxu.PK_IMU_Cod = Convert.ToInt32(reader[0].ToString());
objmoldura.PK_IM_Cod = Convert.ToInt32(reader[1].ToString());
tm.PK_ITM_Tipo = Convert.ToInt32(reader[2].ToString());
objmoldura.VM_Descripcion = reader[3].ToString();
tm.VTM_Nombre = reader[4].ToString();
objmoldura.DM_Largo = Convert.ToDouble(reader[5].ToString());
objmoldura.DM_Ancho = Convert.ToDouble(reader[6].ToString());
tm.VTM_UnidadMetrica = reader[7].ToString();
objmxu.IMU_Cantidad = Convert.ToInt32(reader[8].ToString());
objmxu.DMU_Precio = Convert.ToDouble(reader[9].ToString());
objmoldura.DM_Precio = Convert.ToDouble(reader[10].ToString());
}
conexion.Close();
conexion.Dispose();
}
public void ObtenerMoldura(DtoMoldura objmoldura, DtoTipoMoldura objtipo)
{
SqlCommand command = new SqlCommand("SP_Obtener_Moldura", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@codMol", objmoldura.PK_IM_Cod);
DataSet ds = new DataSet();
conexion.Open();
SqlDataAdapter moldura = new SqlDataAdapter(command);
moldura.Fill(ds);
moldura.Dispose();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
objmoldura.PK_IM_Cod = int.Parse(reader[0].ToString());
objmoldura.VM_Descripcion = reader[1].ToString();
objtipo.PK_ITM_Tipo = int.Parse(reader[2].ToString());
objtipo.VTM_Nombre = reader[3].ToString();
objmoldura.DM_Medida = Convert.ToDouble(reader[4].ToString());
objtipo.VTM_UnidadMetrica = reader[5].ToString();
objmoldura.IM_Estado = int.Parse(reader[6].ToString());
objmoldura.IM_Stock = int.Parse(reader[7].ToString());
objmoldura.DM_Precio = Convert.ToDouble(reader[8].ToString());
objmoldura.VBM_Imagen = Encoding.ASCII.GetBytes(reader[9].ToString());
}
conexion.Close();
conexion.Dispose();
}
public void InspeccionarMolduraByTipoMoldura(DtoTipoMoldura objtipo, DtoMoldura objmoldura)
{
SqlCommand command = new SqlCommand("SP_Inspeccionar_Moldura_by_TipoMoldura", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@idTipoMold", objtipo.PK_ITM_Tipo);
DataSet ds = new DataSet();
conexion.Open();
SqlDataAdapter tipomoldura = new SqlDataAdapter(command);
tipomoldura.Fill(ds);
tipomoldura.Dispose();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
objmoldura.VBM_Imagen = Encoding.ASCII.GetBytes(reader[0].ToString());
objmoldura.DM_Medida = Convert.ToDouble(reader[1].ToString());
objtipo.VTM_UnidadMetrica = reader[2].ToString();
objmoldura.DM_Precio = Convert.ToDouble(reader[3].ToString());
}
conexion.Close();
conexion.Dispose();
}
public string obtenerUnidadMetrica(DtoTipoMoldura objtipo)
{
SqlCommand command = new SqlCommand("SP_Obtener_Unidad_Metrica", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Id", objtipo.PK_ITM_Tipo);
DataSet ds = new DataSet();
conexion.Open();
SqlDataAdapter moldura = new SqlDataAdapter(command);
moldura.Fill(ds);
moldura.Dispose();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
objtipo.VTM_UnidadMetrica = reader[0].ToString();
}
string valor = "";
valor = objtipo.VTM_UnidadMetrica;
conexion.Close();
conexion.Dispose();
return(valor);
}
public DataTable ObtenerMoldura2(DtoMoldura objmoldura, DtoTipoMoldura objtipo)
{
DataTable dt = null;
conexion.Open();
SqlCommand command = new SqlCommand("SP_Obtener_Moldura2", conexion);
command.Parameters.AddWithValue("@codMol", objmoldura.PK_IM_Cod);
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
command.CommandType = CommandType.StoredProcedure;
dt = new DataTable();
daAdaptador.Fill(dt);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
objmoldura.PK_IM_Cod = int.Parse(reader["PK_IM_Cod"].ToString());
objmoldura.VBM_Imagen = Encoding.ASCII.GetBytes(reader["VBM_Imagen"].ToString());
objtipo.VTM_Nombre = reader["VTM_Nombre"].ToString();
objtipo.VTM_UnidadMetrica = reader["MedidaUM"].ToString();
objmoldura.IM_Stock = int.Parse(reader["IM_Stock"].ToString());
objmoldura.DM_Precio = Convert.ToDouble(reader["DM_Precio"].ToString());
}
conexion.Close();
return(dt);
}
public void DetallesTipoMoldura(DtoTipoMoldura objtipo)
{
string select = "SELECT*FROM T_Tipo_Moldura where PK_ITM_Tipo=" + objtipo.PK_ITM_Tipo;
SqlCommand command = new SqlCommand(select, conexion);
conexion.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
objtipo.VTM_UnidadMetrica = (string)reader[2];
}
conexion.Close();
}
public DataTable SelectMoldurasxTipo(DtoTipoMoldura objDtoTipoMoldura)
{
DataTable dtmolduras;
conexion.Open();
SqlCommand command = new SqlCommand("SP_Listar_MoldurasxTipo", conexion);
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@tipo", objDtoTipoMoldura.VTM_Nombre);
dtmolduras = new DataTable();
daAdaptador.Fill(dtmolduras);
conexion.Close();
return(dtmolduras);
}
public DataTable ListarMoldurasPaginaInicial(DtoTipoMoldura objtipo)
{
DataTable dtmolduras = null;
conexion.Open();
SqlCommand command = new SqlCommand("SP_Detalles_Moldura_by_TipoMoldura", conexion);
command.Parameters.AddWithValue("@idTipoMold", objtipo.PK_ITM_Tipo);
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
command.CommandType = CommandType.StoredProcedure;
dtmolduras = new DataTable();
daAdaptador.Fill(dtmolduras);
conexion.Close();
return(dtmolduras);
}
public void ObtenerMoldura(DtoMoldura objmoldura, DtoTipoMoldura objtipo)
{
objDaoMoldura.ObtenerMoldura(objmoldura, objtipo);
}
public DataTable ListarMoldurasxTipo(DtoTipoMoldura objDtoTipoMoldura)
{
return(objDaoTipoMoldura.SelectMoldurasxTipo(objDtoTipoMoldura));
}
public void leerUnidadMetrica(DtoTipoMoldura dtoTipo)
{
objDaoTipoMoldura.DetallesTipoMoldura(dtoTipo);
}
public void InspeccionarMolduraByTipoMoldura(DtoTipoMoldura objtipo, DtoMoldura objmoldura)
{
objDaoTipoMoldura.InspeccionarMolduraByTipoMoldura(objtipo, objmoldura);
}
public void DetallesMolduraByTipoMoldura(DtoTipoMoldura objtipo, DtoMoldura objmoldura)
{
objDaoTipoMoldura.DetallesMolduraByTipoMoldura(objtipo, objmoldura);
}
public DataTable ListarMoldurasByTipoMoldura(DtoTipoMoldura objDtoTipoMoldura)
{
return(objDaoMoldura.ListarMoldurasByTipoMoldura(objDtoTipoMoldura));
}
public DataTable CalcularSubtotal(DtoMoldura objmoldura, DtoTipoMoldura objtipo, double cant)
{
return(objDaoMoldura.CalcularSubtotal(objmoldura, objtipo, cant));
}
public string _ObtenerUnidadMetrica(DtoTipoMoldura objDtoTipoMoldura)
{
return(objDaoMoldura.obtenerUnidadMetrica(objDtoTipoMoldura));
}
public DataTable ObtenerMoldura2(DtoMoldura objmoldura, DtoTipoMoldura objtipo)
{
return(objDaoMoldura.ObtenerMoldura2(objmoldura, objtipo));
}
public void obtenerMoldura(DtoMolduraXUsuario objdtoMolduraxUsuario, DtoMoldura objm, DtoTipoMoldura tm)
{
objDaoMolduraXUsuario.ObtenerMXU(objm, objdtoMolduraxUsuario, tm);
}
public DataTable ListarMoldurasPaginaInicial(DtoTipoMoldura objDtoTipoMoldura)
{
return(objDaoMoldura.ListarMoldurasPaginaInicial(objDtoTipoMoldura));
}
protected void gvCarrito_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Ver")
{
try
{
int index = Convert.ToInt32(e.CommandArgument);
var colsNoVisible = gvCarrito.DataKeys[index].Values;
string id = colsNoVisible[0].ToString();
objDtoMXU.PK_IMU_Cod = int.Parse(id);
DtoMoldura objDtoMoldura = new DtoMoldura();
DtoTipoMoldura dtoTipoMoldura = new DtoTipoMoldura();
objCtrMXU.obtenerMoldura(objDtoMXU, objDtoMoldura, dtoTipoMoldura);
//_log.CustomWriteOnLog("carrito de compra", "imagen" + objDtoMoldura.VBM_Imagen.ToString());
_log.CustomWriteOnLog("carrito de compra", "PK_IMU_Cod" + objDtoMXU.PK_IMU_Cod.ToString());
_log.CustomWriteOnLog("carrito de compra", "codigoMoldura" + objDtoMoldura.PK_IM_Cod.ToString());
_log.CustomWriteOnLog("carrito de compra", "descripcion" + objDtoMoldura.VM_Descripcion);
_log.CustomWriteOnLog("carrito de compra", "tipomoldura" + dtoTipoMoldura.VTM_Nombre);
_log.CustomWriteOnLog("carrito de compra", "medida" + objDtoMoldura.DM_Medida.ToString());
_log.CustomWriteOnLog("carrito de compra", "unidad metrica" + dtoTipoMoldura.VTM_UnidadMetrica);
_log.CustomWriteOnLog("carrito de compra", "cantidad" + objDtoMXU.PK_IMU_Cod.ToString());
_log.CustomWriteOnLog("carrito de compra", "precio" + objDtoMXU.DMU_Precio.ToString());
txtcodigoModal.Text = objDtoMXU.PK_IMU_Cod.ToString();
txtcodM.Text = objDtoMoldura.PK_IM_Cod.ToString();
txtDescripcionModal.Text = objDtoMoldura.VM_Descripcion;
txtprecior.Value = objDtoMoldura.DM_Precio.ToString();
txtTMModal.Text = dtoTipoMoldura.VTM_Nombre;
txtMedidaModal.Text = objDtoMoldura.DM_Medida.ToString();
txtUMModal.Text = dtoTipoMoldura.VTM_UnidadMetrica;
txtcantidadModal.Text = objDtoMXU.IMU_Cantidad.ToString();
txtPrecioModal.Value = objDtoMXU.DMU_Precio.ToString();
_log.CustomWriteOnLog("carrito de compra", "moldura" + objDtoMoldura.PK_IM_Cod);
#region ObtenerImagen
string cs = ConfigurationManager.ConnectionStrings["conexion"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("SP_GetImageById", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramId = new SqlParameter()
{
ParameterName = "@Id",
Value = objDtoMoldura.PK_IM_Cod
};
_log.CustomWriteOnLog("carrito de compra", "id" + objDtoMoldura.PK_IM_Cod);
cmd.Parameters.Add(paramId);
_log.CustomWriteOnLog("carrito de compra", "1");
con.Open();
byte[] bytes = (byte[])cmd.ExecuteScalar();
_log.CustomWriteOnLog("carrito de compra", "2");
con.Close();
string strbase64 = Convert.ToBase64String(bytes);
_log.CustomWriteOnLog("carrito de compra", "3");
Image1.ImageUrl = "data:Image/png;base64," + strbase64;
}
#endregion
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "none", "<script>$('#defaultmodal').modal('show');</script>", false);
}
catch (Exception ex)
{
_log.CustomWriteOnLog("carrito de compra", ex.Message + "Stac" + ex.StackTrace);
throw;
}
}
if (e.CommandName == "Eliminar")
{
try
{
int index = Convert.ToInt32(e.CommandArgument);
var colsNoVisible = gvCarrito.DataKeys[index].Values;
string id = colsNoVisible[0].ToString();
objDtoMXU.PK_IMU_Cod = int.Parse(id);
_log.CustomWriteOnLog("carrito de compra", "eliminar id:" + id);
_log.CustomWriteOnLog("carrito de compra", "dni:" + Session["DNIUsuario"].ToString());
objCtrMXU.eliminarMXU(objDtoMXU);
objDtoMXU.FK_VU_Cod = Session["DNIUsuario"].ToString();
UpdatePanel.Update();
gvCarrito.DataSource = objCtrMXU.listarMoldurasxusuario(objDtoMXU);
gvCarrito.DataBind();
}
catch (Exception ex)
{
_log.CustomWriteOnLog("carrito de compra", ex.Message + "Stac" + ex.StackTrace);
throw;
}
}
}