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