public Boolean MtdActualizarStockProductos(ClsEProductos objCar) { try { ClsConexion Objconexion = new ClsConexion(); MySqlCommand ObjCommand = new MySqlCommand(); ObjCommand.Connection = Objconexion.conectar(); ObjCommand.CommandText = "usp_E_ModificarStock"; ObjCommand.CommandType = CommandType.StoredProcedure; ObjCommand.Parameters.Add(new MySqlParameter("Acod", MySqlDbType.VarChar)); ObjCommand.Parameters.Add(new MySqlParameter("Acant", MySqlDbType.Int32)); ObjCommand.Parameters["Acod"].Value = objCar.codprod; ObjCommand.Parameters["Acant"].Value = objCar.cantprod; ObjCommand.Connection = Objconexion.conectar(); ObjCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { return(false); throw ex; } }
public Boolean MtdActualizarPlataforma(ClsEPlataforma objCar) { try { ClsConexion Objconexion = new ClsConexion(); MySqlCommand ObjCommand = new MySqlCommand(); ObjCommand.Connection = Objconexion.conectar(); ObjCommand.CommandText = "usp_E_ModificarPlataforma"; ObjCommand.CommandType = CommandType.StoredProcedure; ObjCommand.Parameters.Add(new MySqlParameter("Acod", MySqlDbType.VarChar)); ObjCommand.Parameters.Add(new MySqlParameter("Anom", MySqlDbType.VarChar)); ObjCommand.Parameters["Acod"].Value = objCar.codplat; ObjCommand.Parameters["Anom"].Value = objCar.nomplat; ObjCommand.Connection = Objconexion.conectar(); ObjCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { return(false); throw ex; } }
public Boolean MtdAgregarProveedor(ClsEProveedores objCar) { try { ClsConexion Objconexion = new ClsConexion(); MySqlCommand Objcomando = new MySqlCommand(); Objcomando.Connection = Objconexion.conectar(); Objcomando.CommandText = "usp_A_IngresarProveedor"; Objcomando.CommandType = CommandType.StoredProcedure; Objcomando.Parameters.Add(new MySqlParameter("Acod", MySqlDbType.VarChar)); Objcomando.Parameters.Add(new MySqlParameter("Anom", MySqlDbType.VarChar)); Objcomando.Parameters["Acod"].Value = objCar.rucprov; Objcomando.Parameters["Anom"].Value = objCar.nomprov; Objcomando.Connection = Objconexion.conectar(); Objcomando.ExecuteNonQuery(); return(true); } catch (Exception ex) { return(false); throw ex; } }